Re: Batchmove & ADO


Thanks for your responses guys
Brian Bushay TeamB <BBushay@xxxxxxxxx> wrote:
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 ?
No that is not supported

if not how much of an effort will it be to extend/alter Batchmove ?
You would have to totally rewrite it.

Or is it simpler just to extract into an ADOdataset and load programatically.
A combination of an Insert query and an Update Query should do what your batch
move does
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx

.

Relevant Pages

  • Re: Create Database in MS Access. & set properties of fields.
    ... Brian Bushay TeamB wrote: ... Access is the only database I know that supports the Allow Zero length property. ... Catalog1. ...
    (borland.public.delphi.database.ado)
  • Re: username
    ... Try double clicking on the TADOConnection, this will open a dialog box, ... Click on build and there you can enter user name, password, database an so ... "Brian Bushay TeamB" wrote in message ...
    (borland.public.delphi.database.ado)
  • Re: strategy for record locking in multiuser environment
    ... I am using an Access 2000 database ... "Brian Bushay TeamB" wrote in message ... >>overwrite another users entries and so each user can see the changes or ...
    (borland.public.delphi.database.ado)
  • RE: dbgrid refreshing problems...
    ... Brian Bushay TeamB escribió en el mensaje de noticias ... > reload records from the database. ...
    (borland.public.delphi.database.ado)
  • 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)