SQL Azure Migration Wizard v.3.7.8

Advertisement
Advertisement

The SQL Azure Migration Wizard was developed to help you migrate your local SQL Server 2005 / 2008 databases into 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.

The SQL Azure Migration Wizard (SQLAzureMW) will let you identify a SQL Server 2005 / 2008 database that you want to migrate to SQL Azure or select an existing SQL file that has the commands you want to execute against SQL Azure.

If your source is a SQL Server database, SQLAzureMW will walk you through the different object types (i.e. Tables, Stored Procedures, Views, etc.) and let you decide which ones you want analyzed / scripted. You will be given three options:
- Script to window - Choose this option to display the SQL script to a wizard window where you can modify it before telling the wizard to script to Azure.
- Script to file - Choose this option if you want to save your SQL script to a file. You can edit this file in SQL Server Management Studio and run it from there or save it and use the wizard to load and run your file.
- Script to Azure - Choose this option is you think your database is compatible with SQL Azure. It will prompt your for your Azure credentials and then run the generated script against SQL Azure.

This wizard will automatically try to make changes to your SQL Azure tables / stored procs / view (for example, text columns will become varchar(max) columns). If you have XML schema collections, it will unbind them since XML schema collections are not supported in the current version of SQL Azure. If you have UDTs defined it will replace them with base type because UDTs are currently not supported in SQL Azure.

There are some things like hierarchyID that is not supported by SQL Azure and this program cannot replace automatically. In cases like this, you will have to refactor your code to use something else before you will be able to migrate to SQL Azure.

The SQL Azure Migration Wizard was developed ...

sql azure migration wizard, sql server database, sql azure migration, migrate database, sql server, database

 
  • SQL Azure Migration Wizard
  • 3.7.8
  • 04 Jun 12
  • wwegner
  • Windows XP, Vista, 7
  • Freeware
  • 596
  • Free
 
 

Review SQL Azure Migration Wizard

  • captcha
 
 
New Databases & Networks software
  • Net Monitor for Employees Professional  v.5.7.10The Net Monitor for Employees is employee monitoring software that allows you to see screens of remote computers or show your screen to employee. This activity monitoring software allows you to take full control of your employee remote computers.
  • Happytime RTSP Server  v.5.4Happytime RTSP Server is a complete RTSP server application. It can stream audio and video files in various formats. It can also stream video from camera and live screen, stream audio from audio device.
  • Happytime Onvif Rtsp Server  v.1.8Happytime Onvif Rtsp Server integrated all ONVIF SERVER and RTSP SERVER functions. Combining 2 services into one not only solves the compatibility problem of ONVIF PROFILE T, but also merges the duplicate code to make the target file smaller.
  • Happytime Onvif Server  v.8.8Happytime Onvif Server is a Network Video Transmitters (NVT) devices simulation program. Full support ONVIF specification, compatible with ONVIF Profile S and ONVIF Profile G.
  • ASA Data Sync  v.11.10.0.1ASA Data Sync is a professional application designed to compare and synchronize databases. The software was designed for database administrators, developers and testers that need a quick, easy and reliable way to compare and synchronize Sybase SQL ...
  • IdbSQLAdmin  v.1.1.0.1idbSQLAdmin is a lightweight tool that was designed in order to provide you with a simple means of viewing db-objects of MS SQL Server, administering users, preparing and running scripts. When you install MS SQL Server Express edition, there is no ...