Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

slow transfer of data from one local db to another

Status
Not open for further replies.

PJSWEAT

Programmer
Feb 3, 2003
82
US

It took the DTS wizard 6 hours to move a table with 3 million records from one db to another on one box, but only takes me approximately 10 minutes to transfer the same data inside the same database. Any thoughts as to what I should do to fix this?

Thanks
 
Are the Tlogs(LDFs) of both DBs on the same drive/share?

Thanks

J. Kusch
 
Does the table in the target DB have the same - exact - schema as the source table. ie ... no additional indexes or such?

Thanks

J. Kusch
 

Yes I just used the DTS wizard to copy the data over
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top