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 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.