Re: Read from one, write into another data source



Well,

I'm not creating such a tool. My purpose is not to bulk copy some data.

Rather, I would like the data displayed normally in a DataGrid (hence the
DataSet)
and have the changes committed to another similar database. Something like
one trustable database to read the data from, and one temporary database to
temporarily commit the changes to.

That's why I'm trying to use a DataSet.

Besides possibly not being the most elegant design, is that simply not
possible ?

Cheers.
Maxime.


"news.microsoft.com" wrote:

> Again, this sounds like you're using ADO to to transport (bulk copy) data.
> ADO is a query interface, not particularly suitable as a bulk copy engine.
> Use BCP or DTS for this.
>
> --

.



Relevant Pages

  • Re: Using Excel data in a VB6 database
    ... I am talking about a bulk insert of text comma delimited records into a table. ... the comma-delimited data into a database table that has the fields already set-up in the table. ... You load the table with the database utility to load text comma-delimited data into the table. ... Or you write a VB 6 program using a text reader, read the text file and use ADO to insert the records into the table, after you have populated each field in the table from the comma-delimited record you just read. ...
    (comp.programming)
  • Re: Generating one table with a terabyte of data
    ... Run perfmon counters to a log and analyze them after a bulk load. ... > On fast bulk loads you should make sure that the database is not logging. ... >> I've locked SQL server to 1/3 physical memory usage. ...
    (microsoft.public.sqlserver.dts)
  • Re: Bulk Insert and sp_dboption
    ... TargetDatabase only takes more time and resources. ... data in the bulk copy statements (Select Into, bcp, Bulk Insert, Create ... Writetext and Updatetext) is not logged in the transaction log. ... PS If Bulk Insert causes blocking problems on your database, ...
    (microsoft.public.sqlserver.programming)
  • Re: Generating one table with a terabyte of data
    ... On fast bulk loads you should make sure that the database is not logging. ... If the bulk load is fast enough you can always reload ... > I've locked SQL server to 1/3 physical memory usage. ...
    (microsoft.public.sqlserver.dts)
  • Bulk-Logged Recovery question
    ... If I take a full backup of the database and then set the transaction log to ... I then bulk insert> 1 million rows into the product portfolio ... is the TRN file the normal size because it was ...
    (microsoft.public.sqlserver.server)