A
Alejandra Parra
How can I copy data from a "X" DB to a "Y" DB using DataSets?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
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.
A
Alejandra Parra
How do I do Bulk Inserts?
Lucas Tam said: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.
L
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
J
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
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