Hi,

Can anybody please tell me how much time a data import process(Create tables by sequencial dump) will take to import 50 GB of data??

Thanks,
Subrat

Normally such estimates depend on CPU speed , cpu load , available memory , IO sped etc. So difficult to give any such exact idea. However for us it had taken half a day .

Recommend u to do a testing on this before final import with a possibility to drop the same if not required later on .

Hi Hitesh,

Can u plz tell me how to do the testing to make sure it will run perfectly without much delay??

Thanks,
Subrat

While doing a migration of this sort ,we had imported daily export of production data to the target new environment and estimated the appx import time ourselves. Also we had increased order number digits from 6 to 7 , done other testing with that data . Subsequently we recreated the tables and imported the data again at the final time .

U too can adopt this methodology if suitable to ur requirement .