RequirementsSQL Azure Migration Wizard v3x requires SQL Server 2008 R2 SP1 bits to be on the same machine. IssuesIf 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
SourceVisual 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.2
- Fixed logic in SQLAzureMWBatchUpload to add { true | false } to -d (drop database) command
- Moved Regex valid SQL table character match string to app.config file. See key: SpecialTableCharacters
v3.8.1
- Added check for 08S01 in app.confg
- Fix bug in SQLAzureMWBatchBackup to enable scripting of user defined functions.
v3.8
- Added support for database collation
- Added 100 & 150 GB options for creating a database in SQL Azure
v3.7.8
- 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
v3.7.7
- Fixed command parsing error which caused app to crash when parsing a TSQL file.
- Added retry logic when getting row count from Windows Azure
v3.7.6
- Removed "IsSystemObject" from User Defined Tables Types (works with SQL Server, but does not work with SQL Azure).
v3.7.5
- Added function GetSmoServer to CommonFunc class in SQLAzureMWUtils
- Refined Regex search command for Backup / Kill commands
- Refined Regex search command for Raiserror commands
- 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!
|
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 1: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 9: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 1:15 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 4: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 1: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 1: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 12:35 PM
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 1: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 10: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 5: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 5:22 PM
Worked great! Thanks for this tool!
by
karstenj
on
Jan 30 2010 at 5: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 7: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 9:10 PM
a great time saving tool
by
DavideB
on
Sep 22 2009 at 4:38 PM
The conversion worked well with no errors
by
reddoglaw
on
Sep 6 2009 at 10:37 PM