How to configure MS SQL Azure for DBConvert tools

SQL Azure connection settings

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

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.

Was this article helpful?
0 out of 2 found this helpful
Have more questions? Submit a request


Powered by Zendesk