Migrating and Syncing Between Earth and Cloud

The danger in writing a discrete chapter on SQL Azure in a vast book on SQL Server is that we will prepare you to use both products, but in a rather segregated fashion. If that happened it would be a huge failing though, because the intersection between the two products is rather large. Not only can you take an agnostic approach to tools, query, and development that works with SQL Azure and SQL Server relatively interchangeably, but you can also move databases and database designs from one to the other very elegantly.

In practical terms, what does this mean? You can move a database from SQL Server to SQL Azure, and vice versa; you can also export database schemas from one platform to the other, interchangeably; ...

Get Programming Microsoft® SQL Server® 2012 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.