I've a small Windows Form (.net) app - basically a glorified calendar/organiser customised for a particular industry. I've been using SQL Server Compact Edition quite happily for the backend but this seems now to have been deprecated by MS and does not play nicely with the latest Visual Studio. I've also had requests to make it multi-user.
So, looking for a replacement. The ideal candidate will integrate well with VS, install easily on remote workstations, and support concurrent connections, preferably without going full monty client server.
So far considered
Access (Jet): file-based but prone to corruption.
SQLLite unknown quantity but apparently recommended by MS.
SQL server LocalDB: not sure if this is genuinely multiuser, and
SQl Server Express or MySql if there's nothing more suitable.
Experience/Recommendations? When I say multi-user we are probably talking 5 users tops, a few Gb data max and light usage.
So, looking for a replacement. The ideal candidate will integrate well with VS, install easily on remote workstations, and support concurrent connections, preferably without going full monty client server.
So far considered
Access (Jet): file-based but prone to corruption.
SQLLite unknown quantity but apparently recommended by MS.
SQL server LocalDB: not sure if this is genuinely multiuser, and
SQl Server Express or MySql if there's nothing more suitable.
Experience/Recommendations? When I say multi-user we are probably talking 5 users tops, a few Gb data max and light usage.
Comment