metropoj
9th August 2005, 22:08
Been reading through and creating companies from scratch and getting somewhat proficient, but I am in the process of needing to move this over to the live system.
My plan was to create the comapany skeleton in live, create all tables, etc and take the Sequential data dump from backup and import into live system ( same company name )
I don't think all of the company parameters get sent across do they ? :(
Am I missing something here that will allow a complete running setup company ( with logical table shares ) to be exported over to another similar baan server ? if not, i guess I have a lot of copying to do back and forth ...
Thanks folks for your help !!
victor_cleto
10th August 2005, 16:51
The table links is not sent since it is stored in company 000 (tools).
If you have created the structure of the companies you do not need to create the tables before running the import, I used to do exactly the opposite: import the data (with ignore ref. integrity), run a create tables and only then do a reorg. (for the ref. integrity).
metropoj
10th August 2005, 17:03
Oh OK, I was under the impression that the create tables was needed first through the Baan papers that i read up on QG 1022.
I'll take a look through this and try a few things. I may ask a few more questions :) Thanks for your help ...
metropoj
10th August 2005, 21:30
If I set up a company in the live server and I do a sequential dump of a company with logical tables from backup system, will the logistic tables copy JUST the data that is different or overwrite all the existing data ?
the reason I ask is that our chared tables are out of date on backup and I would like to know if Baan will update ALL the records in a logical table of just append the differences ( new records not in LIVE system ) to the tables ....
Did I make this clear ?? ;)
victor_cleto
12th August 2005, 13:43
Baan imports can be of type "delete existing before import" OR "append if non-existant" (existing will be skipped and not overwritten). If your live setup is empty, then running the whole import with append would do also an append in the logical tables.
I have never tested your scenario myself (usually we had refreshes, with a deletion before import) so, do some tests or wait for more feedback.
metropoj
12th August 2005, 15:03
I went ahead and spent a few hours updating the comapny manually then using Exchange Scheme did the rest.
I will test the scenario first and repot back what I found out....
thanks for the insight ....