Copying an Open4 OpenEdge (Progress) live DB to TestKB0033438 Authored by Frank DiCarlo • 2 Views • 2y ago Print Issue How to copy OpenEdge (Progress) databases from Live to Test. Copying the Open4 database and also the programs, screens, and other supporting files to another location requires two separate copy procedures. The reason for this is that Progress stores the location within the database itself. If you use the Window's Explorer to do the copy and you do not put it in exactly the same place, it will not allow you to open the database. Progress provides a tool called Procopy to correctly copy the database. The last step would be to create a new desktop icon to access the test database. Error N/A Resolution There are three methods to copy your database to a different folder or directory. They are: 1) Prorest (Restore of your online backup file). 2) Procopy of your live database 3) OS copy with Prostrct Repair. We recommend using the Progress Prorest or Procopy utility. This copies the database safely to the new target folder and makes it ready for use immediately. The third option of using Windows Explorer to copy the database had the potential of destroying both the copy and the source database if the database is not shutdown. Then once the copy is made, a repair command must be issued. NOTE: If your source database is setup with module(s) using Sonic MQ (e.g. Multi-Company, Mobile Connect, Euro-Financials, Customer/Supplier Connect) it is advised to delete the corresponding multi-company records in the destination database. If you want to set these modules again in the destination database it is recommended you point to a new SONIC MQ server. This should prevent potential conflicts between the 2 databases. When copying the database is done, refer the last section of this document, Restarting Your Database HOW TO USE PROREST: 1) Open Progress Explorer and STOP the Appservers, and then the database you wish to overwrite. In this example we will use the "MfgSys80" database. Open the Appservers and Right click each Mfgsys80 Appserver and stop them. Then open Databases, and on the MfgSys80 database and select "Stop". 2) Go to your START menu, then to Programs, then to OpenEdge, then to your version number and then to Proenv. 3) At the Proenv prompt, type the word: "prompt" and press enter. 4) Next change directories to the target folder where you want to restore your MfgSys backup copy. The example uses the training folder. E:\EPICOR\TRAIN80\DB> 5) The following command is an example of restoring the backup.1 file from the F:\Backup folder to the training database directory. The syntax is: prorest mfgsys e:\backup\backup.1 If a database exists in the folder, you will be prompted a question "Do you wish to Overwrite?" answer "Y" for yes. When the process finishes, the prompt will be returned to the screen. HOW TO USE PROCOPY: 1) Open Progress Explorer and STOP the Appservers, and then the database you wish to copy from. In this example we will use the "MfgSys80" database as the database to copy from. Open the Appservers and Right click each Mfgsys80 Appserver and stop them. Then open Databases, and on the MfgSys80 database and select "Stop". Open Progress Explorer and STOP the database you wish to overwrite. In this example we will use the "Mfgtrain80" database. Open the Appservers and Right click each MfgTrain80 Appserver and stop them. Right click on the Mfgtrain80 database and select "Stop". 2) Go to your START menu, then to Programs, then to OpenEdge, then to your version number and then to Proenv. 3) At the Proenv prompt, type the word: "prompt" and press enter. 4) Next change directories to the target folder where you want the copy to be placed. This example uses the training folder. E:\EPICOR\TRAIN80\DB> 5) The following command is an example of copying the 'live' database to the training database directory. The syntax is: procopy c:\epicor\mfgsys80\db\mfgsys mfgsys This command will copy the database into the folder where you are standing or where ever your prompt is set at. HOW TO USE an OS COPY and then PROSTRCT REPAIR: 1) Make sure the source database is shutdown. Open Progress Explorer and STOP the Appservers, and then the database you wish to copy from. In this example we will use the "MfgSys80" database as the database to copy from. Open the Appservers and Right click each Mfgsys80 Appserver and stop them. Then open Databases, and on the MfgSys80 database and select "Stop". WARNING! Failure to do this will result in a damaged copy and possibly a damaged source database as 2) Open Windows Explorer and locate the source database. For this example a copy of the \Epicor\MfgSys80\Db\MfgSys database will be copied to the \Epicor\Train80\db folder. Using the key, click on 4 files: MfgSys.d1, MfgSys.b1, MfgSys.db and MfgSys.st. Copy and paste these 4 files to your Train80\db folder. 3) Next, double click on the copied MfgSys.st file in the target folder and open it with notepad. Note the path designation for each extent. If the path that precedes the is a dot or period (.) close the vantage.st. IF, the path has a full path designation as in the example below, change the path to reflect the new directory. BEFORE: # b c:\epicor\mfgsys80\db\mfgsys.b1 # d "Schema Area":6,32 c:\epicor\mfgsys80\db \mfgsys.d1 AFTER: # b c:\epicor\train80\db\mfgsys.b1 # d "Schema Area":6,32 c:\epicor\train80\db\mfgsys.d1 4) Go to your START menu, then to Programs, then to OpenEdge, then to your version number and then to Proenv. 5) At the Proenv prompt, type the word: "prompt" and press enter. 6) Next change directories to the Training or target folder where you just copied the files to. C:\EPICOR\TRAIN80\DB> 7) The following command will repair or reset the MfgSys.db to run from the new location. The syntax is: prostrct repair mfgsys *** Change drive letters and directory paths when necessary to reflect your configuration or your version. RESTARTING YOUR DATABASE After the database has been copied, the source and target databases will need to be restarted. 1) To restart the source database (MfgSys80 in our examples above), open the Progress Explorer Tool. Go to Databases, right-click on the MfgSys80 database and click Start. Then, go the AppServers, right-click on each MfgSys80 AppServer and click Start. The MfgSys80 database is now ready to be used again. 2) The configuration file for the target database (MfgTrain80 in our examples above) will need to be updated, so that it shows the correct location of the database file. For the MfgTrain80 DB, this file would be: E:\epicor\mfgsys80\server\config\mfgtrain.pf There is a line in this file that starts with a -db. Be certain this line points to the correct location of the MfgTrain80 DB. In our examples, it should be: -db E:\epicor\train80\db\mfgsys 3) To restart the target database (MfgTrain80 in our examples above), open the Progress Explorer Tool. Go to Databases, right-click on the MfgTrain80 database and click Start. Then, go the AppServers, right-click on each MfgTrain80 AppServer and click Start. The MfgTrain80 database is now ready to be used again. *** Change drive letters and directory paths when necessary to reflect your configuration or your version. -------------------------------------------------------------------------------------------------------------------------------- Copying the Open4 folder to a new location: The Window's Explorer can be used to copy the folder that Open4 is being stored in. The folder that needs to be copied is the folder with all the Open4 folders in it that was created when Open4 was installed. It looks like this: see attachment #1 You will notice that there is a "Data" directory (folder) that would normally be the default location for the database. During installation you can change the location to some other place if you wish. Either way you will want to not include that folder in your copy process using the Window's Explorer as I noted in the Overview section above. ---------------------------------------------------------------------------- Creating the desktop icon for the testing database see KB0032642. Notes PROBLEM: Attempting to interface Open4 to Vantage. But when I try to setup the Vantage Companies in Open4 using the menu path: Human Resource Open4 Interfaces Epicor Interface Epicor Master the drop down for the company identifier doesn't show my Vantage/Epicor companies. Why? RESOLUTION for Open4 connect to a Vantage 8.xx on Progress platform: Most likely the Open4 shortcut on the server does not include the path information needed to connect to the Vantage database. Add the following information to the properties for the shortcut db -N TCP -S -H The name of the Vantage database is generally "mfgsys". But they may have others if they have setup a training or test database. The 4GL port # of the Vantage/Epicor db can be found by running the Progress Explorer. Go to the database folder, click the vantage database being connected to, click configurations, click default configurations, select the mfgsysGroup, right click and choose prosperities, make sure the client type is 4GL. Use the number found in the Service name or port number. The Host name can be found in the c:\windows\system32\drivers\etc\Hosts file. Here is an example. In this case the Open4 application is loaded on the same servers as Vantage/Epicor. So the host name used is O4DBHost. -db mfgsys -N TCP -H O4DBHost -S 8000