We are going to migrate our informix database to oracle.
Just a sanity check.
I have DBAs that will setup my Oracle servers and database for me. I have my table sizes based on the current informix tables.

All I have to do from the BaanIVc4 side is sequential dump (bdbpre)
setup the oracle storage
setup the oracle users
change the DB setting to Oracle and bdbpost the tables back in.

This sounds too simple.

Am I missing something?

Just the

db_resource and $BSE/lib/ora_storage* stuff.

Dave

you have to be careful on the timing of when you convert the DB session to runtime with your login. The bdbpre & bdbpost will look at the tabledef6.1 file to "know" where to put the files and those definitions must be correct otherwise you can't log back into Baan to fix them - you must edit tabledef6.1 directly.

-Marine

Also check the defaults in db_resource as last time I checked Informix defaulted to using level-1 driver and oracle defaulted to level-2 so you want to make sure you have the correct setting.

Thanks all!