Migrating a database to a SQL Database
The SQL Database supports many but not all the features of Microsoft SQL Server. For example, all SQL Database tables must have a clustered index, as the SQL Database does not support heap tables. Consequently, although it is not difficult to migrate a Microsoft SQL Server database to the SQL Database, some attention must be paid when doing so. This involves identifying the features that are not supported and modifying the Transact SQL script so that it can run correctly in Azure SQL Database.
The SQL Database Migration Wizard (http://sqlazuremw.codeplex.com/) is a CodePlex project that can be used to analyze a Microsoft SQL Server database to identify the features not supported in the SQL Database. It generates ...
Get Microsoft Azure Development Cookbook Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
