How do you know if your SQL database is compatible with SQL Azure and can be migrated to the cloud?
Well there is a long list of well known issues like SQL Agent and SQL CLR that are not supported, but what about those little details that no body wrote about and eventually will stop you from migrating to the cloud? It would be great if someone would tell you if migration is possible before you spend the time on a POC.
A new service was launched by the SQL Azure team for this exact reason. It is called the SQL Azure Compatibility Assessment service.
With the SQL Azure Compatibility Assessment service you can use check if your database schema is compatible with SQL Azure grammar. This service is very easy to use and does not require Azure account.
So here is what you need to do:
- Generate a .dacpac file from your database using SQL Server Data Tools (SSDT) CTP4. You can either run SqlPackage.exe or import the database into an SSDT project and then build it to generate a .dacpac. SQL Server 2005, 2008, 2008 R2, 2012 (CTP or RC0) are all supported.
- Upload your .dacpac to the "SQL Azure Compatibility Assessment" cloud service and receive an assessment report, which lists the schema objects that are not supported in SQL Azure and that need to be fixed prior to migration.
I recommend watching the following video
More Technical details about "SQL Azure Compatibility Assessment" tool can be found here