Hi,

we are tryint to do two things with our BaanERP 5.0 c running on Oracle 8.0.5

1. We are going to take a Full export of Oracle DB (all baan tables - tools and data) and import it back after re-organising some filesystem and table space issues(Database guys do this).If we at this point import the DB back at Oracle level, will it work??Will we be able to get Baan Back to the Original State??

2. We are trying to get all production data into test basically.If we take a Full export Oracle DB of Production(all baan tables - tools and data) from production environment and put it on test Environment (Empty Database of Test DB instance)will it work??Will there be any licensing issues.

I appreciate your comments.

Thanks

Hi baanprog,

Number 1: Will be ok for sure.

Number 2: Would be ok for sure in baanIV. I am not 100% sure for BaanERP as the licence mechanism is different, but I think so.

If you rebuild the database from scratch, than obviously you need to make sure, you will also recreate users/roles etc.

If you are not sure about, what you are doing, than do step 2 before step 1!!

enjoy

Markus

1. We are going to take a Full export of Oracle DB (all baan tables - tools and data) and import it back after re-organising some filesystem and table space issues(Database guys do this).If we at this point import the DB back at Oracle level, will it work??Will we be able to get Baan Back to the Original State??
What kind of re-org of file system are you referring to. Just changing the mount points or directory structures ? Changing the mount points for failovers/high-availability would not affect. But if you change the $BSE paths and the directory structures below it you can have issues as the Package VRC paths are defined inside the tools tables - ttadv1115m000 - Directories of Software Components.

2. We are trying to get all production data into test basically.If we take a Full export Oracle DB of Production(all baan tables - tools and data) from production environment and put it on test Environment (Empty Database of Test DB instance)will it work??
To do a production to test clone you have to do both the database/OS clones to keep the objects/source files in sync. But your steps are not clear. If you need production data why are you copying tools database ? I assume the production data is located in a different company and database than tools in that environment. If you like to copy only the production company/database then the DD have to be in sync.

Will there be any licensing issues.
If you are on BaaN-ERP then you have to validate the ASM, BCLM information.