Saving a (whole) datatable in SQL Server 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pipo - 06 Nov 2007 19:24 GMT

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

Reply to this Message

W.G. Ryan [eMVP] - 12 Nov 2007 18:53 GMT

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

> Hi,
>
[quoted text clipped - 4 lines]
>
> Pipo

Reply to this Message

William Vaughn - 12 Nov 2007 19:52 GMT

ADO.NET can do it using the SqlBulkCopy class.

Signature

____________________________________
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)
-----------------------------------------------------------------------------------------------------------------------

> Pipo:
>
[quoted text clipped - 20 lines]
>>
>> Pipo

Reply to this Message

Saving a (whole) datatable in SQL Server 2000

Free Magazines