The new and latest version of SSMA is available now for download. The new version brings array of new enhancements.
For beginners , SQL Server Migration Assistant known as SSMA is a tool which helps us to move variety of database to SQL Server Database. It assists us in schema migration and data migration from other database to SQL Server Database.
In my future post (coming up soon) I will be showing how we can migrate from other database to SQL Server.
Following are the enhancements SSMA 6.0 gives us.
- Materialized View support for Oracle
- Memory Optimized tables for Oracle
- Improved Azure SQL DB code conversion
- Extension pack functionality moved to schema to support Azure SQL DB
- Performance improvements tested for databases with over 10k objects
- UI improvements for dealing with large number of objects
- Highlighting of “well known” LOB schemas (so they can be ignored in conversion)
- Conversion speed improvements
- Show object counts in UI
- Report size reduction by more than 25%
- Improved error messages for unparsed constructs.
Download it from here
SSMA for Access: http://www.microsoft.com/en-us/download/details.aspx?id=43690
SSMA for MySQL: http://www.microsoft.com/en-us/download/details.aspx?id=43688
SSMA for Oracle: http://www.microsoft.com/en-us/download/details.aspx?id=43689
SSMA for Sybase: http://www.microsoft.com/en-us/download/details.aspx?id=43691
You can also post your question to SSMA team at : ssmahelp@microsoft.com
So get on to SQL now :)
Happy Learning
