6 Replies Latest reply on Mar 25, 2012 4:52 AM by 891464

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


      We are migrating an SQL server 2005 DB to Oracle 10 g 64 bit 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 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!