Part IV: Post-Installation
Chapter 13: Restore Demonstration Database
Use the following instructions to restore the Epicor 9.05 Demonstration Database, if desired. The Epicor 9.05 Demonstration Database is released with every Service Pack and is used with the Embedded Education Courses.
13.1 Download Demonstration Database File
Use the following instructions to download the appropriate Demonstration Database file based on your database platform. Each *.zip file includes a copy of the Demonstration Database that can be restored to replace the existing Demonstration Database.
1. Log on to EPICweb and go to the Customer Portal Page. Navigate to Support > Epicor 9 > Downloads.
You can click this link: https://epicweb.epicor.com/Support/epicor9/Downloads
2. Navigate to Epicor 9 > Version 9.05.600 > Demonstration Database.
3. Download the latest Epicor 9.05 Demonstration Database related to this installation. For example, download
the necessary files, based on your environment:
• SQL (32): Epicor9_Database_90560xx_Vx_Win32SQL.zip • SQL (64): Epicor9_Database_90560xx_Vx_Win64SQL.zip
• SQL Unicode (32): Epicor9_Database_90560xx_Vx_Win32SqlUnicode.zip
13.2 Verify Prerequisites
Use the following instructions to verify the prerequisite steps have been completed.
1. All Appservers and OpenEdge Databases are stopped.
2. Epicor 9.05 Service Pack or Patch has been installed, if available. 3. Epicor 9.05 Post-Installation steps have been completed.
13.3 Restore the Demonstration Database - SQL Server
Use the following instructions to restore the Demonstration Database using SQL Server. These instructions assume you have an EpicorTrain905 database in SQL Server 2008.
1. Go to the location where you downloaded the zipped files.
2. Open the .zip file. For example, open Epicor9_Database_90560x_Vx_WinxxSQLx.zip file. Extract the Epicor9_Database_WinxxSQLx.BAK file directly into the C:\Program Files\Epicor
Software\Epicor905\db\Training folder.
3. Navigate to Start > Program > OpenEdge 10.2A > ProEnv. A DOS window opens. 4. At the proenv> prompt, type: Prompt and press Enter.
6. At the c:\> prompt, type: cd Program Files\Epicor Software\Epicor905\db\Training and press Enter. 7. At the C:\Program Files\Epicor Software\Epicor905\db\Training> prompt, run the Prorest command. For
example, type one of the following and press Enter: • SQL 32 bit: prorest mfgsyssh mfgsyssh32.bkup
• SQL Unicode 32 bit: prorest mfgsyssh mfgsyssh32u.bkup • SQL 64 bit: prorest mfgsyssh mfgsyssh64.bkup
• SQL Unicode 64 bit: prorest mfgsyssh mfgsyssh64u.bkup
8. At the overwrite message, type Y and press Enter.
9. When the restore is completed, you are returned to the C:\Programs Files\Epicor
Software\Epicor905\db\Training> prompt. Type exit to close the DOS window.
10. At your server, navigate to Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio (SSMS).
11. Within SSMS, verify the Server Type is connected to the database engine. 12. Navigate to the Databases node.
13. Right-click on the EpicorTrain905 database. From the context menu, select Tasks > Restore > Database.
The Database window displays.
14. Click on the General tab. Within the Source for Restore section, select From Device. 15. Click on the [...] button. The Specify Backup window displays.
16. For the Backup Media option, select File.
17. Click the Add button to locate and select the backup file. This file is: Epicor9_Database_WinxxSQLx.BAK 18. Click OK twice to complete the selection.
19. Select the check box next to the Backup Name field. This defines the back up set to restore. 20. Click on the Options tab.
21. Select both the Overwrite the existing database and Leave Database Ready to use (Restore with Recovery) check boxes.
22. Verify the Restore Database Files As fields match the correct server directory paths where the database
files currently exist. For example:
• C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ EpicorTrain905.mdf • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ EpicorTrain905_log.ldf
23. Click OK.
24. A dialog box displays indicating the database restoration is complete. Click OK. 25. Exit SQL Server Management Studio.
13.4 Import Product Licenses and Enable Modules
Use the following instructions to import the product licenses and enable the modules.
1. Open the Epicor Admin Console. To do this, navigate to Start > Programs > Epicor Software > Epicor Administrative Tools > Epicor Administration Console.
2. Login with a valid User ID and Password. Note that the user must have Security Manager rights. For example,
login as manager / manager or epicor / epicor.
3. Connect to the location of your training environment, such as EpicorTrain905. 4. Specify the imported license file for each company. To do this:
a. Right-click on Company, such as Epic01, and select Properties.
b. Browse and select the license serial number to the imported license file. Click OK. The file is imported. c. Repeat for each of the other companies, such as Epic02 and Epic03.
5. Enable the modules attached to the imported licenses. To do this:
a. From the list, select Licensing.
b. Right-click on the license serial number and select Properties. c. Click the Modules tab.
d. Select the individual modules to activate, or click Enable all Licensed to select all the modules. The
Enabled check box should be selected for the modules you want to activate.
e. Click OK.
6. When finished, exit the Epicor Administration Console.
13.5 Start Database and Main Appserver
Use the following instructions to start the database and main Appserver.
1. Use the Progress Explorer Tool or OpenEdge Explorer Tool to start the following functions in order:
• Start the Database: EpicorTrain905 • Start the Appserver: EpicorTrain905
13.6 Run Manual Conversion
Use the following instructions to run the required manual conversion to reset the sequence table. Your main appserver must be stopped prior to running the conversions, and then restarted after the conversion has finished.
1. If your main appserver is started, you must stop it prior to running the conversions. For example, use the
Progress Explorer Tool to stop the EpicorTrain905 appserver.
2. Open the Epicor Admin Tools program. To do this, navigate to Start > Programs > Epicor Software > Epicor 9.05 > Epicor Admin Tools.
3. Login with a valid User ID and Password. Note that the user must have Security Manager rights. For example,
login as manager / manager.
4. Select Run Database Conversion.
5. Scroll down the list of programs to number 5460 called Re-set DB Sequences. Highlight the program to
select it.
6. From the Conversion menu, select Run Conversion Program. Click Yes to confirm. 7. After the conversion finishes, exit Epicor Admin Tools.
8. Start your main appserver. For example, use the Progress Explorer Tool to start the EpicorTrain905 appserver.
13.7 Set Up System Agent for Printing (Demo Database)
Use the following instructions to set up your system agent. The paths for the System Agent, which control report printing, must be reset after a database restore.
These instructions assume your database is set to be the Mfgsys database directly located in this folder: C:\Programs Files\Epicor Software\Epicor905\db\Training.
1. Review the paths you specified during the server software installation for the following locations:
• Destination Location
• Print Folder Destination Location • Server Share Location
2. Launch your Epicor 9.05 application.
3. Navigate to System Management > Utilities > System Agent. 4. Click Agent ID to search for the system agent identifier.
5. The identifiers are listed. Select SystemTaskAgent. Click OK.
6. In the Task AppServer section, change the AppServer URL to AppServerDC://localhost:9413. 7. In the System AppServer section, change the AppServer URL to AppServerDC://localhost:9411. 8. For the Password, enter manager.
9. In the SystemAppServer section, enter your directory paths. For example: Examples Description Directory c:\Program Files\Epicor Software\EpicorData/usr/epicor/epicordata specifies the local path on the server to
the print directory Server File
\\<servername>\EpicorData specifies the unc path to the print
directory Client File
\\<servername>\Epicor905\Server specifies the unc path to the server
directory Client Program
10. Save the System Agent changes. Exit System Agent Maintenance. 11. Close the Epicor 9.05 application.
13.8 Restart Remaining Appservers
Use the following instructions to start the remaining Appservers.
1. Open the Progress Explorer Tool or OpenEdge Explorer Tool. Start the following Appservers in order:
• EpicorTrain905TaskAgent • EpicorTrain905ProcessServer
2. Exit the Progress Explorer Tool or OpenEdge Explorer Tool.
13.9 Test Demonstration Database Update
Use the following instructions to verify that the Demonstration Database was properly updated.
1. Open the Epicor 9.05 application.
2. Log on using your Username and Password. 3. From the Help menu, select About Epicor 9.