Copy general data using bdbpre and bdbpost toolsThis topic is used to explain one of the alternative methods for archiving general data. The regular method is to archive the general data in a single step using the Archive General Data (tccom0250m000) session. See Archiving General Data. To copy the general data from your operational company into the archive company, you can compose an ASCII file such as copy.erpln.data, in which all required tables are listed. With this file and the bdbpre command, you can dump the tables in a dump file. With the bdbpost command, you can create tables from the dump file. Instruction (UNIX or Windows system level): Step 1. List the names of the required tables in one or more ASCII files, such as copy.erpln.data. Step 2. Export the data from the operational company (bdbpre) and then import the data into the archive company (bdbpost), using this syntax: UNIX At the command prompt, enter the following:
This will copy the data of the provided tables from company 001 to company 901. Windows On the server, at the command prompt, enter the following:
This will copy the data of the provided tables from company 001 to company 901
Step 3. After you post the dump to the archive company, reorganize the tables using the Reorganize Tables (ttaad4225m000) session. In this session, select these boxes:
This is required because the bdbpost option –n (Ignore referential integrity constraints) is used. For more information about the options for the bdbpre and bdbpost commands, see the Infor Enterprise Server Technical Manual.
| |||||||||||