SQL Server Migration Assistant (SSMA) FAQs
This article addresses frequently asked questions about SQL Server Migration Assistant (SSMA) for Access, DB2, MySQL, Oracle, Sybase.
Overview
Q: What is SSMA?
**A: **SSMA is a semi-automated database assessment and migration tool, which help organizations migrate schema and data from other vendor products like Access, DB2, MySQL, Oracle, Sybase to SQL Server or Azure SQL DB. It is basically a product family, which comprises of the following products:
SSMA for Access: http://www.microsoft.com/en-us/download/details.aspx?id=43690
SSMA for MySQL: http://www.microsoft.com/en-us/download/details.aspx?id=43688
SSMA for Oracle: http://www.microsoft.com/en-us/download/details.aspx?id=43689
SSMA for Sybase: http://www.microsoft.com/en-us/download/details.aspx?id=43691
SSMA for DB2: http://www.microsoft.com/en-us/download/details.aspx?id=45296
Q: What are the key components of SSMA?
A: SQL Server Migration Assistant consists of the following major components:
- Migration Analyzer — It performs the assessment and evaluates the overall complexity involved in the migration project.
- Schema & Data Migrator and SQL Converter — It supports database schema conversion and data migration with help of a powerful IDE for cross-platform database developers.
- Migration Tester — It provides automated validation of the migration process.
Q: What are the key capabilities of SSMA?
A:
Q: What is the typical process followed when using SSMA?
A: Following is the typical process followed when using SSMA:
- Assessment - SSMA automates migration of most database objects, including stored procedures, functions, packages and triggers. There are few items which are not supported, or can not be converted 100% automatically. An assessment using SSMA can help identify the objects which can be migrated automatically. it alos provides an estimation about the efforts required for manual conversion of remaining items.
- Schema Migration - SSMA provides default data type mapping between the source database (Oracle, Access, DB2, MySQL and Sybase) and target database (SQL), which helps migrate the database schema. Additional option for customization are also available.
- Data Migration - Once schema is migrated, the migration of database can also be performed using SSMA.
**
**
Limitations and configurations
Q: What are the known limitations of SSMA?
**A:
**Q: What are the typical configurations required with SSMA?
A
Case Studies
- Sumitomo Rubber Industries - Company Shifts from Oracle and Itanium to the Microsoft Platform, Cutting Costs by Half
- General Cars Syndicate (Naqaba) - Saudi Arabian Transportation System Reduces Downtime and Cost with Database Change
- Graham Weldon - PHP community collaboration unlocks SQL Server technologies for open source web app developers