SQL Server Migration Assistant for Oracle (SSMA for Oracle)

Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a free tool for migrating Oracle databases to Microsoft SQL Server. SSMA for Oracle converts Oracle database objects (including stored procedures) to SQL Server database objects, loads those objects into SQL Server, migrates data from Oracle to SQL Server, and then validates the migration of code and data.


SQL Server Migration Assistant for Oracle (SSMA for Oracle)

New! Download SSMA 2005 for Oracle v4.0New! Download SSMA 2005 for Oracle v4.0

SSMA to automate migration of Oracle database to SQL Server 2005. This release greatly increases the SQL conversion engine in addition to making many improvements across the product.

New! Download SSMA 2008 for Oracle v4.0New! Download SSMA 2008 for Oracle v4.0

In addition to multiple improvements on SSMA 2005 for Oracle V4.0 this release automates migration of Oracle database to SQL Server 2008.

Learn About SSMA OracleLearn About SSMA Oracle

Leverage these resources to see how SQL Server Migration Assistant automates, streamlines, and simplifies data migration and helps bring data management, rich data analysis, and data-mining capabilities to your business.

Download SSMA Oracle v3.1Download SSMA Oracle v3.1

August 2007 - Make your SQL Server migration from Oracle easier and more cost-effective with SSMA for Oracle V3, now available for free download. Experience a higher conversion rate, faster data migration and conversion Tester in the new v3.1 release.


Case Studies

AIM Healthcare Services moved its 9-terabyte databaseAIM Healthcare Services moved its 9-terabyte database

AIM Healthcare Services moved one of the 10 largest online analytical processing (OLAP) databases in the world from a Unix\Oracle 9i stack to a solution based on SQL Server. AIM is now enjoying enterprise-grade performance at a lower total cost of ownership.

Read more case studies from real world businesses using SQL Server to stay ahead in constantly changing business environments.


White Papers

Guide to Migrating from Oracle to SQL Server 2005

This white paper explains the entire migration process using SQL Server Migration Assistant for Oracle (SSMA Oracle) in depth, with a special focus on converting database objects and PL/SQL code.

Should You Migrate from Oracle to SQL Server?

This white paper presents a detailed review of the information required to create a robust TCO comparison of Oracle to SQL Server 2005.

SQL Server 2005 for Oracle Professionals

Examine the key differences between Microsoft SQL Server 2005 databases and Oracle databases comparing database architectures and providing information on the newest features in SQL Server 2005.

Improve Your SQL Server/Oracle Skills Online


Related Links

SQL Server Migration Assistant for Access
SQL Server Migration Assistant for Sybase
Migrating Informix Databases to Microsoft SQL Server 2000

Technical Resources

TechNet: Resources for Interoperability and Migration for Microsoft SQL Server
TechNet: Solution Guide for Migrating Oracle on Unix to SQL Server on Windows
Top of pageTop of page