Migrating a database to SQL Azure
SQL Azure supports many, but not all the features of Microsoft SQL Server. For example, all SQL Azure tables must have a clustered index as SQL Azure does not support heap tables. Consequently, although it is not difficult to migrate a Microsoft SQL Server database to SQL Azure, some attention must be paid when doing so. This involves identifying non-supported features and modifying the Transact SQL script so that it can run correctly in SQL Azure.
The SQL Azure Migration Wizard is a CodePlex project that can be used to analyse a Microsoft SQL Server database to identify features not supported in SQL Azure. It generates a Transact SQL script that can recreate the database and modifies, to a valid form, any statement not supported by SQL Azure. The SQL Azure Migration Wizard can then migrate the database by applying the script to a SQL Azure database and using bcp, a bulk-copy utility, to copy the data from the Microsoft SQL Server database and upload it to...
