|
| Released: |
Nov 7 2009
|
| Updated: |
Nov 7 2009 by ghuey |
| Dev status: |
Beta
|
| Rated: |
based on 4 ratings (Add your own rating)
|
| Reviewed: |
4 reviews
|
| Downloaded: |
1085 downloads |
| Wiki link: |
[release:32334] |
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.
v1.6
- Added save button on results pages.
v1.5
- Added chunking to BCP upload (see documentation for more info)
- Added Option for searching different type of TSQL groups (i.e. Replication, Entended stored procs, SQL Agent ...). You can turn these categories on or off in the SQLAzureMW.exe.config file or during runtime.
- Modified NotSupportedByAzureFile.config to create a generic message string and allow you to override if you want.
- Updated SQLAzureMW documentation
v1.4
- Modified code to reconnect to SQL Azure if connection timed out during BCP upload process.
- Added option to create 1GB or 10GB database.
v1.3
- Modified code to allow for User Defined Types. They are now supported.
- Added search for CREATE XML INDEX since it is not supported.
v1.2
- Modified NotSupportedByAzureFile.config to remove search for TEXT, NTEXT, and IMAGE!!!! SQL Azure CTP2 supports these data types. Note, these are still planed to be removed in future releases of SQL Server.
- Fixed cancel button to be enabled when uploading to SQL Azure
- Modified BCP args to -E -q -n
v1.1
- Added a cancel button so that you can cancel while processing
- Added a scroll toggle so that during processing you can keep the control from scrolling down to the bottom.
- Fixed an error in BCP command to allow the passing of the SQL Server instance name.
- Added color to the SQL results to better identify error messages
v1.0
- Added data migration via BCP. Note that when you specify your SQL Azure username, specify your user name as "username@server". Also note that data migration only works on the latest release of SQL Azure (Server Location: South Central US).
- Modified App.Config to allow you to specify your Options. For example: If you do not want to migrate data, you can turn this off by modifying the App.Config file and changing ScriptData to false. I.E.
<add key="ScriptData" value="false"/> You can also change it during runtime if you want. v0.3.1
- Added scripting for object type Role
RequiredSQLAzureMW uses SQL Server 2008 SMO to script your database. Therefore, SQLAzureMW requires SQL Server 2008 SMO installed on the machine that it is running on. The easiest way to get the SMO assemblies is to install SQL Server 2008 Express Edition found here: http:/www.microsoft.com/express/sql/download (choose Runtime with Management Tools). Then everything should work. 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
|
|
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 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 at 9:10 PM
a great time saving tool
by DavideB on Sep 22 at 4:38 PM
The conversion worked well with no errors
by reddoglaw on Sep 6 at 10:37 PM
Are you sure you want to delete your review?
Rate this release |
How do you like SQL Azure Migration Wizard v1.9.1?
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
|
|
|