On the database to be dumped:0. Make a backup of the current DATABASE.
1. Dump all the Application Schema definitions:
From the Data Dictionary (Unix) or Data Administration Tool (Windows),
Select: Admin > Dump Data and Definitions > Data Definitions (.df file)
Click "Select Some" and click OK.
The Select Tables by Pattern Match dialog box will appear. Use the wildcard patterns or type ALL and click OK.
Specify the code page or accept the default, which is the value specified by the SESSION:STREAM or SESSION:CHARSET attribute.
Select the Include POSITION for. r / Binary Load Compatibility.
Click OK.
This will create a file named:
<dbname>.df2. Create a "Bulk Loader Description File" from the database
From the Data Dictionary (Unix) or Data Administration Tool (Windows),
Select: Admin > Create Bulk Loader Description File.
The next steps are the same as those above to create the .df file.
This will create a file named
<dbname>.fd3. Dump the data contents of the database
From the Data Dictionary (Unix) or Data Administration Tool (Windows),
Select: Admin > Dump Data and Definitions > Table Contents (.d)
The next steps are the same as those above to create the .df file.
This will create one file (
.d) per table.
4. Create a Database Structure file.
If this is an 8.3 multi-volume database or Progress 9 or later database, run:
$ prostrct list <dbname> <dbname>.st
In a text editor modify the .st file to reflect the new database structure:
- change the database name if the database is going to be renamed
- change the full directory paths of each extent if extents are going to be in a different directory
- change the number of extents and extent sizes as required
Rename the structure file to <new db>.st.
Copy all the dumped data and .st file to the new server.
On the database to be loaded:1. Create an empty database structure
If the new database is single-volume (V7 or V8 only):
$ prodb <new db> DLC\empty
For an 8.3 multi-volume database or Progress 9 or later database, run:
$ prostrct create <new db> <new db>.st
$ procopy DLC\empty <new db>
2. Load the Application Schema descriptions (.df).
From the Data Dictionary (Unix) or Data Administration Tool (Windows)
Select: Admin > Load Data and Definitions > Data Definitions (.df files).
Locate the .df file
3. Run the Bulkload to load all data:
$ proutil <new db> -C bulkload dbname.fd
4. Build all indexes
$ proutil <new db> -C idxbuild all -TB 24 -TM 32
