learn_ln6
26th May 2006, 18:18
hi all
Database Oracle

We are taking a backup of live company date through Sequinal dump of table..
company no - 555


one other testing server install the baan and create a company - 333
how to recover the date of 555 company to 333 Company

please help

Sanj

mark_h
26th May 2006, 20:29
Well I have never done a complete company, but I have moved a few tables. Usually I just import them into the new company and if necessary I run the program in this link (http://www.baanboard.com/baanboard/showthread.php?t=16216&highlight=company). Never can remember the name of the session so I bookmarked the link.

If I was doing a complete company copy I would do what my oracle DBAs do - export, and then import into the new company. Then renumber everything. Takes about 2 days for the whole process.

Just keep in mind I am not a tools admin type person.