04 Mar 2016 Bill Ramos Database Migration, Microsoft SQL Server, Microsoft SQL Server Migration Assistant (SSMA)
Microsoft has release an update to SSMA for Oracle, DB2, Sybase ASE, MySQL, and Access. SSMA simplifies the database migration process by automating all aspects of migration, including migration assessment analysis, schema, and SQL statement conversion, as well as migration testing to reduce cost and risk of your database migration project.
This new version of SSMA provides the following enhancements:
- New command in the menu to view the SSMA log file. This provides an easy way to get to the log file to help diagnose any issues that come up when using SSMA.
- SSMA for Oracle. Added support for clustered indexes. Fixed performance with querying Oracle schema. Fixed issues when setting up a connection to Azure from the console.
- SSMA for DB2. Fixed support for DB2 v9 zOS. Added support for more standard functions. Fixed issues when setting up a connection to Azure from the console.
- SSMA for MySQL. Now supports newer versions of the ODBC driver greater than v5.1.
- SSMA for Access. Fixed handing of fields with a GUID datatype and a default function. Fixed issues importing records into an Azure SQL Database.
The new releases can be found here:
- SSMA 6.0.1 for Access: http://www.microsoft.com/en-us/download/details.aspx?id=51214
- SSMA 6.0.1 for DB2: http://www.microsoft.com/en-us/download/details.aspx?id=51216
- SSMA 6.0.1 for MySql: http://www.microsoft.com/en-us/download/details.aspx?id=51218
- SSMA 6.0.1 for Oracle: http://www.microsoft.com/en-us/download/details.aspx?id=51217
- SSMA 6.0.1 for Sybase: http://www.microsoft.com/en-us/download/details.aspx?id=51215
