|
| Released: |
Feb 2 2010
|
| Updated: |
Feb 3 2010 by ghuey |
| Dev status: |
Beta
|
| Rated: |
based on 5 ratings (Add your own rating)
|
| Reviewed: |
5 reviews
|
| Downloaded: |
2940 downloads |
| Wiki link: |
[release:32334] |
v3.1.5
- Removed search for dbo.sysobjects from tables in NotSupportedByAzureFile.config
- Fixed script engine to handle a single TSQL file with no "GO" statements in it
v3.1.4
- Modified SQLAzureMW to put "GO" between Tables / Views and their indexes. This is needed when parsing SQLAzureMW TSQL output from a file. Without the "GO", then the indexes were being parsed with Table / View rules thus causeing syntax errors on generated TSQL.
v3.1.3
- Added option to script table triggers. By default this option is set to true. You can change this option during runtime via the Advanced options or change it in the app.config (SQLAzureMW.exe.config) file: <add key="ScriptTableTriggers" value="true"/> where the value is "true" for script triggers and "false" for don't script table triggers.
v3.1.2
- Modified SQLAzureMW to give you the option to delete (or not) temporary BCP output files. This setting is found in the app.config (SQLAzureMW.exe.config) file: <add key="DeleteBCPOutputFiles" value="false"/> where the value is "true" for delete and "false" to save.
v3.1.1
- Added StandardOutputEncoding to BCP upload command
v3.1
- Fixed logic flaw when a table had only one record, it would not get uploaded.
- Fixed create database statement to put supplied database name between two square brackets { i.e. [DatabaseName] }
v3.0
- Modified tool to allow for 1) SQL Server to SQL Azure, 2) SQL Azure to SQL Server, and 3) SQL Azure to SQL Azure Migration. Note that when migrating from SQL Azure, User Defined Data Types are not supported. So, if you have any tables or UDDTs, they will not be migrated.
- Modified tool to allow you to specify code page for BCP
- Modified tool to let you specify "Target" server and the ability to not only create a database but to delete an existing database as well.
v2.1
- Modified app to put BCP output regex search string into SQLAzureMW.exe.config file. If you are running a language other than english, you will need to modify the regex search patterns in the config file to reflect your language. See config file for more documentation.
v2.0
- Simplified work flow so that you can choose which objects to script on one page
- Added capability to analyze a SQL Profile trace file
- Removed Output Options page since there is a save button on the results page.
- Moved Options page to Advanced button on “Choose Objects” page
- Added override for compatibility checking (Check all, use default values in app.config, or Don’t do any checks)
- Change "// BCPArgs" to "-- BCPArgs"
v.1.9.1
- Changed a couple Regex string in the NotSupportedByAzureFile.config
- Added a NotSubStr to NotSupportedByAzureFile.config to better refine identification of not compatible string.
v1.9
- Fixed bug in retry logic to actually sleep before retrying command
v1.8
- Added dependency sorting for tables, views, stored procedures, user defined functions and triggers.
v1.7
- Fixed retry logic to pause when connection gets reset
- Fixed BCP retry logic to get number of records successfully uploaded before failure and to try again after last successful batch.
Binaries.NET 3.5 SP1 Only tested (so far) on Windows 7 RTM (should work fine on XP or Vista) 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
|
|
Worked great! Thanks for this tool!
by karstenj on Jan 30 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
Are you sure you want to delete your review?
Rate this release |
How do you like SQL Azure Migration Wizard v3.1.5?
Select a rating, at least one star.
|
|
|
(optional)
|
400 characters left
|
Questions?
This space is for reviews only. Use Discussions if you have questions. |
|
Cancel
|
|
|