Answered by:
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.
Thursday, August 28, 2014 5:24 PM
Answers
-
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 LiSofiya Li
TechNet Community Support- Marked as answer by Sofiya Li Friday, September 5, 2014 3:24 AM
Friday, August 29, 2014 9:34 AM -
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- Marked as answer by Sofiya Li Friday, September 5, 2014 3:24 AM
Friday, August 29, 2014 10:09 AM
All replies
-
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 LiSofiya Li
TechNet Community Support- Marked as answer by Sofiya Li Friday, September 5, 2014 3:24 AM
Friday, August 29, 2014 9:34 AM -
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- Marked as answer by Sofiya Li Friday, September 5, 2014 3:24 AM
Friday, August 29, 2014 10:09 AM