AnsweredAssumed Answered

What is the fasted way to import data from one file to another?

Question asked by AppGuy on Aug 15, 2018
Latest reply on Aug 15, 2018 by philmodjunk

What is the fasted way to import data from one file to another?

 

Before everyone in the forms say use the Data Migration Tool, I would but I can't since it is a block copy and I need it to rebuild indexes due to some of them getting corrupted I think...

 

I will be starting out with a clone of the existing file...

 

Which import method is the fastest?

 

  1. Leave existing database on server and import to local machine
  2. Leave database on server, put new database on server, run a PSoS script for import
  3. Copy both files to a local machine and do the import on the machine via script
  4. ???

 

 

My file is about 60GB.. so I know it will take a while.. that is why I am asking anyone who has tested or done this?

 

Thanks

JP

Outcomes