|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Saving a (whole) datatable in SQL Server 2000Hi,
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 Show quote "Pipo" wrote: > 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 > ADO.NET can do it using the SqlBulkCopy class.
-- Show quote____________________________________ 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) ----------------------------------------------------------------------------------------------------------------------- "W.G. Ryan [eMVP]" <WGRyane***@discussions.microsoft.com> wrote in message news:B8B13CFE-E03D-45F7-88F1-9807301FDF0A@microsoft.com... > 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 > > "Pipo" wrote: > >> 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 >>  |
|||||||||||||||||||||||
Other interesting topics