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/
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/