Database-related articles
From version 22.2 and later, Reports had its own MeasureColor Reports Database Utility. With this utility, you can create and migrate databases, set connection strings, and so on. Using the Windows key and typing the name you can find and start it. With any installation or update, the installer will run it automatically.
- Create local database
- Create External database
- Migrate database
- Maintenance mode
You can change the database connection using the 'Migrate database' button, green checkmarks will indicate the connection string is valid and a connection can be made.
Don't forget to Run the migrations to ensure all tables are updated to the later version.
Setting the database connection strings on legacy Reports versions
Normally you would set these before installing but when moving or changing databases it might be needed to change these.
- The connection strings can be found in two files, both named databasesettings.json. One is in the normal Reports folder, the other one in the service folder. Both need to be edited.
- You need to restart IIS before the settings become active.
- Please be aware that any software update or repair won't access these files but will use the settings made when running the installer.
Migration of the database
- Open a Powershell as administrator
- Navigate to the folder
CD C:"Program Files""Colorware BV""MeasureColor Reports""MeasureColor Reports"
- Execute
.Colorware.Reports.exe --ef-migrate