Skip to content

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.