SQL Server Migration Assistent v5.0

Unter dem Link http://blogs.technet.com/b/dataplatforminsider/archive/2011/04/28/sql-server-migration-assistant-v5-0-is-now-available.aspx steht der neue Assistent zum Download nun zur Verfügung.

Mit diesem Tool wird die Migration von Oracle, Sybase, MySQL oder gar Access deutlich erleichtert. Der Assistent unterstützt eine Migration zu allen Versionen ab SQL 2005 (auch Express Version) sowie zu SQL Azure.

Hier ein Auszug aus den Neuerungen:

“…
– With this wave of release, customers can now migrate to any edition of SQL Server including the free Express edition.

• Support for migrating to SQL Server “Denali”
• Multi-thread data migration for improved scale and performance.
• Globalization support for migrating non-English databases to SQL Server.
• Support for installation for SSMA Extension Pack on clustered SQL Server environments.
• Sybase migration enhancements:

• Support for migration to SQL Azure
• Extended data access connectivity to Sybase ASE ADO.NET and ASE ODBC providers
• Support for conversion of case sensitive Sybase database to case sensitive SQL Server
• Extended support for conversion of Non-ANSI joins for DELETE and UPDATE statements
• Removed dependency on separate SYSDB database on target SQL Server
• Report use of Oracle’s User Defined Type in the database object and inside PL/SQL

…”