Re: SQL -> Oracle

You may want to look at native drivers from CoreLabs http://www.crlab.com and DA from RemObjects http://www.remobjects.com



Marcelo [RM Sistemas] wrote: 
    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




--
Thomas Miller
Chrome Portal Project Manager
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus
.

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)