Copy a database table into another using ado.net

  • Thread starter Thread starter kkizer
  • Start date Start date
K

kkizer

I need help! Here is what i have going. I have a cobal database that i
connect with using a DSN/ODBC (the source data) and i have a Sql 2000
database that i am trying to copy the data to. I have a DTS package
setup doing this task just fine but i need to do this process using
ado.net/vb.net, not using DTS (dont ask why, long story). I have been
searching around places and just cant find any good code examples to
help me get started. Can anyone helP?

I already have the tables setup in sql server and they are identical to
the Cobal database.
 
Open a connection to both databases, read the data from one, and write
it to the other.

Robin S.
 
No problem. ADO.NET 2.0 exposes the SqlBulkCopy method that does what DTS
does...
hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
Yes, right. 1.1. You can still call BCP via SQLDMO API calls.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
 
Back
Top