The following steps deals with the simple preocedure to migrate your SQL Server 2005/2008 databases to SQL Azure.
1.In order to access SQL Azure, Microsoft SQL Server Management Studio needs to be upgraded to 2008 R2
2.Get the latest version of SQL Server Migration Wizard .It will migrate our SQL Server 2005/2008 databases to SQL Azure. While migrating our database it will check some compatibility issues related to our DB so that it can be migrated to SQL Azure successfully..Here is the list of compatibility issues that we should keep in mind for successful migration of database,as these points are analysed by SQL Server Migration Wizard.
(a) Syntax changes
Statement such as SELECT ‘abc’ = Col1 is not allowed in SQL Azure, instead
use SELECT Col1 AS ‘abc’ .
(b) Remove these,as they are not allowed in SQL Azure
(i) “ON PRIMARY ” keyword is not allowed as there is no concept of file group in SQL Azure.
(ii) Following Keywords are no longer allowed. Remove them from the statements: NOT FOR REPLICATION,
PAD_INDEX = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, NOT FOR REPLICATION, ROWGUIDCOL.
(c) Clustered Index
to find out tables without a Clustered Index from your database.
SQL Azure requires every table to have a Clustered Index. Use the following query
SELECT * FROM sys.objects
WHERE OBJECT_ID IN (SELECT DISTINCT object_id FROM sys.indexes WHERE OBJECT_ID NOT
3