O'Reilly logo

Microsoft Azure: Enterprise Application Development by Nathan Duchene, Richard J. Dudley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Migrating schema and data

The ability to create new database objects is good, but for a number of applications we'll need to migrate an existing database. For an on-premise SQL Server, to move a database, we'd commonly use a backup and restore, or detach and reattach neither of those options are available to us in SQL Azure. However, many of the other options we might use, such as DAC Packs or SSIS, are available to us in Azure. An overview of how to migrate applications and data to SQL Azure can be found at http://msdn.microsoft.com/en-us/library/ee730904.aspx.

Manually scripting objects and data

Before any scripts are manually created, there are a few scripting options we need to change to ensure our objects are created correctly on SQL Azure. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required