Latest Update – Microsoft SQL Server Migration Assistant (SSMA) v6.0 is now available.

SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project.    The new version of  SSMA,…

24

Microsoft SQL Server Migration Assistant (SSMA) v5.3 is now available.

SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project.  The new version of SSMA -…

19

Microsoft SQL Server Migration Assistant (SSMA) 5.2 is Now Available

Automating Database Migration to SQL Server 2012 SQL Server Migration Assistant (SSMA) v5.2 is now available. SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to…

65

Converting Oracle Sequence to SQL Server "Denali"

Updated 2/7/2012 Jiafei Yuan – Microsoft SQL Server Migration Assistant (SSMA) for Oracle v5.2.  The information provided below is still valid for SSMA for Oracle v5.2, but SQL Server “Denali” is changed to 2012.  Users should download the lastest SSMA for Oracle] One of the new feature in SQL Server Migration Assistant (SSMA) for Oracle v5.1 is…

1

Emulating Records and Collections via CLR UDT

        By Bill Ramos and Vishal Soni, Advaiya Inc. This blog covers how the SQL Server Migration Assistant (SSMA) for Oracle uses the SQL Server Common Language Runtime (CLR) User-Defined Types (UDT) for emulating Oracle Records and Collections.  In this blog, we will cover the following topics related to CLR UDTs: o    Declaring Record or…

6

Migrating Oracle ANYDATA to SQL Server

By Welly Lee, Pinaki Bag, and Jayakumar Tanneru. Oracle has an object data type called anydata. This data type supports wide range of data types. For example when creating a table with a column defined as anydata type, the column can store many types of data from string to numeric . SSMA does not support…

0

Migrating Oracle Materialized View to SQL Server

By Gowri Shanker and Welly Lee. This blog post discusses approaches to migrate Oracle Materialized View to SQL Server. We compare Materialized View with SQL Server Indexed View, discuss scenarios supported by Indexed View and provide suggestions you can consider for the non-supported scenarios. Converting Materialized View to SQL Server Oracle supports database object called…

2

Migrating Oracle to SQL Server using SSMA–Error O2SS0041 Illegal Identifier

When converting Oracle schema to SQL Server using SSMA, you may encounter an error when your table contains a DATE column with default value. This blog post describes the reason for the error and what you should do when you encounter this error. Consider the following example — Oracle source table: CREATE TABLE TEST.T1 (…

0

Converting Oracle UDT to SQL Server TVP

Oracle supports User Defined Type (UDT) which include object type and collection. This data type is not supported in SQL Server and SSMA does not support conversion of Oracle UDT. You may consider using SQL Server TVP when migrating your Oracle database to SQL Server. The following provides use scenarios of UDT and examples on…

1

Improving Performance of SSMA Migration Assessment

When performing migration assessment for a large schema (with thousands of objects), you can use the following to help improve performance: Run SSMA application on hardware with x64 bit Windows and memory of at least 4 GB. Force load the schema information prior performing migration assessment. SSMA, by default, perform “lazy loading” operation by reading…

0