Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Server 2005 huge data migration. Taking more than 18 hours ...

891464Mar 22 2012 — edited Mar 25 2012

Hi,

We are migrating an SQL server 2005 DB to Oracle 10 g 64 bit 10.2.0.5. The source sql server DB has few tables (<10) and only few stored procedure(<5). However one table of source is very huge, it has 70 million records in it. I started the migration process; it was running till 18 hours passed away then I cancelled it. I am using SQL Developer 3.1.0.7 with online migration.

Kindly let me know if I choose offline migration will it reduce the data move time. Is there some other tool by oracle that can migrate huge data (records in millions) quickly. Is there some configuration in SQL Developer that can catalyses the process?

Kindly help.

Best Regards!

Irfan

This post has been answered by wkobargs-Oracle on Mar 22 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2012

Added on Mar 22 2012

#database-and-application-migrations

6 comments

820 views