Batchmove & ADO


Hi There
I have a TService which currently uses a datamodule plus several TBatchmove components to move data from a SQL Server Database -> Oracle database.

Now this works fine 95% of the time, however on occasion we have run into the problem whereby BDE cannot handle the amount of data being moved. I would like to use ADO to manage the Connections between the databases bypassing BDE entirely.

My first question is :

Can I still use Batchmove but with ADO based Components ?

if not how much of an effort will it be to extend/alter Batchmove ?

Or is it simpler just to extract into an ADOdataset and load programatically.

Any other suggestions welcome.

Martin




.

Relevant Pages

  • Re: Batchmove & ADO
    ... I have a TService which currently uses a datamodule plus several TBatchmove components to move data from a SQL Server Database -> Oracle database. ... I would like to use ADO to manage the Connections between the databases bypassing BDE entirely. ... A combination of an Insert query and an Update Query should do what your batch ...
    (borland.public.delphi.database.ado)
  • Re: Batchmove & ADO
    ... Brian Bushay TeamB wrote: ... I have a TService which currently uses a datamodule plus several TBatchmove components to move data from a SQL Server Database -> Oracle database. ...
    (borland.public.delphi.database.ado)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)