SQLAzureMW v5.15.6 for SQL Server 2014

Rating:        Based on 72 ratings
Reviewed:  64 reviews
Downloads: 236310
Released: Jun 21, 2015
Updated: Jul 23, 2015 by ghuey
Dev status: Stable Help Icon

Recommended Download

Application SQLAzureMW v5.15.6 Release Binary for SQL Server 2014
application, 674K, uploaded Jun 21, 2015 - 67774 downloads

Other Available Downloads

Documentation SQLAzureMW documentation
documentation, 2024K, uploaded Sep 11, 2014 - 8432 downloads
Application SQLAzureMW v3.15.6 Release Binary
application, 674K, uploaded Jul 23, 2015 - 96153 downloads
Application SQLAzureMWBatchUpload v3.15.6 Release Binary
application, 385K, uploaded May 1, 2015 - 2388 downloads
Application SQLAzureMWBatch tools documentation
application, 715K, uploaded Mar 21, 2011 - 2649 downloads
Application SQLAzureMWParseTSQL v3.5 Release Binary
application, 62K, uploaded Jan 28, 2011 - 1051 downloads
Application SQLAzureMWBatchBackup v3.15.6.1 Release Binary
application, 411K, uploaded Jun 21, 2015 - 1885 downloads
Documentation SQLAzureMW v3.6 documentation translated to Japanese 日本語
documentation, 1464K, uploaded Mar 30, 2011 - 653 downloads
Application SQLAzureMWBatch v3.6 documentation translated to Japanese 日本語
application, 706K, uploaded Mar 30, 2011 - 519 downloads
Application SQLAzureMW v4.15.6 Release Binary for SQL Server 2012
application, 674K, uploaded Jun 21, 2015 - 49971 downloads
Application SQLAzureMWBatchBackup v4.15.6.1 Release Binary for SQL Server 2012
application, 411K, uploaded Jun 21, 2015 - 1536 downloads
Application SQLAzureMWBatchUpload v4.15.6 Release Binary for SQL Server 2012
application, 385K, uploaded Jun 11, 2015 - 1461 downloads
Application SQLAzureMWBatchBackup v5.15.6.1 Release Binary for SQL Server 2014
application, 428K, uploaded Jun 21, 2015 - 749 downloads
Application SQLAzureMWBatchUpload v5.15.6 Release Binary for SQL Server 2014
application, 385K, uploaded Jun 11, 2015 - 750 downloads
Example Northwind database example (for SQL Server test migrations)
example, 2622K, uploaded Sep 24, 2014 - 339 downloads

Release Notes

  • v4.x and v5.x require .NET Framework 4.5
  • 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.
  • SQLAzureMW v5x requires SQL Server 2014 bits to be on the same machine.
If you have a question / issue with SQLAzureMW, please post your question via the discussion http://sqlazuremw.codeplex.com/discussions page.

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
  • 小朱 (Jeff Chu) - Chinese Traditional (Taiwan)
Visual Studio 2013 SP1
.NET Framework 4.5
Works on Windows 8 and Windows 7 (should work fine on XP or Vista).
Please let us know if you encounter any problems or difficulties

v3.15.6 & v4.15.6 & v5.15.6
  1. Modified rules to allow Full Text Search for SQL DB v12
v3.15.5 & v4.15.5 & v5.15.5
  1. Fixed a bug in output status message for trace files
v3.15.4 & v4.15.4 & v5.15.4
  1. Fixed bug when getting rowcout for a table in Azure SQL DB
v3.15.3 & v4.15.3 & v5.15.3
  1. Added support for PartitionFunctions and PartitionSchemes which are now valid in Azure SQL DB v12
  2. Removed some rules from NotSupportedByAzureSQLDbV12.config because they were no longer valid.
v3.15.2 & v4.15.2 & v5.15.2
  1. Fixed SQLAzureMWBatchUpload to put around database when dropping db.
  2. Removed Preview from SQL Database v12
v3.15 & v4.15 & v5.15
  1. Added feature to analyze all SQL files beneath a specified folder. You will be given the option to overwrite these files at the end of the process.
v3.14 & v4.14 & v5.14
  1. Supports Synonyms
  2. Supports Azure SQL Database Preview V12
v3.12 & v4.12 & v5.12
  1. Fix program to not check for Sparse columns on a SQL Server 2005 database.
v3.11 & v4.11 & v5.11
  1. Added Support for new standard service tier S0
  2. Fixed bug in SQLAzureMWBatchUpload when creating a "Basic" database
  3. Moved all versions to .NET Framework 4.5
v3.10 & v4.10 & v5.10
  1. Removed support for SQL Azure Federations
  2. Added support for creating databases for basic, standard, and premium service tiers
  3. Changed connect to server to remember server credentials if you want them saved (see bottom of connect to server screen).
v3.9.17 & v4.0.20 & v 5.0.1
  1. SQL 2014 SMO changed the way it generates SQL script which required me to refactor how I entered "GO" in the script.
v3.9.16 & v4.0.19 & v5.0
  1. Got rid of dependency on SQL Server MessageBox
  2. Worked around problem where SMO does not return server, username, and password when connecting to SQL Database (Azure).
  3. Created v5.0 to work with SQL Server 2014.
  4. SQL Server 2014 made changes to spatial indexing which won't work if turned into clustered index. Modified code to work for that
  5. SQL Server 2014 SMO has a bug when creating drop if exists script on SQL Database. There is no fix for this, so I disabled that feature when exporting from SQL Database.
v3.9.15 & v4.0.18
  1. Added -C RAW to BCP input in SQLAzureMW.exe.config
  2. Added Russian for BCP in SQLAzureMW.exe.config
  3. Escaped password when connecting to SQL Server
v3.9.14.1 & v4.0.17.1
  1. Changed Regex rule for replacing table hints without a "WITH" statement.
  2. Changed SQLAzureMWBatchBackup to use recognize options for ScriptDropCreate and ScriptTableAndOrData in config file.
v3.9.14 & v4.0.17
  1. SQLAuzreMW has same code base for both SQL Server 2008 R2 and SQL Server 2012. It turns out that SQL Server 2008 R2 is not FEDERATION aware while SQL Server 2012 is FEDERTION aware. This causes scripting differences between engines so I modified the code in the SQLAzureMWUtils library to work correctly with both engines.
v3.9.13.1 & v4.0.16.1
  1. Fixed bug in not putting FEDERATION name between brackets to allow for special characters.
v3.9.13 & v4.0.16
  1. Fixed a bug with multi threading in the BCP upload process. Thanks to jarete for identifying the issue and providing a solution!
v3.9.12.1 & v4.0.15.1 SQLAzureMWBatchUpload
  1. Fixed bug that only allowed application to exit if all threads were successful.
v3.9.12 & v4.0.15
  1. Added the capability of doing a search and replace of a sub string found within the rules engine. For example, you have SELECT col1, col2 FROM Employees (NOLOCK) and now you want to replace "(" with "WITH (" so that the results would be SELECT col1, col2 FROM Employees WITH (NOLOCK). Look for XML property "SearchReplace" in NotSupportedByAzureFile.config to see an example.
v3.9.11 & v4.0.14
  1. Added dependency checker to see if Microsoft.SqlServer.Smo and Microsoft.ExceptionMessageBox are on the machine SQLAzureMW is being run on. The dependency information is stored in Dependencies.xml.
v3.9.10 & v4.0.13
  1. Added rule in NotSupportedByAzureFile.Config to remove DATA_COMPRESSION from indexes.
  2. Added BCP error handling to examine message to see if it is a warning in which case do nothing.
v3.9.9.1 & v4.0.12.1
  1. Modified SQLAzureMW to allow you to specify a default collation.
v3.9.9 & v4.0.12
  1. No real bug fixes in this release, but I found that WinForms differs from Windows 7 vs. Windows 8. So, I rebuilt the application on the Windows 8 OS and now the fonts look better for Windows 8 and still seem to run on Windows 7. If you have any font issues, let me know.
v3.9.8 & v4.0.11
  1. SQL Azure Migration Wizard is proud to announce its seventh translation into an international language: Chinese Traditional (Taiwan)! 小朱 (Jeff Chu) did all of the translation work to Chinese Traditional (Taiwan) and deserves all of the credit.
v3.9.7 & v4.0.10
  1. Fixed bug where ALTER TABLE statements did not go through compatibility checker and parser.
v3.9.6.1 & v4.0.9.1 SQLAzureMWBatchBackup
  1. Added the capability to select which database objects you want to backup. To specify which objects to backup, you will need to edit the ObjectSelector.xml file. Inside of that file is documentation on how it works.
v3.9.6 & v4.0.9
  1. Fixed code to handle an empty string password.
v3.9.5 & v4.0.8
  1. Fixed code to take all table constraints and move it to the end of generated script.
v3.9.4 & v4.0.7
  1. Fixed BCP output commands to put quotes around password
v3.9.3 & v4.0.6
  1. Changed some SQL Azure to SQL Database
  2. Fixed BCPArgs parsing to remove need for special character checking
v3.9.2 & v4.0.5
  1. Modified script to move all foreign key constraints to end of TSQL Script
  2. Fixed bug in SQLAzureMWBatchUpload to check for server type in upload process.
v3.9.1 & v4.0.4
  1. Modified code to not rely on SMO for target server.
v3.9 & v4.0.3
  1. Fixed a bug in character counting (look for CrLf or Cr)
v3.8.9 & v4.0.2
  1. Fixed a bug with identifying comments in SQL to avoid false positives. The major impact of this was on parsing SQL text files.
v3.8.8 & v4.0.1
  1. Fixed bug that removed USE statement and moved the check to NotSupportedByAzureFile.Config
  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
  1. Fixed bug when reading trace files and getting an event with no text data (null string).
  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.
  1. No code change. Just modified NotSupportedByAzureFile.Config to remove check for SPARSE columns since SQL Azure now supports SPARSE columns.

Reviews for this release

This made it so easy, I almost felt bad about billing my customer for the data transfer!
by ChadWJames on Sep 5, 2014 at 6:57 PM
Sequences are not getting scripted from Azure database...
by chpurna on Sep 16, 2016 at 12:33 PM
This made it so easy!! Perfect migration from AWS RDS to Azure
by fobarros on Jul 23, 2016 at 2:21 PM
Very Powerful tool and did exactly the same as described in description.
by vaibhav88sharma on Jun 2, 2016 at 4:03 AM
AWS Data Migration- Ever so sweet. After reading amazon import/export docs for 30 minutes, I found this. 20 Seconds to move all my data over
by edboyle on May 25, 2016 at 12:50 AM
SQL 2012 -> AWS SQL 2014 was nearly effortless. Highlighted one error in extended properties that we need to fix.
by mikeconwell on Apr 7, 2016 at 6:25 PM
As a newcomer to Azure SQL Databases, this migration tool helped me past the first couple of hurdles in understanding what it is, and how to migrate databases over to it. It provides an intuitive step by step process, you learn very quickly about any limitations or incompatibilities of your schema with the Azure SQL Database through helpful tips and reports. Any issues I had in getting started were addressed immediately on the discussion board. A very powerful and well designed utility.
by bmather on Mar 7, 2016 at 5:28 PM
made export from SQL Server 2014 to SQL Azure v12 very easy, no problems at all.
by alonso01 on Dec 24, 2015 at 8:53 PM
It's save my day. I transfer a database of 1,7gb for azure with a few clicks. Thanks very much for developers!!
by ric3ca on Dec 4, 2015 at 11:46 AM
Thank you! This tool has saved my bacon a few times - currently migrating a large-ish database to SQL Azure. After fighting with the tools in Visual Studio and SQL Management Studio (I like to suffer, apparently) I regained my sanity and came back to this. Such an excellent tool
by jamief on Jun 27, 2015 at 11:37 AM
Successfully migrated database from SQL Server 2014 to SQL Server Express in Amazon RDS. I definitely have to look at this awesome project's source code soon.
by kendtimothy on Jun 26, 2015 at 7:05 AM
Allowed me to transfer data from a vs15 localdb\MSSQLLocalDB database to sql14 on-premises and azure sql target which made transition of work from dev wks to integration environment so much less painful. Thank you for continuing to maintain this tool for use with the latest and greatest vstudio installed sql localdb, on-premises and azure environments.
by robertob on Jun 5, 2015 at 11:21 PM
Did the job and provided great logging of what was happening in each step.
by bradpatton on May 27, 2015 at 12:59 PM
Exporting from 2012 to 2008R2 was a breeze as well. Only tool I could find that could do it.
by jpalo on Feb 26, 2015 at 10:04 AM
Worked perfectly! It especially liked the detailed status of what was occurring during the migration process.
by h0jack on Jan 26, 2015 at 9:14 PM
Worked perfectly to move from SQL Server to SQL Azure. I needed to update the IDENTITY seeds along the way and I was very happy that I was able to edit the interim script halfway through the process and have it accept those changes.
by elithompson on Nov 6, 2014 at 12:31 PM
Incredibly useful! Moved schema and data (100 000 rows) from LocalDb to SQL Azure without a single error!
by memark on Oct 21, 2014 at 1:49 PM
Very easy to use, useful and lightweight tool. Love it!
by sasapop on Aug 11, 2014 at 4:30 PM
Great tool and very fast.
by David1984 on Apr 7, 2014 at 9:22 AM
Perfectly working tool and helpful support!
by Maorrin on Mar 11, 2014 at 10:42 AM
muy bueno excelente, lo unico que he intentado cargar una exuberante cantidad de datos y no se han podido migrar
by FrankLemus on Mar 3, 2014 at 8:12 PM
Flawless many thanks.
by planetClaire on Mar 3, 2014 at 4:21 AM
very useful tool
by gbas on Feb 19, 2014 at 10:20 AM
I used this tool to migrate a large quantity of data into an Azure database. Excellent work gentlemen!
by bemiller on Jan 21, 2014 at 4:28 PM
I did my first migration from SQL 208R2 to Azure long hand and lost all the identity fields. This tool took less than 5 minutes, including downloading, created the Azure DB for me and migrating all of my tables and procedures perfectly. What a fantastic tool. I can see me using this again and again. Great job guys.
by jamesjl on Jan 13, 2014 at 12:44 PM
Very nice tool! Quick and easy! A must-have tool. :)
by wooncherk on Oct 28, 2013 at 4:10 AM
Even though this seems to have been written mostly as a way to migrate from/to Azure, I was able to use this gem of fine software engineering to migrate databases installed in error on a SQL Server 2012 instance that needed to be on a 2008 R2 instance -- and I had nary a problem. What is most striking is how fast and unobtrusive it is.
by trellus on Oct 17, 2013 at 7:49 PM
I have been fighting for weeks trying to migrate an Umbraco database to azure. This tool made it happen in minutes. Can't thank you guys enough for making this tool. Simple, to the point, and functional. Well done!
by charlesz on Aug 25, 2013 at 5:38 PM
Absolute lifesaver thanks so much. I spent hours messing around with scripts and generally getting in a right old muddle. This brilliant wizard helped me migrate my db to azure in 5 minutes. Well done the devs
by wilkov on Jun 18, 2013 at 1:29 PM
Just Signed In to say thanks for this Gem. Solved great problem for me as a beginner. Thank again. Faraz
by Faraz321 on May 7, 2013 at 2:46 PM
Worked perfectly. Added cluster indexes and cleaned up the aspnet_Membership error automatically. Literally 5 minutes to convert my local DB to Azure. Wonderful job!
by dmiser on May 1, 2013 at 10:35 PM
All worked first time getting from SQL2008 to Azure. Took about 5 minutes.
by robdavey555 on May 1, 2013 at 6:06 PM
I was able to transfer my SQL Server 2008 R2 with millions of rows to Azure without any issues. Awesome work people.
by LidanHackmon on Mar 25, 2013 at 3:07 PM
Simple and perfect! Thanks!
by GerryW4 on Mar 14, 2013 at 3:02 PM
Simple and OH SO Functional! Transferred a SQL 2012 DB to Azure in < 5 min - AWESOME work!
by viperguynaz on Mar 6, 2013 at 5:39 AM
Amazing product
by ravs53 on Mar 2, 2013 at 4:43 AM
Simply amazing. I had spent 3 hours fighting with the TSQL code trying to changing it from SQL 2012 to Azure, it was so painful . Then this migration kit did it in less than 10 seconds and was perfect code for my entire database.. what else can someone ask for.. Thanks a lot. this is just outstanding work.
by oscar_agreda on Feb 14, 2013 at 4:18 PM
Great tool; a nice GUI to BCP. Could you please add support for FREETEXT (containstable) because I want to move data from one SQL Server to another and both support FREE TEXT even though SQL Azure does not at present?
by trisys on Feb 7, 2013 at 5:08 PM
Must have!!!! Very nice tool!!
by lossardos on Jan 26, 2013 at 12:21 PM
Really neat and powerful tool. Ported my database and data to azure. Added missing indexes azure could not live without :).
by rasmuschristensen on Jan 24, 2013 at 12:09 PM
Saved me a ton of work getting my db to SQL Azure.
by fhanggi on Nov 20, 2012 at 6:06 AM
works well, without fuss!
by ctolkien on Sep 26, 2012 at 6:38 AM
Very nice tool!!!
by MartinJensen on Aug 15, 2012 at 7:51 AM
Really really fast and useful product. I really love it.
by aliaga on Jul 29, 2012 at 8:06 PM
Just a fabulous tool. Worked fast too!
by kjopc on Jul 25, 2012 at 4:45 PM
This tool worked very well for me on the first try. Migrated nopcommerce from SQL Server 2008R2 (express) on my local machine to SQL Database in Azure.
by tdavis76 on Jul 19, 2012 at 2:37 AM
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, 2012 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, 2012 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