Running the database creation scripts, Importing the data – Rockwell Automation Emonitor with an MS SQL Networked Database User Manual

Page 21

Advertising
background image

3

I

NSTALLING

E

MONITOR

17

• •

11. The installation is nearly complete. Select Yes, I want to restart my computer now

and click OK to restart your computer. The Emonitor installation is now complete.

Running the database creation scripts

You must run a database creation script to create the Entek and EConfig databases. If the
Entek databases already exist, you can connect to them, and you do not need to follow
these steps. The scripts to create the databases are installed with Emonitor, so they
can only be run after you install Emonitor.
See Running the database creation script on
page 11..

Importing the data

1. After running the table creation script, you must import the data into the tables. Select

Start > Program Files > Rockwell Software > Emonitor > Utilities > Emonitor
Import-Export Utility
.

2. From the Options menu, choose Import. Choose the following settings for each field.

Leave Database blank.

For Username, enter your username.

For Password, enter the password for the chosen username.

Before starting Emonitor for the first time, you must import the Emonitor data. See the next
section, Importing the data on page 17.

If you are upgrading Emonitor version 3.70 on a network system with a pre-existing Emonitor
database, do not run the database creation scripts, The Emonitor databases already exist on
your database server.

If you are upgrading Emonitor version 3.70 on a network system with a pre-existing Emonitor
database, do not perform the steps in this section. The Emonitor databases already exist on your
database server.

This procedure must be done after installing Emonitor because you use the data import utility
provided with the installation. It must be done before you start Emonitor for the first time, but after
you run the database creation scripts (describe in the chapter on installing the database
components).

Advertising