SQL -> Oracle

I reaaly would you to comment about the situation below described:

I have a Delphi project with more than 300 units, accessing SQL Server
with BDE (using regular TQuery and TDatabase).

We here, don´t want to be limited to only SQL Server customers, having
also Oracle customers. And, once we will be already doing a big
work on updating (some functions wich works fine at SQL, don´t at Oracle) ,
we are considering to forget about BDE, and use something else, like ADO.

Questions:

- Considering costs/benefits, wich solution should i implement ? I
really don´t want to update my system so bad, and after that have this
system turned to
something else, but in the other hand, i really want to forget about BDE.

- Is there a component, to replace the TQuery component, wich
automatically converts query texts from SQL to Oracle ? Or i will have to
write a lot of IFs, in order to
use one query text or another, depending if the connection is to a SQL
Server or Oracle.

- All of our future Oracle customers, will use Oracle clients, so that´s
not a problem.

- Any other solution to have this done ?


Thanks in advance



.

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)