Microsoft Codename "SQL Azure Compatibility Assessment" is an experimental cloud service. It’s aimed at database administrators who are considering migrating their existing SQL Server databases to SQL Azure. This service is super easy to use! You do not need an Azure account, just a Windows Live ID. Here are the steps:
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.
Watch the detailed step-by-step tutorial for this lab.
We would love to hear from you! Your input can help us build products and services with the right set of features that meet your needs. Any feedback, whether issues while using this assessment service or missing functionality that you would like to see included, is welcome.
