Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hardware Requirements - Oracle DB
There is no answer to this question as given. Btrieve is a navigational access database. Base relational Oracle or SQL Server has no navigational API. The conversion you speak of might not even be feasible. It would likely require a rewrite of most of the data access procedures and even then if you are trying to preserve the basic processing hierarchy of the system, the end result is likely to be quite inefficient.
A more realistic approach may be to upgrade your Btrieve to Pervasive.SQL. It has the navigational API your application is currently using as well as a relational API that would give you the flexibility you are looking for. It also would require zero code changes to anything that is currently using the Btrieve tables.
Good luck! Received on Fri Dec 14 2001 - 13:34:07 CST