Re: ADO.NET questions
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/24/04
- Next message: William \(Bill\) Vaughn: "Re: Large Database Tables"
- Previous message: Marina: "Re: Problems with IsDbNull()"
- In reply to: dramos: "Re: ADO.NET questions"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 10:00:50 -0700
Okay, if you are targeting SQL Express 2005 then you have a much better
alternative--use the BCP functionality built into ADO.NET 2.0. Since SSE
2005 won't be released until VS 2005 you should not have a problem.
Sure, you can use XML to move data to and from SQL Server, but it's very
inefficient. For small amounts of data you can make it work, but it won't
come close to the performance you'll get with BCP/DTS.
-- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP 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. __________________________________ "dramos" <dramos@discussions.microsoft.com> wrote in message news:D3666563-DCD6-4F3F-BC01-7D133D1BB8F0@microsoft.com... > We are trying to design this app to be compatible with SQL Express 2005. > According to information I have on SQL Express, DTS will not be included > in > it so I dont think we can use DTS. > > Am I missing something though. My understanding was that using XML files > to > move data around was the preferred way in dotNET. Am I taking the wrong > approach in using the dataset writexml method to create a xml file that > could > be emailed to another user where he could import back into his version of > the > app? > > > "William (Bill) Vaughn" wrote: > >> DTS can export to a flat file that can be reimported elsewhere. >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> 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. >> __________________________________ >> >> "dramos" <dramos@discussions.microsoft.com> wrote in message >> news:83BB49BA-390C-4021-BE05-3E367FF9834A@microsoft.com... >> >I am novice with C## and ADO.NET. All my prior experience is with VB and >> >old >> > style ADO. >> > >> > We have a desktop application that uses MSDE as its database. We need >> > to >> > have a way to export rows from a few tables from one users computer to >> > another users computer. This has to happen in a disconnected way so >> > using >> > DTS is not an option. These are steps hat I was planning to use. >> > >> > 1)use SQLAdapter to create a Dataset with data to be exported on the >> > source >> > computer. >> > 2)Use DataSet WriteXML method to write out data to xml file.(User then >> > can >> > email xml file to another user) >> > 3)Create Dataset on Target computer and use ReadXMl method to read data >> > into >> > dataset. >> > 4)Modify keys on data so as to avoid primary key violatons >> > 5)Create SQLDataAdapter on target computer. Pass in Dataset with data >> > to >> > be >> > merged while called Update method on SQLAdapter. >> > >> > I have succesfully done steps 1-3 but I am having problems with 4 and >> > 5. >> > Has anyone done anything similar to this? Is this the correct way to >> > do >> > this? Any >> > pointers to examples of how to this is appreciated. >> > >> > Thanks in advance. >> >> >>
- Next message: William \(Bill\) Vaughn: "Re: Large Database Tables"
- Previous message: Marina: "Re: Problems with IsDbNull()"
- In reply to: dramos: "Re: ADO.NET questions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
