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...

Author: Shamik Ghosh 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...

Author: Shamik Ghosh 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...

Author: Lonny.Bastien 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...

Author: Lonny.Bastien 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...

Author: Lonny.Bastien 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...

Author: ajaykumarks 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...

Author: ajaykumarks 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...

Author: ajaykumarks 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...

Author: Angshuman Nayak 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...

Author: Han, MSFT 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...

Author: Han, MSFT 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...

Author: Han, MSFT Date: 01/30/2012

SSMA Feature Overview

TechNet Magize published an article which provide overview of SQL Server Migration Assistant (SSMA)...

Author: Welly.Lee Date: 08/03/2011

Applying Operational Profiles to Demonstrate Production Readiness Of an Oracle to SQL Server Database Port using Web Services

By James Cusick, Imran Riaz, Hubert Huang, Allen Tse, Murugan Gnanavel {james.cusick; imran.riaz;...

Author: Welly.Lee Date: 07/25/2011

Identifying Database Migration Opportunity Using MAP 6.0

Microsoft announced the release of Microsoft Assessment and Planning (MAP) toolkit 6.0. The new...

Author: Welly.Lee Date: 07/18/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...

Author: Welly.Lee 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...

Author: Welly.Lee 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...

Author: Welly.Lee 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...

Author: Welly.Lee 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...

Author: Keshav Ramarao 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos Date: 06/29/2011

Emulating Records and Collections via CLR UDT

        By Bill Ramos and Vishal Soni, Advaiya Inc. This blog...

Author: Bill Ramos 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...

Author: Welly.Lee 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Welly.Lee 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Welly.Lee 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...

Author: Bill Ramos 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...

Author: Welly.Lee 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos 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...

Author: Bill Ramos Date: 06/01/2011

Next>