Importing data takes a long time Enterprise Manager
Posted on 2004-09-02
I am importing about 500 million records from a .csv (10GB) file in a PC to a SQL server 2000.
It has imported about 460 million (could be the total) it took around 10 hours to get to this point, now it is "executing" no more records are imported, it reads 459,180,000 records copied.
Space in the server is plenty. Memory ia 1GB
The network reports data movement between the SQL server and the PC.
Is this normal? How long can this take?
Is the end of the process like this? What can I do?