Add Epicor Database

Use these steps to add an Epicor database (new or demonstration) using the Epicor Administration Console. When this database is created it is empty and scripts are run to populate it with initial data, including tables and fields for menus, security and reports.

1. Prior to adding a database, verify that the Full-Text Search feature is installed on your SQL Server instance.

Full-Text Search is required in order to create databases using the Epicor ERP 10.1 application. Refer to the previous steps in the Getting Started > Verify Prerequisites > Verify SQL Server Install and Features section.

2. Open your Epicor Administration Console, if it is not already open.

On the server where your Epicor application is installed, navigate to Start > All Programs > Epicor Software

> Epicor Administrative Tools > Epicor Administration Console.

3. Expand Database Server Management. Right-click on your Server/Instance and select one of the options

to add an Epicor database:

• Add New Database - Use this option to launch the Database Migration tool to add a new database. The new database contains seed data only.

• Add Demo Database - Use this option to launch the Database Migration tool to add a new

Demonstration Database which is used for educational purposes along with the Epicor Education Module.

4. For either a New or Demo database, the Add New Database dialog opens. Your dialog may look similar to

the following:

Enter the following:

a. Enter a Name for your database.

Note Your database name cannot include a space. After the database is created you cannot

change the database name. If the database name already exists on the server, you will be prompted to confirm the name when the database creation process starts.

b. Enter the Deployment Server path to specify the deployment share location. This path is used by the Epicor Administration Console to verify that it has the required components to service the database. These components can then be downloaded from this location.

• If you are on the deployment server, enter a fully qualified path such as C:\Epicor\ERP10\ERP10.1.xxx.

5. The Create Database on Server dialog displays. If the database creation process does not start by default,

click the Start button. A status bar displays the creation process. This may take a few minutes. Your dialog may look similar to the following:

6. If you selected Add New Database, the database is ready to be created using the default values. If you

want to change the default values and configure the database properties before it is created, on the Create Database on Server dialog, from the Action menu , select Configuration. The Configuration dialog opens. Your dialog may look similar to the following:

7. If you want to use your default configuration settings, select the Use Existing Database check box. The

MDF and LDF sections become read-only.

8. For the Target database, verify the Master Database File (MDF) Information. Note that for more

information on MDF settings, refer to your Microsoft SQL Server user guides and online help. a. In the MDF Location field, verify the default path to the master database file.

b. Review the Initial MDF File Size in GB value. Epicor recommends to set this value close to the size of the future master database file.

c. Keep the Autogrowth check box selected if you want the file to increase automatically when new data is added. In the Autogrowth settings section, use the MDF File Growth fields to specify the file growth rate. Select the Restricted File Size Growth option and set the maximum size for the MDF file if you want to limit this value, or keep the Unrestricted File Size Growth option selected. If you use MDF

autogrowth and do not restrict the file size, the MDF file should be regularly monitored and managed by a database administrator.

9. For the Target database, verify the Log Database File (LDF) Information. Note that for more information

on LDF settings, refer to your Microsoft SQL Server user guides and online help. a. In the LDF Location field, verify the path to the log database file.

b. Specify the Initial LDF File Size in GB value. Epicor recommends to set this value close to the size of the future log database file.

c. Keep the Autogrowth check box selected if you want the file to increase automatically when new data is added. Define Autogrowth settings. Use the LDF File Growth fields to specify the file growth rate. Select the Restricted File Size Growth option and set the maximum size for the LDF file if you want to limit this value, or keep the Unrestricted File Size Growth option selected. If you use LDF autogrowth and do not restrict the file size, the LDF file should be regularly monitored and managed by a database administrator.

10. Click Test Connection to verify. Click OK to the validation message. 11. Click OK to save the configuration values. The Configuration dialog closes.

12. Back on the Create Database on Server dialog, click Start. The processing begins. This may take a bit of

time. If you want to view the processing messages, click the Show More button. If you want to hide the processing messages, click the Show Less button. Your dialog may look similar to the following:

Note If the database name already exists, you are prompted with a message to enter a password to

confirm that the existing database should be deleted in order for the new database to be created. Enter the password specified in the message and click OK to confirm.

13. During the creation of the database, progress is displayed using green check marks next to the task. Note

displayed next to each task. Verify that your tasks have all completed. Your dialog may look similar to the following:

14. After completion, click the Show Log button to display the DB Migration log. Review the information. Your

dialog may look similar to the following:

15. Click Close to close the log file.

16. Click Close to close the Create Database on Server dialog.

17. Verify that your new database displays under your Server in the tree node. Your dialog may look similar to

the following:

18. If you selected the option to Add Demo Database for educational use with the Epicor Education Module,

it is recommended that you create a back-up of this demonstration database. For example, create a backup and name it DEMO_ERP10. When you need to refresh (restore) the demonstration database, this backup database can be restored to the named demonstration database. Refer to the Appendices > Troubleshooting > Restore Demonstration Database section for more information.