This discussion is archived
6 Replies Latest reply: Mar 24, 2012 9:52 PM by 891464 RSS

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

891464 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points