How to configure SQL Azure for DBConvert tools

SQL Azure connection settings for DBConvert and DBSync applications.

Windows SQL Azure is a cloud-based relational database service based on Microsoft SQL Server technologies.

First of all, you should create an account at https://www.windowsazure.com/

Let’s start from selecting MS Windows Azure connection.

Connect to SQL Azure using SSL via port 1433.

Note: SQL Azure supports only SQL Server Authentication using a login and password.

In SQL Azure every table is supposed to have a clustered index. Though it’s possible in SQL Azure to create tables without clustered indexes but when trying to add rows to a table the following error occurs:

Note: Heap tables are not allowed in SQL Azure because this sort of tables doesn’t have any clustered indexes by definition.