Create Database Tables

<< Click to Display Table of Contents >>

Navigation:  Help > Troubleshooting > Previous Manuals > 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 1) and select "Open file" (orange arrow in Figure 1). Then load the script Rotronic-Rms-Tables.sql delivered with the software into the database.

Step 2

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

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 need to restart SQL server management studio to see the tables.

 

create database tables 1

 

Figure 1

Step 4

Configuration of the RMS database is then finished.