CODEWITHSUNDEEP
sql-serveroracle-databasedatabase-migration
Blessing Samuel
Blessing Samuel

Reputation: 3

Oracle database to SQL Server migration WITHOUT SSMA

We are migrating our environment from an Oracle database to SQL Server. We cannot use an SSMA project as it is throwing errors so we have decided to not use it. How do we go about this or how do I migrate from Oracle database to SQL Server without the SQL Server Migration Assistant (SSMA) ?

Upvotes: 0

Views: 1845

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

Without SSMA you perform the same steps, just manually.

1) Dump all the table, index, view DDL from Oracle

2) Modify the DDL to SQL Server syntax, and map the data types

3) Create the objects in SQL Server

4) Map the data types and copy the data (eg with SSIS)

5) Look at every function, procedure, and package in Oracle and re-write them for SQL Server

Or you could export your target schema and load it into a dev instance of Oracle where you can avoid whatever errors are blocking SSMA and use it to help with the steps above.

Upvotes: 0

Related Questions