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. Figure 1 |
| Step 4 | Configuration of the RMS database is then finished. |