I am in the process of setting up an environment to store archive data. My consultants have advised that I replicate data from many master tables before executing the archive sessions.

My list of master tables is long and the process to replicate the data is time consuming. In attachment, I have documented the parameters that I set when running ttaad4227m000.

Can this be executed at the command line and what would the command be?

Also, has anyone scripted this process?

It would be nice to stream line this process.

Joy, I deleted your duplicate post. I am unable to open both attachments. Can you check?

I am unable to attach document. Here is a list of parameters set.

Create Tables for a different company = yes. Company = 520.
Append if table exists.
Overwrite duplicate records from dump.
Disable Domain constraints.
Ignore Referential Integrity constraints.
Name of dump file = "/srmuxroot/download/dump.500"
Pattern to match table names = "tfacp00*"
Name of error file = "error"

The archive sessions copy the master data when you run them. I did find a couple of tables that I loaded to save typing but it was only 3 or 4 when I setting up the archive company like currencies,countries, periods, .

If you do want to automate it then use bdbpost you can pass it a list of tables.


This thread explains usage
http://www.baanboard.com/baanboard/showthread.php?s=&threadid=388

Joy,

You can automate the whole operation to a very high degree with a good UNIX shell script. The link Darren gave you contains all bdbpre/post options so you can make your pick from there. Just make sure your matching pattern comes last in the bdbpost command and that you 'redirect' the dump file into the bdbpost command.

In the given example, I am interpreting the syntax to be as follows:

bdbpost6.1 -Rnm c520 tfacp00* < '/srmuxroot/download/dump.500

Is this correct?

I think that looks correct Joy. Still try it in a test company first and check the results.

I am unable to open the attachment.
Can u send it at ashim_vig@yahoo.com
or
ashimvig@hotmail.com
or
ashim@deltronindia.com

I would be grateful

Guys,

Please check out the new session released by Baan.

"Archive General Data" (tcmcs4200m000).

You can archive all the necessary general table by package at one go.

NOTE: Please remember that when you use bdbpre and bdbpost, you will be losing the text unless you share the text tables. There is no need to share the text tables between Live Company and Archive Company. Ideally, Archive Company should act like an independent entity.