I Used BulkCopy to transfer data One to another DB, moreover i like to know any other mathods...
C#
2
Posts
2
Posters
0
Views
1
Watching
-
Is there any mathod to transfer bulky data One to another DB as like BulkCopy.....?
-
Is there any mathod to transfer bulky data One to another DB as like BulkCopy.....?
If the databases are both Sql Server (and maybe some others) you can use an INSERT/SELECT statement. You can get a DataReader from the source database, and perform inserts on the destination database. If you do it enough you can write a Windows Service to copy the data. I've had to do that in the past for a data warehousing project.