Roberto Brunetti

SQL Azure Migration Wizard 3.7.7

Uscito il 19/8 la nuova versione del tool di migrazione. Queste le novità delle versioni 3.7.x

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

1. Removed "IsSystemObject" from User Defined Tables Types (works with SQL Server, but does not work with SQL Azure).

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!

1. Added code for SQL Azure Federation analysis and migration (note that there is still some leg work required mid migration to define federated column)
2. Added “TargetServer” key to SQLAzureMW.exe.config. TargetServer has three values:
   1. TargetServerSQLAzure --> SQL Azure
   2. TargetServerSQLAzureFed --> SQL Azure Federation
   3. TargetServerSQLServer --> SQL Server (no analysis is done)
3. Modified UI since analysis now depends on target server.
4. Changed SQLAzureMWUtils structure and added SQL Azure Federation functionality
5. Added SQL Azure Federation connect dialog and target database display.

1. Fixed an error in NotSupportedByAzureFile.Config on IndexOptions not removing ")" (line 27)
2. Added Schema section to NotSupportedByAzureFile.config
3. Fixed bug when checking for BCP table name. Added $ and & as valid characters
4. Modified source results screen to move progress bar and status to outside of tab control
5. Changed results view scroll to be off by default. This will save you several minutes of time on large databases. You can always check "Auto Scroll Display" to turn it back on.

1. Moved ServerConnect.cs to SQLAzureMWUtils project
2. Fixed an error so that when you select "Data Only" in the advanced options, that you actually get "Data Only"
3. Added ConnectionStringTrusted and ConnectionString to SQLAzureMW.exe.config file to enable modification of connection string if needed.
4. Added BCPSQLAzureErrorCodesRetry to SQLAzureMW.exe.config. This allows you to specify which SQL error codes to retry on. See Error Messages for error code definition.

1. Modified FOR XML search in NotSupportedByAzureFile.Config that took Regex a long time to parse on large strings.
2. Fixed an error where SQLAzureMW would never finished (when uploading schema with no data).
3. Modified SQLAzureMW to update process status on BCP upload commands.
4. Fixed an error in object count to correctly reflect number of objects / BCP commands against target server