SQLAzureMW v3.8.8 and v4.0.1

Rating:        Based on 21 ratings
Reviewed:  18 reviews
Downloads: 41256
Released: May 10 2012
Updated: May 10 2012 by ghuey
Dev status: Stable

Recommended Download

Application SQLAzureMW v3.8.8 Release Binary
application, 469K, uploaded May 10 - 33156 downloads

Other Available Downloads

Documentation SQLAzureMW documentation
documentation, 1717K, uploaded Jul 11 2011 - 3261 downloads
Source Code SQLAzureMigration v3.8.8 Source
source code, 758K, uploaded May 10 - 1638 downloads
Application SQLAzureMWBatchUpload v3.8.8 Release Binary
application, 247K, uploaded May 10 - 870 downloads
Application SQLAzureMWBatch tools documentation
application, 715K, uploaded Mar 21 2011 - 897 downloads
Application SQLAzureMWParseTSQL v3.5 Release Binary
application, 62K, uploaded Jan 28 2011 - 451 downloads
Application SQLAzureMWBatchBackup v3.8.8 Release Binary
application, 262K, uploaded May 10 - 480 downloads
Documentation SQLAzureMW v3.6 documentation translated to Japanese 日本語
documentation, 1464K, uploaded Mar 30 2011 - 271 downloads
Application SQLAzureMWBatch v3.6 documentation translated to Japanese 日本語
application, 706K, uploaded Mar 30 2011 - 212 downloads
Application SQLAzureMW v4.0.1 Release Binary for SQL Server 2012
application, 468K, uploaded May 10 - 16 downloads
Application SQLAzureMWBatchBackup v4.0.1 Release Binary for SQL Server 2012
application, 261K, uploaded May 10 - 2 downloads
Application SQLAzureMWBatchUpload v4.0.1 Release Binary for SQL Server 2012
application, 247K, uploaded May 10 - 2 downloads

Release Notes

Requirements
SQLAzureMW v3x requires SQL Server 2008 R2 SP1 bits to be on the same machine.

SQLAzureMW v4x requires SQL Server 2012 bits to be on the same machine.

Issues
If you have a question / issue with SQLAzureMW, please post your question via the discussion http://sqlazuremw.codeplex.com/discussions page.

Binaries
.NET 3.5 SP1
Only tested (so far) on Windows 7 RTM (should work fine on XP or Vista)

Language Translations (Special Thanks)
  • 大和屋貴仁 (Takahito Yamatoya) - Japanese
  • 安納 順一 (Junichi Anno) - Japanese
  • Oliver Hauth - German
  • Sam Vanhoutte - Dutch
  • Luis Antonio Soler Barrera – Spanish
  • Axel Guerrier – French
  • 梁琦 (Mog Liang) – Chinese
Source
Visual Studio 2008 SP1
.NET 3.5 SP1
Only tested (so far) on Windows 7 RTM (should work fine on XP or Vista)
Please let us know if you encounter any problems or difficulties

v3.8.8
  1. Fixed bug that removed USE statement and moved the check to NotSupportedByAzureFile.Config
v3.8.7
  1. Modified NotSupportedByAzureFile.config to look for a MERGE in a regex pattern "SELECT\w\W^;*\sINTO" to avoid false positives.
  2. Fixed bug with changed a nonclustered index (that had INCLUDE columns) to clustered index
v3.8.6
  1. Fixed bug when reading trace files and getting an event with no text data (null string).
v3.8.5
  1. Fixed bug for user names having a space in them. Put quotes around the name for BCP.
  2. Removed hard coded trace events to check and added key “TraceEventsToCheck” to application config file.
  3. Fixed issue with SQLAzureMW not displaying error message when SQL Server client side tools are not installed on the machine.
  4. Modified SQLAzureMWBatchUpload to do parallel processing.
v3.8.4
  1. No code change. Just modified NotSupportedByAzureFile.Config to remove check for SPARSE columns since SQL Azure now supports SPARSE columns.
v3.8.3
  1. Added Retry class
  2. Modified app.config files to include new retry key values
  3. Fixed bug when migrating SQL Azure Federation to SQL Azure Federation
  4. Put retry wrapper around SQLHelper commands
v3.8.2
  1. Fixed logic in SQLAzureMWBatchUpload to add { true | false } to -d (drop database) command
  2. Moved Regex valid SQL table character match string to app.config file. See key: SpecialTableCharacters
v3.8.1
  1. Added check for 08S01 in app.confg
  2. Fix bug in SQLAzureMWBatchBackup to enable scripting of user defined functions.
v3.8
  1. Added support for database collation
  2. Added 100 & 150 GB options for creating a database in SQL Azure
v3.7.8
  1. Fixed code to look for special character #
  2. Added support for SQL Azure Federations
  3. Modified SQLAzureMW.exe.config to allow user to specify source and target database type
  4. Modified connect to database dialog box to allos database type
  5. Getting software ready for next release of SQL Azure
v3.7.7
  1. Fixed command parsing error which caused app to crash when parsing a TSQL file.
  2. Added retry logic when getting row count from Windows Azure
v3.7.6
  1. Removed "IsSystemObject" from User Defined Tables Types (works with SQL Server, but does not work with SQL Azure).
v3.7.5
  1. Added function GetSmoServer to CommonFunc class in SQLAzureMWUtils
  2. Refined Regex search command for Backup / Kill commands
  3. Refined Regex search command for Raiserror commands
  4. I installed SQL Server 2008 R2 SP1 which is what SQLAzureMW v3.7.5 is compiled against. So if you don't have SP1 installed and you run into issues running SQLAzureMW, please let me know!

Reviews for this release

     
Excellent, Just Excellent, it worked perfectly and had no issues, my DB was fairly small but it is amazing how intuitive and simple is to use on top of fast. I can't wait to try a huge database and stress it to see how well it behaves.
by alexcons on Apr 24 at 6:57 PM
     
This is a great product very simple and usefull !!! Microsoft's guy should learn how to do jobs like this in this simple and usefull !!
by delfo on Jan 27 at 12:22 PM
     
It's an excellent combination of Generate Script Wizard and BCP - just what i needed to Migrate SQL server databases to SQL Azure- Thanks!
by ParasDoshi on Oct 3 2011 at 8:28 PM
     
The tool itself is great, if you're working on an English OS. Using Dutch resulted in errors on the BCP. After removing all the language directories (except for EN) and in the SQLAzureMW.exe.config removing the non EN language settings, it worked fine. Someone gave us version 3.4.1, which did not have the translations, and that worked instantly.
by SimoneK on Apr 12 2011 at 12:15 PM
     
Wonderful tool
by trentmswanson on Dec 20 2010 at 11:26 PM
     
Worked to help me easily migrate my data over from a SQL Server 2008 R2 database to SQL Azure. All with supporting the SQL Spatial Data Types! If only SQL Server Management Studio has some of this functionality built in. This tool seriously rocks!
by crpietschmann on Oct 11 2010 at 3:05 PM
     
Excellent work, this really moves a lot of headache to me. I faced a situation where i have to migrate from my CTP account to a new production account where i have to transfer databases with its data..migration from SQL Azure to SQL Azure went just great after modifying some of the generated script it do the whole work in hours! Great work team. Thanks, Tareq Samy
by TareqSamy on Sep 28 2010 at 12:19 PM
     
As I was using SQL Express I couldn't use the most recent release... But Version 2.1 did the trick superbly
by dworrad on Jul 14 2010 at 12:03 AM
     
Other than a small schema related bug, this tool worked great and solves a big problem for me.
by kevindwolf on Jun 19 2010 at 11:35 AM
     
3.1.8 Does not handle Encrypted stored procedures it crashes. If you get the source it is easy to see where to put a try;catch to bypass the runtime error. Ignore my rating as I am still testing it.
by e6f5xog on Mar 17 2010 at 12:38 AM
     
Worked like a charm, great tool. I was unable to perform the operation using the Import/Export wizard in the November CTP SQL Management Studio 2008, but thanks to this tool was able to move a SQL 2008 db over to azure without any problems.
by seymen on Mar 6 2010 at 9:47 PM
     
This doesn't work for me at all. When I run it, I get: Unhandled exception... Method not found: Microsoft.SqlServer.Management.Common.DatabaseEngine Type Microsoft.SqlServer.Managment.Smo.get_ServerType ()
by ericbl on Mar 1 2010 at 4:00 PM
     
This saved me so much time, it's incredible. I wonder why MS never released a tool to do this? They should buy yours. Thanks!
by robvolk on Feb 19 2010 at 4:22 PM
     
Worked great! Thanks for this tool!
by karstenj on Jan 30 2010 at 4:40 AM
     
There are issues with this tool: 1. It dosent migrate Roles, so in case there are Authorization Rules on Schema for custom Roles, Script generated for Schema will fails, since Roles does not exists in Database. 2. It replaces ntext, text, & varchar in TSQL if they are last parameter i.e. not followed by ",". If any parameter is declared in middle of list it fails. Config needs to be edited
by madhavrao on Oct 8 2009 at 6:14 AM
     
I did try to migrate the 'pubs' database from SQL 2000 and had partial success. This and SQL Azure Mgr gives some way to move forward. Tried SSIS but moved only the 'schema'. Good luck going forward.
by mysorian on Sep 23 2009 at 8:10 PM
     
a great time saving tool
by DavideB on Sep 22 2009 at 3:38 PM
     
The conversion worked well with no errors
by reddoglaw on Sep 6 2009 at 9:37 PM