Table Export/Import

B

bi76957

New Member
I'm trying to script the deployment of updates to a table by doing a complete table extract / import from the command line on an AIX box. The goal is to extract the table from development (with all of the necessary updates) and import it into test, training, and production. Can anyone tell me how to do this with Progress 9.1E (base version)? Are there any risks (e.g. CRC validation errors)?

Thanks for your help,
Chris
 
Hi,

Well this is the short answer:

There are a few steps you have to take:
  1. Make a delta.df file to capature the changes between development database and testdatabase (which should be a copy of the production database).
  2. Apply those changes to the testdatabase.
  3. Recompile all affected Progress source code to avoid crc errors.
  4. Test
  5. Deploy to production.
See The Progress database Administration Guide and Reference for more information on these steps.
Also information in the knowldege base: for example KB P8028.

Regards,

Casper.
 
Casper,

Thanks for the reply. I guess my bigger, more important question is how do I do the import and export itself?

Chris
 
You must log in or register to reply here.
Back
Top