SQL Azure Migration Wizard 3.7.8

SQL Azure Migration Wizard 3.7.8 is known as an easy yet efficient application which allows you to migrate your SQL Server 2005/2008 databases to SQL Azure. SQLAzureMW will analyze your source database for compatibility issues and allow you to fully or partially migrate your database schema and data to SQL Azure.

SQL Azure Migration Wizard (SQLAzureMW) is an open source application that has been used by thousands of people to migrate their SQL database to and from SQL Azure. SQLAzureMW is a user interactive wizard that walks a person through the analysis / migration process. One of the main requests from the SQLAzureMW community was to take the user interactive wizard and make it command line driven interface so that it could be used in an automated backup process to back up their SQL Azure schema / data to a data store for disaster recovery.

• SQLAzureMWBatchBackup:
• • This is used to create a backup of a database schema and data. The data is downloaded via BCP. The TSQL output from SQLAzureMWBatchBackup can be used by SQLAzureMW or SQLAzureMWBatchUpload.
• SQLAzureMWBatchUpload:
• • Takes the output from SQLAzureMW or SQLAzureMWBatchBackup and runs it against the target SQL Azure (or SQL Server) server.

The SQLAzureMW tools greatly simplify schema analysis and migration process. If you don’t have an SQL Azure account and have been thinking about moving your data to the cloud (SQL Azure), but have been afraid to try because of “unknowns” like cost, compatibility, and effort? SQL Azure Migration Wizard SQLAzureMW is a free set of open source applications that have been developed by the database community to help you address these issues. SQLAzureMW will help you analyze your SQL Server database for compatibility issues and will migrate your schema and data to SQL Azure. The SQLAzureMW team has worked with Microsoft to take advantage of the Try Windows Azure Platform 30 Day Pass. The Windows Azure platform 30 day pass includes the following resources:

• Windows Azure
• Compute: 750 hours of a Small Compute Instance
• Storage: 20 GB of Storage with 50,000 Storage Transactions
• Data Transfers: 20 GB out / Unlimited inbound data transfer
• Relational Database: 1 GB Web Edition SQL Azure database
• Access Control: 100,000 Transactions
• Service Bus: 2 Connections
• AppFabric Caching: 128MB cache

Enhancements:

• Fixed code to look for special character #
• Added support for SQL Azure Federations
• Modified SQLAzureMW.exe.config to allow user to specify source and target database type
• Modified connect to database dialog box to allos database type
• Getting software ready for next release of SQL Azure

Requirements:

• SQLAzureMW and tools requires SQL Server 2008 R2 SP1 bits to run.
• SQLAzureMW also requires BCP version 10.50.1600.1 or greater