Share via


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

Next>