Wednesday, July 27, 2011

New version of SQL Server Migration Assistant released

A new version of SQL Server Migration Assistant was just released which now supports a broader range of SQL Server platforms including the upcoming release of SQL Server "Denali"

http://blogs.msdn.com/b/ssma/archive/2011/07/12/announcing-sql-server-migration-assistant-ssma-v-5-1.aspx

On a more interesting note, SQL Server "Denali" introduces the concept of sequences which have been present in Oracle but compared to identity key values in SQL Server.  The major discrepancy in the past between the 2 platforms differed in the way that the values were stored.  Whereas Oracle stored the sequence information independent of the table, SQL Server always stored this information directly with the table information.  With the new introduction of SQL Server sequences in "Denali", it will be interesting to see how future Oracle migrations to SQL Server "Denali" occur.

http://blogs.msdn.com/b/ssma/archive/2011/07/12/converting-oracle-sequence-using-ssma-for-oracle-v5-1.aspx

No comments:

Post a Comment