By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,701 Members | 1,782 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,701 IT Pros & Developers. It's quick & easy.

SQL Server - Fastest way to Copy large table to another database

P: 2
I have sql server database and i contains about 4 crore plus records.

When i am copy this table into another database using SQL Server Import/Export wizard it takes 1 hours per 10 lakh records.

If any fastest way can i use to copy large table to another database.

I have use also use bcp utility as described in below url...but it will also take same large time.

http://csharpcode.org/sql-server-bulk-insert-from-one-table-to-another/
Oct 3 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.