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.