I am not a database person or planning to become one . But as part of my master’s program, I am taking a cloud database class this semester. In SQL Server 2012, Microsoft has introduced this one-click functionality to move your local (on-premise) database onto SQL Azure. You will see a new Deploy Database to SQL Azure option from SQL Management Console. I thought that was a very useful and slick option instead of using a script based mechanisms.
Clustered Index Requirement
Before you migrate your database, you may need to evaluate your database and table configuration. There is a Clustered Index requirement for SQL Azure. According to http://msdn.microsoft.com/en-us/library/windowsazure/ee336245.aspx#cir “Windows Azure SQL Database does not support tables without clustered indexes. A table must have a clustered index. If a table is created without a clustered constraint, a clustered index must be created before an insert operation is allowed on the table.” However, if you have Primary Key, it will automatically create a Clustered Index. The Clustered Index requirement is applicable for any database operation in SQL Azure. Following is an example:
In my case, my only option was to create Clustered Index using CREATE CLUSTERED INDEX command.