SSMA for Oracle

Question

I am using SSMA (v5.3) for Oracle to SQL server migration. I created a new project and connected to both Oracle and SQL server database. I created the all the tables available in Oracle database to SQL server database using different tool. Now I wanted to load only the data. I started the schema covert in SSMA and it is running for more that 20 hrs. Can I know what is normal time taken for this conversion. Is there a way for speeding it up. Also is there any seperate procedure for migrating in the data using SSMA. BTW I tried directly migrate data option, but it didn't work.

Oracle Database size is 125 GB and it has 22000 records.

Answer 1

Hi  Ramesh K T,

SQL Server Migration Assistant for Oracle are designed to migrate data from Oracle to SQL Server, Before migrating data from the Oracle database to SQL Server, we must  convert and synchronize the schema of database, the particular category of the schema, and the attributes of objects. When you select  the schema to be migrated, you need to map schema at Oracle to SQL Server, and covert to SQL ‘s data type . For more information, there is a similar article about migrating the schema from Oracle to SQL Server, you can refer to it.

http://blogs.msdn.com/b/ssma/archive/2010/08/27/migrating-oracle-s-sample-hr-schema.aspx

We can use SSMA Console Application to migrate Oracle database. For more information, see: http://blogs.msdn.com/b/ssma/archive/2010/09/09/performing-database-migration-assessment-using-ssma-console-application.aspx

Thanks,
Sofiya Li

---

Sofiya Li
TechNet Community Support

Answer 2

Hi Ramesh,

It does takes time for big databases I assume i internally does all conversions.

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Articles