Feature Request: Multiple SQL Database Support

[dj-ellis]

Is your feature request related to a problem? Please describe.

• When training users, it would be useful to be able to utilise a training dataset, with a standard front-end, rather than live system data.

Describe the solution you'd like

• Creation of an additional SQL Database for training use
• The option to select the database to use at the Login screen - for example: Live Data, Training Data, Sample Data - from a drop-down menu.The system then utilises the database selected.

Describe alternatives you've considered

• It is possible to install the system twice - to separate folders - and create separate sql databases. This then requires multiple systems to be updated should features change or develop. A single front-end with selectable datasets would ensure users are always on the latest version.

Additional context

• Additional SQL database creation required by end users - so perhaps documented as an advanced feature, or a default set of databases could be provided.