[progress Communities] [progress Openedge Abl] Forum Post: Re: Dump And Load Of Rtb...

[Jeff Ledbetter]

See /rtb_util. We have customized dump and load procedures to handle restoring the RECID values. FYI, starting with RTB 11.x we no longer store RECID and the standard OE dump and load routines can be used. From Roundtable 10.2B User Guide: 3.13. Repository Dump and Load Do not use the OpenEdge database administration utilities to dump and load a Roundtable repository database. The Roundtable repository database stores many RECID values and if you use the OpenEdge database administration utilities to dump and load your Roundtable repository database, the RECID values will be lost. Also, your new Roundtable repository database will be unusable. Roundtable comes with its own tools for dumping and loading the repository database. These tools preserve the RECID values. Follow these steps to dump and reload the Roundtable repository database: 1. Ensure that adequate disk space is available to accommodate a database dump. It is difficult to predict how much space this should be, but dumps often require between half to three quarters the size of the original database. 2. From the OpenEdge editor of a Roundtable session, run rtb_dmp1.p to dump the Roundtable repository data to ASCII ".d" files in the current directory. This program is located in the rtb_util subdirectory of the Roundtable installation procedure and makes calls to a second program in that directory, rtb_dmp2.p, expecting the same relative path (that is, RUN rtb_util/rtb_dmp2.p). 3. Use the OpenEdge data dictionary tools to dump the user table of contents. 4. Use the OpenEdge data dictionary tools to dump the Roundtable repository database schema to an ASCII ".df" file in the current directory. 5. If the new Roundtable repository database will be in a different location, change to that new location and move in or copy in the ASCII ".d" and ".df" files created earlier. 6. Use the OpenEdge prodb command to create a new Roundtable repository database from the OpenEdge empty database. 7. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, use the OpenEdge data dictionary tools to load the schema from the ASCII ".df" file in the current directory. 8. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, use the OpenEdge data dictionary tools to load the user table of contents. 9. From the OpenEdge editor of a OpenEdge session on the new Roundtable repository database, run rtb_lod1.p to load the Roundtable repository data from the ASCII ".d" files in the current directory. Like rtb_dmp1.p, this program is located in the rtb_util subdirectory of the Roundtable installation and makes calls to a second program in that directory, rtb_lod2.p, expecting the same relative path (that is, RUN rtb_util/rtb_dmp2.p).

Continue reading...