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

Migrating a PHP Application using MySQL to SQL Server running PHP on IIS

By Bill Ramos, Advaiya Inc. In this blog post, I’ll walk through an example of migrating a PHP...

Author: Bill Ramos Date: 06/01/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0408 Collection or Record Type is not supported

By Bill Ramos and Vishal Soni, Advaiya Inc. This blog post covers the reasons why SQL Server...

Author: Bill Ramos Date: 06/01/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0104 Unpackaged function call is missing a parameter

By Bill Ramos and Mayank Bhanawat, Advaiya Inc. This blog post describes why SQL Server Migration...

Author: Bill Ramos Date: 06/01/2011

Access to SQL Server Migration: Understanding the Assessment Report and Error List

The SQL Server Migration Assistant for Access assessment report displays the results from converting...

Author: Bill Ramos Date: 05/27/2011

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

Author: Welly.Lee Date: 05/26/2011

How to: Migrate to a schema in an existing database using SSMA

SSMA, by default, migrate to dbo schema in a SQL Server database with the same name as source...

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

Converting Oracle UDT to SQL Server TVP

Oracle supports User Defined Type (UDT) which include object type and collection. This data type is...

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

Improving Performance of SSMA Migration Assessment

When performing migration assessment for a large schema (with thousands of objects), you can use the...

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

Migrating Oracle to SQL Server using SSMA - Error O2SS0407: Unsupported collection key type

By Bill Ramos and Vishal Soni, Advaiya Inc. This blog post covers some of the reasons why SQL Server...

Author: Bill Ramos Date: 05/19/2011

Migrating Oracle to SQL Server by using SSMA - Error O2SS0094 Unable to convert CURSOR as parameter

By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers why SQL Server Migration Assistant...

Author: Bill Ramos Date: 05/19/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0265 Unable to convert condition (with CURSOR attributes)

By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post describes why SQL Server Migration...

Author: Bill Ramos Date: 05/19/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0245: Cursor conversion in return statements not supported

By Bill Ramos and Badal Bordia, Advaiya Inc. This blog post covers why SQL Server Migration...

Author: Bill Ramos Date: 05/19/2011

How to migrate data fast from Sybase to SQL Server

[Updated: 2/8/2012 Selina Jia- the latest SSMA is v5.2, which has no Provider option in the project...

Author: Angshuman Nayak Date: 05/19/2011

Access to SQL Server Migration: Understanding SSMA Project Settings

[Update: 2/9/2012 Selina JIa-Microsoft SQL Server Migration Assistant (SSMA) for Access v5.2] In...

Author: Bill Ramos Date: 05/17/2011

SSMA @TechEd Video

SSMA session from North America TechEd is now available from Channel 9.

Author: Welly.Lee Date: 05/14/2011

SSMA 5.0 Extension Pack Installation Error

SSMA for Oracle requires installation of SSMA Extension Pack on the target SQL Server. This blog...

Author: Welly.Lee Date: 05/12/2011

[Updated: 2/9/2012 Selina Jia] SSMA provide an option to automatically create a link table for every...

Author: Welly.Lee Date: 05/12/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0179 Packaged Variable (constant) data type not recognized

By Bill Ramos and Vishal Soni Advaiya Inc. [Updated 2/7/2012 Jiafei Yuan - Microsoft SQL Server...

Author: Bill Ramos Date: 05/12/2011

Migrating Oracle to SQL Server Using SSMA - Emulating Oracle Package Variables

By Bill Ramos and Vishal Soni, Advaiya Inc. Oracle supports encapsulating variables, types, stored...

Author: Bill Ramos Date: 05/12/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0334 BULK COLLECT INTO Clause not converted

By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers some of the reasons why SQL Server...

Author: Bill Ramos Date: 05/12/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0352 BULK COLLECT INTO clause in SELECT statement not converted

By Bill Ramos and Mayank Bhanawat Advaiya Inc. This blog post covers why SQL Server Migration...

Author: Bill Ramos Date: 05/12/2011

Migrating Oracle to SQL Server using SSMA–Error O2SS0293: Columns list in set clause cannot be converted

This blog post describes SSMA error message when converting Oracle PL/SQL UPDATE statement with...

Author: Welly.Lee Date: 05/10/2011

Converting from MySQL to SQL Server: Working with Data Types

By Bill Ramos, Advaiya Inc. [Updated 2/6/2012 Jiafei Yuan- Microsoft SQL Server Migration Assistant...

Author: Bill Ramos Date: 04/29/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0205 Unable to convert PRAGMA AUTONOMUS_TRANSACTION

By Bill Ramos and Mayank Bhanawat Advaiya Inc. This blog post covers some of the reasons why SQL...

Author: Bill Ramos Date: 04/29/2011

SQL Server Migration Assistant v5.0 is now available

Migrate from Sybase, Oracle, MySQL and Microsoft Access to SQL Azure and SQL Server with ease!...

Author: Keshav Ramarao Date: 04/28/2011

Migrating Oracle to SQL Server using SSMA – Error O2SS0099 ROWNUM in ORDER BY clause is not supported

By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers some of the reasons why SQL Server...

Author: Bill Ramos Date: 04/14/2011

Migrating Oracle to SQL Server using SSMA - Error O2SS0021 Statement with ROWNUM not converted

By Bill Ramos and Ankit Matta, Advaiya Inc. This blog post covers some of the reasons why SQL Server...

Author: Bill Ramos Date: 04/14/2011

Migrating Access Jet Databases to SQL Azure

In this blog, I’ll describe how to use SSMA for Access to convert your Jet database for your...

Author: Bill Ramos Date: 04/13/2011

Migrating Data into SQL Server Using SSMA

SSMA provides flexibility for you to migrate your data with one of the two options below: Client...

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

Migrating from MySQL to SQL Azure Using SSMA

[Updated 2/7/2012 Selina Jia - Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The...

Author: Bill Ramos Date: 03/23/2011

MySQL to SQL Server Migration: Method for Correcting Schema Issues

[Updated 2/6/2012 Selina Jia - Microsoft SQL Server Migration Assistant (SSMA) for MySQL v5.2. The...

Author: Bill Ramos Date: 03/19/2011

Access to SQL Server Migration: Access Solutions using SQL Server, Part 2

By Mary Chipman In Part 2 I'll continue the discussion about how you can "tread lightly"...

Author: Bill Ramos Date: 03/19/2011

Access to SQL Server Migration: Access Solutions using SQL Server, Part 1

By Mary Chipman In Part 1 and Part 2 I’ll discuss your options for continuing to use Access as a...

Author: Bill Ramos Date: 03/19/2011

Using SSMA Project Setting to Customize Database Migration

SSMA provides a project setting that allow you to customize how the conversion is done. This post...

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

Access to SQL Server Migration: Understanding Data Type Conversions

By Mary Chipman Overview In this blog post I’ll discuss how you can use the SSMA Migration...

Author: Bill Ramos Date: 03/06/2011

Access to SQL Server Migration: Handling Schema Migration Issues

By Mary Chipman Overview In this blog post I’ll discuss some of the data migration issues you may...

Author: Bill Ramos Date: 03/06/2011

To Schema or Not To Schema

One of the first decisions you need to make when migrating to SQL Server is to decide whether to...

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

Saving Comments During Migration

During migration to SQL Server, you may find that the source database schema contains some comments...

Author: Welly.Lee Date: 02/17/2011

MySQL to SQL Server Migration: How to Use SSMA

By Bill Ramos, Advaiya [Updated 2/6/2012 Han Wong - Microsoft SQL Server Migration Assistant (SSMA)...

Author: Bill Ramos Date: 02/07/2011

Video: Resolving Migration Issue in MySQL

This video covers common migration issues that a developer may encounter when they migrate from...

Author: Welly.Lee Date: 02/05/2011

Video: Migrating MySQL Data

This video covers the process of moving data from MySQL to SQL Server 2008 once the database...

Author: Welly.Lee Date: 02/05/2011

Video: Converting MySQL Schema

This video covers the steps involved when migrating database objects (Tables and Indices) from MySQL...

Author: Welly.Lee Date: 02/05/2011

Video: Installing SSMA

This video covers step-by-step instruction on how to install and get up and running with the SSMA...

Author: Welly.Lee Date: 02/05/2011

Video: Introduction to SSMA

This video introduces SSMA tool including how to download and install as well as provide quick tour...

Author: Welly.Lee Date: 02/05/2011

Video: Automating Database Migration Using SSMA Console Application

This video introduces SSMA console application which can automate your SSMA database migration...

Author: Welly.Lee Date: 02/05/2011

Video: Migrating Data Using SSMA

This video describes how to migrate data using SSMA: // "); // ]]> [video] Check out the other...

Author: Welly.Lee Date: 02/05/2011

Video: Converting Schema to SQL Server

This video walks you through the schema conversion of SSMA, including an example on how to resolve...

Author: Welly.Lee Date: 02/05/2011

Video: Analyzing Database Using SSMA

This video walks you through database assessment feature of SSMA: // "); // ]]> [video] Check out...

Author: Welly.Lee Date: 02/05/2011

Video: Planning Your Database Migration

This video provides a quick overview of planning your database migration and setting up your SSMA,...

Author: Welly.Lee Date: 02/04/2011

Access to SQL Server Migration: How to Use SSMA

[Updated 2/7/2012 Selina Jia- Microsoft SQL Server Migration Assistant (SSMA) for Access v5.2. The...

Author: ssma Date: 01/28/2011

<Previous Next>