Re: ADO or BDE?

"JK" <jkhader@xxxxxxxxxx> wrote in message
news:47be2ed2$1@xxxxxxxxxxxxxxxxxxxxxxxxx
My client want to move records from Oracle to SQL (for reporting
purposes).
They use Delphi and want to do this thru the GUI and not StoredProc. What
should we use for faster access, ADO or DB?

I'm assuming you mean BDE here. Whatever you do, don't use it. It was
deprecated years ago.

If all you need to do is move data from some Oracle tables to some SQL
Server tables, you could probably use the SQL Server DTS utility. It works
really well. No code needed. On the other hand, if a user has to be
involved for some reason as Bill asked, then stick with ADO.

- Arnie


ThanksAll.
JK
delphi@xxxxxxxxxx (Delphi Dev/Recruiting)
www.HardWebCafe.net ($3.99 WebHosting 4 Developers)




.

Relevant Pages

  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)
  • Re: Field position in a record, how to change?
    ... If you know how to move fields with DAO you can use Ole to access the ... I have found how to obtain the (ADO) FieldDefs for the ... (I am searching documentations for this option but your answer might ... I may just have found the answer in my saved Delphi 5 help files ...
    (borland.public.delphi.database.ado)
  • Re: slow ADO refresh, ending in error message
    ... It seems to me that if the feature works fine with some implementations ... with Delphi 7) and poorer with other implementations (the Delphi 7 ... >>Is ADO only for small databases then? ... > You can use any size database with ADO but if you want good performance you ...
    (borland.public.delphi.database.ado)