Saving a (whole) datatable in SQL Server 2000

  • Thread starter Thread starter Pipo
  • Start date Start date
P

Pipo

Hi,

I would like to save (and load) an entire datatable into SQL Server 2000.
Is this possible and has someone has some sample (code) for me?

tia,

Pipo
 
Pipo:

There are many ways to do this, do you want to use ADO.NET (which would be
quite slow and inefficient) or are you open to other technologies? You can
do a backup and restore for one thing, or you could write an SSIS package
(DTS if you only have 2000), or use BCP.

Can you tell me a little more about your goals and perhaps I can be of more
help?

Thanks,

Bill
 
ADO.NET can do it using the SqlBulkCopy class.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
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