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
Auto generate link table when migrating access database using SSMA
[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