[progress Communities] [progress Openedge Abl] Forum Post: Re: Restoring Progress Database

Status
Not open for further replies.
B

Brian K. Maher

Guest
You should never copy anything into the installation directory or any directory underneath it. 1) Run the proenv command. This will open a command shell. 2) If on windows, type “prompt” (no quotes) and press enter. This will change the prompt to show you the directory. 3) Copy the .st file into the current directory. 4) Type “prostrct create ” (no quotes) where is the name of the .st file minus the .st extension. 5) Type “procopy empty ” (no quotes) where is the name of the newly created database (minus the .db extension). 6) Type “prowin32 -db -1 -p _admin.p” (no quotes) where is the database name. Change prowin32 to prowin if you are running 64-bit version on windows. 7) From the Data Administration window, select Admin -> Load Data and Definitions -> Data Definitions (.df file)... 8) From the Load Data Definitions dialog, enter the .df file (browse for it using the “Files...” button). 9) Click “OK” button. 10) Assuming load of .df file went without error.... 11) From the Data Administration window, select Admin -> Load Data and Definitions -> Table Contents (.d file)... 12) From the Select Tables dialog, click the “Select Some ...” button. 13) From the Select Tables by Pattern Match dialog, leave the “Table Name” field as an asterisk (“*”) and click the “OK”button. 14) From the Select Tables dialog, click the “OK” button. 15) From the Load Data Contents for All Tables dialog, click the “Data Dir...” button and select the directory where your .d files are located. 16) Specify a value for the “Acceptable Error Percentage” field. I personally use “100” so the load does not stop for errors since you can always delete things and start again. 17) Leave the “Output Errors to Screen” check box unchecked (this will create .e files for any load issues. 18) Click the “OK” button.

Continue reading...
 
Status
Not open for further replies.
Top