Hello, I need some one input on how to move data from Oracle 7.3.4 under Win NT to Oracle 9i under IBM/Aix. I know that Baan tools has the capability to export using Create seq. dump from table, and to import using Create table from seq. dump. Baan application is running baanIVc3 under windows 2k

Is that the only way or there are faster ways?

Thanks

Hello,

I have done several migrations from Unix to Windows or from Windows to Windows machines.

As the creation of the sequential dumps is very time consuming, I have created some little shell/batch scripts to export and import the database table by table.

The export can be done like this:

c:\baan\bin\bdbpre -E d:\temp\tccom001.err -N tccom001 -C 020 > d:\export\tccom001

In the error file the number of records can be found.

The import is done like this:

c:\baan\bin\bdbpost -nmfk -pB4CcCH -E tccom001.err -O tccom001.log -I d:\export\tccom001 -C020

From the error and log file you can see the starttime of the import as well as the number of records which are imported.

It is recommendable to splitt the export and import by module.

Regards,
Ralf

following the oracle-export/import-versionmatrix,
you can do an oracle- export/import as well,
if you come from 7.3.4 to 9.2.0.4,
its faster

Thanks Rochus for your feedback. If I got it correct, you mean we create a full Oracle export form Win NT and import that to Aix using Oracle tools which is included in both packages (Oracle 7.4.3 and Oracle 9i). If that is correct, the output file format should be compatible or will require some manual updates ?

Thank you.

you should export schema baandb/baan
no full export.
than you can user features of oracle9i,
(space managemant, undo managment) ...
be careful with NLS_LANG (for binary tables).

than there's are no manual actions after that.

please read also the thread "poor performance
with ora9i under AIX", for settings in the
db_resource-file

Originally posted by rochus
following the oracle-export/import-versionmatrix,
you can do an oracle- export/import as well,
if you come from 7.3.4 to 9.2.0.4,
its faster

If you export the whole Oracle database from Windows2000 server onto a UNIX environment, you are very likely to run into all sorts of problems with company 000. Amongst other things, issues with pathnames being different from one environment to the other.

You have to exclude company000 tables if you want to use Oracle tools for import/export

i see only problem with binary tables
(form, menu, report layouts).
therefore set enviroment variables (NLS_LANG,...)

which paths do you mean ?

i meant:
no full export/import, only baandb-schema,
create schema, (role), tablespaces under 9i before.
so i see no problem for company 000.

I would like to thank all contributed to provide me guide lines. Finally we agreed that the DBA will handle the migration not me as a BaaN developper.

Thanks again and I'll forward your comments to the DBA.