Has anyone migrated Database form Informix 7.3 to oracle 9? We are planning to do this in mid-late 2004 and would appreciate any information or wisdom offered.

Thanks in advance!

Anp

If U r doing this on a New server thats better.

Follow the following steps

a) Install the operating system on the new Server including the latest service packs MUST be used for your Baan Version
b) Install the Oracle 9.0 database with all the Service packs useful and advised by Baan for your Version
c) Install the Baan Software, Validate the Server with Licenses,
Create companies accordingly and Create all the Tables in Baan first

d) Install all Baan Patches, which were there on your Old Server
in Update VRC
e) Create your Customization VRC for Test Environment.
f) Now take the Dump (i.e EXPORT) of each Package VRC Customizations (Carried out at the site) included all objects from the OLD server and Import them on the new server
one at a time.
g) Create RUNTIME DATA DICTIONARY....
h) Take DUMP of TABLE definitions from the OLD SERVER and import them in NEW server
i) Create runtime data dictionary.....


Also Please read Lots of documentation on Service packs for Database / operating system etc.

On the New setup , u will have problems on Finance company setup; U have to make sure that ur test environment is SIMILAR to your OLD SERVER setup except the database...

Hope this should go smooth... And you can also follow guidelines from Baan support for this transition.

Good Luck

We migrated from Informix 7.31 to Oracle 9. and we changed the server and OS from HP-UX to AIX at the same time.

We installed Oracle 9 on our AIX server , backedup All baan files from HP with tar and restored on AIX server, installed necessary portingset , first imported data of company 000 (bdbpost), do necessary configuration on baan config files, and imported all other company data.



Caner