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?
- Leave existing database on server and import to local machine
- Leave database on server, put new database on server, run a PSoS script for import
- Copy both files to a local machine and do the import on the machine via script
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?