I note that Training Mode only works when connected to an SQL Express DB. As I notice training mode sets up a new database and updates connection string.
Is it possible to implement training mode with SQL LocalDB ? I read about the specification of LocalDB when I looking into it and read that you can have multiple databases connected to a LocalDB instance, just in the same way you can with a full SQL instance. Therefore I thought it might be possible to have training mode implemented this way?
I know it is possible to just copy the .mdf & .ldf files after SambaPOS has been closed, however although this worked fine for SQL CE, this is a bit problematic with LocalDB since the sqlservr.exe instance doesn’t terminate immediately after closing SambaPOS and appears to remain active for at least a few minutes (possibly more) afterwards, at which time you cannot copy those files as they’re locked, and personally I have end task of sqlservr.exe in task manager, which I am a bit concerned when doing so as unsure if it might cause any issue to the databases doing in such a way (haven’t had any issue so far but just saying…). I don’t think non technical users should be ending tasks of the database as I can foresee so so many problems occurring with that…
I think training mode is very convenient and useful for giving training or trying out a new feature on a live system, and if can be implemented with LocalDB would be quite beneficial to all.