SQL Server Migration Assistant (SSMA) Team's Blog

Article
7/17/2020

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

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