SQL Server Migration Assistant (SSMA) Team's Blog
How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure
Released: SQL Server Migration Assistant (SSMA) v7.3
Overview Microsoft SQL Server Migration Assistant (SSMA) v7.3 for Oracle, MySQL, SAP ASE (formerly...
Date: 02/21/2017
SSMA 7.1 Adds Support for migrating to SQL Server vNext CTP1
SQL vNext CTP1 on Windows and Linux is now a supported target platform for migration. This feature...
Date: 11/16/2016
SSMA 7.0 Adds Support for Migrating to SQL Server 2016
Microsoft has released SQL Server Migration Assistant (SSMA) 7.0 which now supports migrating to SQL...
Date: 07/11/2016
Preview release of SQL Server Migration Assistant (SSMA) for SQL Server 2016 RC0
Microsoft has released a preview release of SQL Server Migration Assistant (SSMA) that supports...
Date: 03/09/2016
Microsoft SQL Server Migration Assistant (SSMA) v6.0.1 is now available
Microsoft has released an update to SSMA 6.0 for Oracle, DB2, Sybase ASE, MySQL and Access. SSMA...
Date: 03/07/2016
Latest Update - Microsoft SQL Server Migration Assistant (SSMA) DB2 is now available.
We are happy to announce the release of the most anticipated DB2 for SSMA. You can download the same...
Date: 12/30/2014
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...
Date: 08/21/2014
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...
Date: 05/15/2014
Can’t migrate from Sybase ASA to SQL Server using SSMA
Unfortunately we never had Sybase ASA on our plans for SSMA. The plan is still intact and we still...
Date: 01/31/2013
Procedures/Functions with ROWTYPE Parameters Defaulted to NULL
The %ROWTYPE attribute in Oracle defines the particular record type of a row in a table. A common...
Date: 02/15/2012
Securing MS Linked Tables Connection Strings During Migration
Microsoft Access stores all the connection strings for the respective linked tables in a system...
Date: 02/08/2012
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...
Date: 01/30/2012
SSMA Feature Overview
TechNet Magize published an article which provide overview of SQL Server Migration Assistant (SSMA)...
Date: 08/03/2011
Announcing SQL Server Migration Assistant (SSMA) v.5.1
Automating database migration from Oracle, Sybase, MySQL, and Access database to SQL Azure and SQL...
Date: 07/12/2011
Converting Oracle Sequence to SQL Server "Denali"
Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Oracle v5.2. The...
Date: 07/12/2011
Converting MySQL LIMIT to SQL Server "Denali"
[Updated 2/6/2012 Selina Jia - Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The...
Date: 07/12/2011
How SSMA Estimates Manual Conversion Time
SSMA automates conversion of most statement. There are a few features and syntax which SSMA is...
Date: 07/11/2011
"End of Support" announcement for SQL Server Migration Assistant v4.2 family of products (support ends on July 15th, 2012)
Microsoft would like to inform customers that support for SSMA v4.2 family of products (including...
Date: 07/11/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0351 Conversion of collection method not supported
By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/29/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0350 Conversion of packaged variable (constant) data type is not supported in this release
By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/29/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0339 Cannot Convert Standalone User-Defined Types
By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers the reasons why SQL Server...
Date: 06/29/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0188 Sequence not found in source metadata
By Bill Ramos and Vishal Soni, Advaiya Inc. This blog post covers some of the reasons why SQL Server...
Date: 06/29/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0217 Call to identity sequence CURRVAL not supported
By Bill Ramos and Badal Bordia, Advaiya Inc. [Updated 2/8/2012 Jiafei Yuan - Microsoft SQL Server...
Date: 06/29/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0221 Call to identity sequence NEXTVAL not supported
By Bill Ramos and Mayank Bhanawat, Advaiya Inc. [Updated 2/8/2012 Jiafei Yuan - Microsoft SQL Server...
Date: 06/29/2011
Emulating Records and Collections via CLR UDT
By Bill Ramos and Vishal Soni, Advaiya Inc. This blog...
Date: 06/29/2011
Migrating Oracle ANYDATA to SQL Server
By Welly Lee, Pinaki Bag, and Jayakumar Tanneru. Oracle has an object data type called anydata. This...
Date: 06/21/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0347 Comparison of record or collection expressions is not supported
By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post covers the reasons why SQL Server...
Date: 06/20/2011
Migrating Oracle to SQL Server using SSMA - O2SS0264 Unable to convert cursor or cursor variable as a function or procedure call parameter
By Bill Ramos and Mayank Bhanawat, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/20/2011
Migrating Oracle Materialized View to SQL Server
By Gowri Shanker and Welly Lee. This blog post discusses approaches to migrate Oracle Materialized...
Date: 06/20/2011
Migrating Oracle to SQL Server using SSMA - O2SS0359 Cannot get description for return type of function call expression
By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post covers the reason why SQL Server...
Date: 06/20/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0330/ O2SS0331: Unable to convert CLOSE/FETCH statement
By Bill Ramos and Vishal Soni, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/20/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0157 Dynamic string for OPEN...FOR not converted
By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/20/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0055 Incorrect EXCEPTION_INIT PRAGMA parameter
By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers the reason why SQL Server...
Date: 06/20/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0054 Unable to convert EXCEPTION_INIT
By Bill Ramos and Vishal Soni, Advaiya Inc. This blog post covers the reason why SQL Server...
Date: 06/20/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0268 Hierarchical query with outer join cannot be converted
By Bill Ramos and Mayank Bhanawat, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/20/2011
Setting multiple test case call values in SSMA
SSMA for Oracle and Sybase include tester suite to automate comparison testing between the source...
Date: 06/19/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0260 Wrapped package cannot be converted
By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers the reason why SQL Server...
Date: 06/17/2011
Converting MySQL STR_TO_DATE function
MySQL provides STR_TO_DATE() standard function which convert string into date type. SSMA does not...
Date: 06/15/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0038 Hierarchical query not converted
By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers one of the reasons why SQL Server...
Date: 06/15/2011
Migrating Oracle to SQL Server using SSMA Error O2SS0007 Check constraint condition not parsed
By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers the reason why SQL Server...
Date: 06/15/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0274 Call to function with cursor return value cannot be converted in current context
By Bill Ramos and Vishal Soni, Advaiya Inc. This blog post covers the reason why SQL Server...
Date: 06/15/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0418 Failed to parse statement batch with package definition
By Bill Ramos and Vishal Soni, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/15/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0160 SELECT statement not converted
By Bill Ramos and Mayank Bhanawat, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/15/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0101 A parameter has been omitted, so there is no default value
By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post covers the reasons why SQL Server...
Date: 06/15/2011
Migrating from Sybase ASE to SQL Server – How to use SSMA for Sybase
[Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2. The...
Date: 06/09/2011
Migrating Sybase ASE to SQL Server: Similarities and Differences to Help in Planning a Migration Project
[Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server Migration Assistant (SSMA) for Sybase v5.2. The...
Date: 06/09/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0343 FORALL statement with SAVE EXCEPTION clause is not supported
By Bill Ramos and Mayank Bhanawat, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/01/2011
Migrating Oracle to SQL Server using SSMA - Error O2SS0029 Cannot convert EXIT statement
By Bill Ramos and Mayank Bhanawat, Advaiya Inc. This blog post describes why SQL Server Migration...
Date: 06/01/2011