Migration Expert Zone
Sign up to receive our monthly newsletter!
Dell recommends Windows 8.

Windows Server Migration

Microsoft Releases SQL Server Migration Assistant 5.2

Tired of Oracle or MySQL? Ready to leave Access behind? When you're ready to embrace Microsoft SQL Server, there's a wealth of assistance and automation available.

    For those looking to migrate to SQL Server 2008 or SQL Azure from Oracle, Sybase, MySQL, or even Microsoft Access, Microsoft has just released the latest version of their SQL Server Migration Assistant (SSMA) 5.2. 

    SSMA automates all aspects of migration, including assessment and analysis, schema and SQL statement conversion, data migration, as well as migration testing, all of which help to reduce costs and risks of your database migration project.  Version 5.2 includes the following major enhancements:

    • Support for conversion of Oracle %ROWTYPE parameters with NULL default
    • Support for conversion of Sybase’s Rollback Trigger
    • Better user credential security to support Microsoft Access Linked Tables

    According to the Microsoft SQL Server Team Blog post announcing the new version, the package includes tools such as:

    • Database Migration Analyzer, which assesses and reports on the complexity of the source database for migration to SQL Server. The generated report includes detailed information on the database schema, percentage of the schema objects that can be converted by the tool, and an estimate of how many hours it will take to migrate manually those schema objects that cannot be converted automatically.
    • Schema Converter, which automates the conversion of schema objects (including programming code inside packages, procedures, and functions) into equivalent SQL Server objects and T-SQL dialect. The tool lets you customize the conversion from hundreds of project setting options according to your specific business requirements. A report is generated for any object statement not supported by automatic conversion. You can drill down to each of the migration issues and obtain side-by-side comparisons between the original source code and the converted source code, as well as make necessary modifications directly from the SSMA user interface.
    • Data Migrator migrates data from the source database to the SQL Server using the same conversion logic and type-mapping specified in the project setting during schema conversion.
    • Migration Tester facilitates unit testing of the converted program in SQL Server.

    Intrigued?  Click here to visit the team site.  The Microsoft SQL Server Migration Assistant v5.2 can be downloaded from the following links, based on which database you’re running currently:

    Launch the download of SSMA for Oracle.

    Launch the download of SSMA for Sybase.

    Launch the download of SSMA for MySQL.

    Launch the download of SSMA for Access.