Hello,

We are currently looking at a consolidation exercise, moving from a multi-site configuration, to a single site set up. The moving/merging of the financial/logistics company data provides
no serious issues that I can see. However, I was interested in if any of you fellow BaanBoarders have ever tried to consolidate two company 000's. I am aware that the company zero(s) will contain data that will be required in the new configuration (possibly device/job/user data, text data ) AND some information that will not require merging ( application configuration etc ).

Has anyone ever attempted an exercise of this nature ?

Thanks in advance !

Yes I am currenlty merging 3 seperate Baan envs to one.
Also all 3 have/had different versions of personlized/customized software.

Also other things to note are things like:
1) time zone differences (solved with the setting of the TZ var in the bw config).
2) shared tables (pay attention to text tables as I had to unshare these).
3) Group company functionality would be evident in the one server setup. I had to load a few Baan solutions that fixed some finance reports showing trans from other companies.

if you do a company dump to seq file to move the companies note that a dump will also contain the exchange /job / text data. The exchange schemes (source) also reside in UNIX so that had to be copied over.

users/devices/authorizations are at 000 level and I bdbpre'd /posted the data. The Device data also uses drivers in the $BSE/lib/printinf dir so I had to copy these over as they were tweaked on the different servers to make them work properly (standard driver to not work properly).

Nick,

Thanks for the reply.. but as per usual a good answer always raises more questions !

The job and text data is taken with the company data when using bdpre ? Have you ever attempted this using Oracle exports ?

"users/devices/authorizations are at 000 level and I bdbpre'd /posted the data" .... I haven't looked at this closely yet but I assume you selectively bdpre'd the required tables and then bdposted them into the target company zero. Was this a major task identifying which tables to bdpre/bdpost ?

Thanks again

Tim

NO we did not attempt Oracle exports as our data is not that big, the Baan utilities worked o.k for us. The dump table (open range) to seq file for each company took approx 30 mins, with the create tables from seq file taking around 40 mins.

Yes when moving the "users/devices/authorizations" data I used Append and sometime Overwrite selectivley. Here is the tables that are not part of the dump to seq file that I had to move: (you may have to add a few more as we do not populate all tables)

Ttaad200 – User Data
Ttaad205 – Default Authorizations
Ttaad220 – Company Authorizations
Ttaad230 – Module Authorizations
Ttaad231 – Session Authorizations
Ttaad300 – Device Data
Ttaaad305 – Report Defaults
Ttaad306 – Device Preferences
Ttaad310 - Paper Types
Ttaad311 - Fonts by Paper Type
Ttaad430 - Table Authorization by Package
Ttaad431 - Table Authorizations by Module
Ttaad432 - Table Authorizations by Table
Ttaad433 - Table Field Authorizations
Ttaad434 - Table Data Authorizations
Ttaad435 - Table Field Data Authorizations
Ttaad999 - Session Authorizations