Modify Delphi apps from Interbase to Oracle
507359Apr 21 2006 — edited Jun 25 2006We currently use Delphi 6 and most recently, "2006", for our inhouse software solution.
Our database is Interbase 6 & 7, and we are planning a move to Oracle 9.
Within Delphi, database access is achieved via IB Express (with only a minimal number of stored procedures and triggers), and we'll be converting approximately 100 programs. The rest will remain on Interbase (to the end of their natural life!)
One of the first things we need to agree on, is the new method of connecting to Oracle. Important factors being run time performance, and minimum impact code change.
The initial method that springs to mind is to replace the IB Express components with ADO and make any required changes around that. However, upon further investigation I have found some third party products (from Core Lab & Allround Automations) that appear to be quite widely used.
Has anyone been through this experience or have any advice as to which way we should go?