Microsoft SQL Server Migration Assistant for Oracle (SSMA for Oracle)

Switching the database client poses certain risks, most related to data integrity and loss. That is the reason why a trustworthy data migration client is recommended and what better application to migrate to SQL Server than the migration tool created by Microsoft itself?

Going by the name of Microsoft SQL Server Migration Assistant for Oracle (or, in short, SSMA for Oracle), this application is ready to help you migrate your data securely, with schema automation and quick data conversion. The so-called extension pack can emulate some of the Oracle functionality to ensure full compatibility.

SSMA for Oracle can migrate your databases from Oracle to SQL Server (all versions from 2012 to 2019), Azure SQL Database, Azure SQL Database Managed Instance and Azure SQL Data Warehouse. Oracle 7.3 and higher is supported. With its help, you can convert and migrate the objects in a database, while making sure that the schema is not altered in any way.

Once you create a new project, you can then connect to both SQL Server and Oracle. The main window displays two separate panels, one of each connection, each with its own metadata explorer in tree view. You can take a look at existing tables, SQL statements, data, type mappings, properties and reports in your databases.

To begin data migration, you simply have to select the data to migrate and start converting the schema and the data. What the Migration Assistant actually does is convert the database objects, then create them in SQL Server and start their migration. Oracle database schemas can be easily converted to SQL Server schemas.

While database migration might be risky and complicated, a software utility such as Microsoft SQL Server Migration Assistant for Oracle makes it seem easier and effortless. You simply have to choose which database components to convert and the application takes care of compatibility issues and the actual migration process.