Moving from SQLBase to Oracle

[Stefan Piechowski]

Hello folks,

we want to move from SQLWin502/SQLBase 6.01 to SQLWin/Oracle7.
So I need little help to estimate the work to modify existing Apps to
work
with Oracle. We want to purchase SQLWin Network edition for
native connectivity to Oracle (no ODBC).

My Questions:

1.) Are there any special things I have to consider when moving
my Apps toward Oracle ?

2.) Has anybody written Apps that work with two ore more backends the
same time
(without recompiling) ?
And how ?

3.) Are the SQL-languages really so similar like the usual SQL books let
us believe ?

4.) How do I transfer the data from SQLBase to Oracle with minimum
effort ?

Any help would be greatly appreciated.

Thank You

Stefan Piechowski
pilodata, Munich

[Alexis COMTE]

Hello,

YEas i have a certain experience of this kind of problems because i have
already done this kind of migration.

I have written a library of objects hich is working for the two databases.

Majors differences :

- Be careful of the ROWID. It changes on SAL Base put stay fixed in
Oracle
- don't forget to run the view scripts so that SQL Bases systems
views may be reproduced on Oracle.
- if you have more than one databases in SQL database, then be
careful because ORACLE is unique. you may find problem if you have two
EMPLOYES tables.

Hope this help

Alexis

Stefan Piechowski <pie...@lkn.e-technik.tu-muenchen.de> wrote in article
<323021...@lkn.e-technik.tu-muenchen.de>...