First, here is the setup:

BAAN is installed in two computers, one production and one development. Underlying database is ORACLE. Each computer, of course, will have its own ORACLE installation and the related BAAN instances.

Next, my requirement:
In my spare time (when I can get it, that is!) what I am thinking of doing is writing a BAAN Session that will run in the Development Computer and read a BAAN Table in Production Computer and insert the read record into the same table in the Development Computer. If this works for one table, I will expand it to obtain a consistent subset based on selected criteria to set up test companies with reasonable amounts of data instead of multi-giga-byte approach that has to be followed today. I suppose it will be quite tedious writing the program, but once completed, I am hoping it will be very useful.

Finally, therefore, my question is:

What are the set-up requirements (BAAN and ORACLE) to make this happen?

I will appreciate if anyone can share any experience on this subject.

Hi Shah,

Theres an on-going discussion already...

updating "test" companies (http://www.baanboard.com/baanboard/showthread.php?s=&postid=23978#post23978)

I think you have to explore more, into the areas like Remote Database setups and different Oracle SID's in BaaN. I think you also need to be aware that the Table Definitions be need identical.

database export/import (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6652)

1. make sure that you can connect from your test server the instance on the live server (changing listener.ora/tnsnames.ora, run listener on production server)

2. use the connect string in the database configuration.

3. assign companies to database configuration.

This means you can't use the same company number on both systems.

Rgrds,
Han