Hi,

I need to copy an existing company from one VRC to another VRC.
Which sessions do I have to use and what are the steps to do this.
Thanks
Caner

Hi Caner,

I follow the procedure below for 4c4, this is for an existing company to company copy.: -

1. ttaad4226m000 (company in original vrc) - Create seq. dumps of tables. We normally get away with doing the tc, td, tf, tg, ti, tp, tr, ts and tt. You may have to include others, you will need to check.

2. ttaad4231m000 (company being updated) - Delete tables in the company you are UPDATING (your 2nd VRC) in to.

3. ttaad4230m000 (company being updated)- Create tables

4. ttaad4227m000 (company being updated)- Create table from seq. dump. Use files created in step 1.

5. tcmcs0295m000 (company being updated) - initialise Params

6. tfgld9004m000 (company being updated) - Correct company number after copying. This will need to be run if your company numbers are different. i.e. If you are using company 100 data to update company 110.

7. ttaad4225m000 - (company being updated) - Reoragnise tables

If you are wanting to create a company from new I have attached a quick guide on how to do this.

Other people out there may do it differently but this is the way I do it and I've carried out this process quite a few times over the last 18 months.

Good luck!

PJ

Hi Caner,

PJ's method is used for copying lets say company 100 to company 200 in the same VRC. By the way I do not think, you need the step "Initialize Parameters".

If the two VRC's (or to be correct Package Combinations) have the same data definitions, then this will work fine.

If you want to change the Package Combination of a company then you have to user the session "Change package Combination by company" ttaad1101m000.

This session will dump the changed tables, recreate them with the new data definitions and load the data again.

regards

Markus

Hi All ,
In our developers VRC we don't have any company.
and we need to test something there .
We have a test company (915) in OPER_MCR package Combination and want to use this company in our developer VRC
And our developer VRC's Package Combination is DEV_MCR.

- Can I run "Change package Combination by company" ttaad1101m000 when user are logged to baan
- What are the next steps after running ttaad1101m000

Thanks

Caner

Hi Caner,

if DEV_MCR and OPER_MCR have the exact same datadictionary, then you can do two thing.

a) just put your test user on company 915 and Package combination DEV_MCR.


or

b) just change in general table Maintainance the package combination of company 915 to DEV_MCR.

if not, you have to do the "change package combination". Baan can be up and running, but you have to make sure, that users are not working in company 915. Any other company (as long as they are not logically linked) is ok!

If a user is working in 915, when you do it, then you might get locking problems or you might loose some data or the user might get error messages. So do not do this.

After "Change Package combination", you just have to change your user settings and that's it.

Markus

OK. Same situation (copy company...) BUT

the original company (333) is on a server running Baan IVc4. This company and all data needs to be loaded on a different destination server that is running Baan IVc2.
The destination server is production with live companies (111, 222).
The company to transfer over will be for reference purposes, and users should be able to 'switch' to the reference company (333) if needed.

I have gotten so far as to create the company 333 and load the tables from the IVc4 dump - EXCEPT - there are a few tables that did not load - these tables have a different layout (additional fields) than my IVc2 tables. I have tried to add the new fields, but still I cannot load the original data. I can enter new data, but I cannot load - DD's don't match.

Does anyone have any ideas how I can get this IVc4 company (or just the few selected pain-in-the-b--- tables) into my IVc2?

Thanks.

P-Matt
One way to do this is to copy the c4 data definition for those tables into your customer level VRC in c2 then import the data. When the data is in, remove the c4 data definition and convert to run time, it will keep the data and make the necessary changes.

Good luck.

lbencic,

Thanks for the fast reply.
That was one of the options on my list of things to try, so I bumped it up.

It appears that did the trick. I was able to load the table data and still see everything after putting the original dd definition back.

I didn't have to do any convert to runtime tho. - should that matter latter?

thanks again for your quick solution!

Yes, you should run the convert. The data is in is still c4 configuration until the convert is done. For instance, some table may have more fields in c4 than in c2. When you import using c4 definition, you have the extra field. When you delete the c2 definition in Maintain Table Definition, you still have the extra field until the convert to runtime is done. When the convert is run, the table will drop the extra field, and make any other changes needed to conform to the c2 definition. You should check the reconfigure option.

Edited: Just thought that you may not have done this through Maintain Table Def. If you moved the dd's around through the file system, I really am not sure if the convert is needed. Check the data through General Table Maint. to be sure it is in c2 format....

Moved via the file system is just what I did - copied the definitions from the IVc4 server to my IVc2 server, imported the tables, and then put my IVc2 dd files back.

I modified a record via maintain table def, as well as the actual session, and ran a report. Everything worked great.

Thanks again for your help.