Create Database Tables

<< Click to Display Table of Contents >>

Navigation:  Help > Troubleshooting > Previous Manuals > E-IM-RMS-WEB > Installation >

Create Database Tables

The empty database now needs the tables for the RMS. Proceed as follows:

Step 1

Select the RMS database (red arrow in Figure a) and select "Open file" (orange arrow in Figure a). Then load the script Rotronic-Rms-Tables.sql delivered with the software into the database.

 

E-IM-RMS-WEB-V1.3.1_create database table

Figure a: View of the script "RMS-Tables.sql"

 

Step 2

Click "Execute" to run the script (yellow arrow in Figure a).

 

Step 3

Verify that the tables have been created by clicking the "+" symbol in the RMS database (about 30 tables in the folder "Tables"). Sometimes the SQL server management studio needs to be restarted to see the tables.

 

 

 

Step 4

Configuration of the RMS database is then finished.