Introduction to SQL Azure

Migrating From SQL Server to SQL Azure

The SQL Server Migration Wizard helps you to migrate your local SQL Server 2005 / 2008 databases to SQL Azure. The wizard walks you through the selection of your SQL objects, creates SQL scripts suitable for SQL Azure, and allows you to edit / deploy to SQL Azure. You can download SQL Server Migration Wizard from http://sqlazuremw.codeplex.com/

I have copied few screen shots to demonstrate the product. However, it is fairly simple.

After selecting the Source database, next you have to select the required options from the following screen.

You can select either a new database or an existing database with the credentials to login to the SQL Azure database.

Next, the wizard will transfer data and objects to SQL Azure.

 

Not Supported on SQL Azure:

·         The backup command is not available due to the multi-tenant nature of the service. You can use BCP or SSIS instead.

·         Server options (sp_configure)

·         SQL Profiler

·         SQL traceflag

·         Data Types like HierachyID, Geography

More Information

SQL Azure Database – http://www.microsoft.com/azure/data.mspx

SQL Server News Blog – http://blogs.technet.com/dataplatforminsider/archive/2009/07/08/microsoft-sql-services-is-now-microsoft-sql-azure.aspx

SQL Azure Team Blog – http://blogs.msdn.com/ssds/

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |