Consultor Eletrônico

Status: Unverified

GOAL:

What to consider when deciding on the utility to use to move a database from one location to another.

FIX:

The two utilities that can be used to move a database from one location to another are:

The Progress backup (PROBKUP):

The Progress backup backs up the database at the block level. The record and index structures are not taken into account when the database is backed up. As a result, individual tables within a database can not be backed up independently. The entire database must be backed up.

The backup process usually starts with a back up of the BI file then proceeds to the database files. The database files are backed up as if they are one continuous file regardless of the physical database structure. Each block is verified as being a valid block before it is buffered into memory to be flushed out to disk.

Since the blocks are a binary block representation of the database information, they are non-portable between differing operating system platforms or processors.

The Progress dump and load:

The Progress dump & load function dumps binary data out of a database into ASCII data on a table by table basis. The process reads the record structure from the metaschema table, then uses it to read all of the records using Progress 4GL.

The primary index is the index that is used. The process then exports the index in a manner that is recognized by the load process (one record per line).
The format of the dumped data is space delimited with quotes used when needed.

This is based on the data types represented in the database metaschema table. The metaschema determines in what structure the data should be exported, and represents that structure of the record in terms of the number of fields present and whether or not there are arrays in these fields.

Since the file is an ASCII file, it is completely transportable between platforms.