DataSet

[Alejandra Parra]

How can I copy data from a "X" DB to a "Y" DB using DataSets?

 

[Lucas Tam]

How can I copy data from a "X" DB to a "Y" DB using DataSets?

How much data? If it's a lot of data, datasets aren't the way to go -
they'll suck up all the memory on your PC.

Try using Bulk Inserts if possible.

 

[Alejandra Parra]

How do I do Bulk Inserts?

How much data? If it's a lot of data, datasets aren't the way to go -
they'll suck up all the memory on your PC.

Try using Bulk Inserts if possible.

 

[Lucas Tam]

How do I do Bulk Inserts?

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/tsqlref/ts_ba-bz_4fec.asp

BTW, are the databases on the same server?

If they are, you can go:

INSERT INTO db1.table1
SELECT FROM * db2.table1

 

[Jay B. Harlow [MVP - Outlook]]

Alejandra,
In addition to Lucas' comments on bulk copy, yes you can use Datasets to
copy between databases.

David Sceppa explains how to and gives some caveats in his book "Microsoft
ADO.NET - Core Reference" from MS Press.

If you are doing a lot with ADO.NET I strongly recommend Sceppa's book,
which is a good tutorial on ADO.NET as well as a good desk reference once
you know ADO.NET.

Hope this helps
Jay