1

I have progress .bup files for my databases The environment I am restoring too has less space and because I have no control over this environment I wish to make the databases smaller.

To do this I need to exclude certain tables from the restore process. (Alternatively I want to specify which tables to restore.)

The list for excluding is much smaller so would make more sense to specify what I wish to exclude certain tables, rather than a list of what must be included.

AquaAlex
  • 131
  • 1
  • 6

1 Answers1

2

The Progress backup is a block-level image of the database & bi file, so there's no way to only restore certain tables. You'll need to

  1. restore the db on a machine with enough space for the old db and the smaller db,
  2. create an empty version of the db,
  3. dump the required tables from the restored db,
  4. load that table data into the new db file,
  5. then copy the smaller db to your target machine
Tim Kuehn
  • 221
  • 1
  • 7