|By: Randy||Posted on: Dec 5 2017 at 09:56:21 PM|
|Can the enterprise version serve two users from different locaations by placing the DB files in a files synced across cloud storage?|
|By: Guest||Posted on: Dec 6 2017 at 07:56:12 PM|
|The main difference is that the enterprise version can use MS SQL Server as the database. If your remote users have access to your company network where SQL Server is running then yes, many users can share the same data at the same time.|
But if you're talking about something like DropBox then that would only work if both users were NOT working at the same time. The problem with drop box is that it just was not designed for reading AND writing to a file from multiple locations. Some people do use DropBox though especially where people are not literally working simultaneously.
|By: Randy||Posted on: Dec 7 2017 at 01:05:09 PM|
|Thank you for your feedback. The latter is the expected scenario. One parrt would do the maintenance of the application, the other would just need to access to print reports etc. We could coordinate login. We will continue to evaluate. Have you ever thought of porting to SQLLite?|
|By: Support||Posted on: Dec 7 2017 at 04:52:50 PM|
|If only one user needs to edit and the other is just reading then I'd suggest NOT actually working in the drop box. Leave MiniMRP installed in its default folder and then, periodically, copy the MRP4DATA file into the dropbox folder where the other guy can copy it to his own working folder.|
SQLite. Yes. We have considered it. I have it working on my desk. But I don't believe that will be released.
SQLite has exactly the same problem as JET. It's a single file that is read and written to from multiple locations so would not be reliable on DropBox if multiple users are writing close together.
I will add that we WILL release a version using MySQL (MariaDB). If you have something like a WD MyCloud NAS Drive with built-in MySQL Server you could, in theory, expose that MySQL Server to the internet. You'd need to consider security of course so setting it up via VPN might well be a better idea.
You could install MySQL Server on one of your office computers and use that as a main server. But we'll ship MniMRP with a compact, zero-config, server built in to the installer so the user won't need to set anything up. It would just work in local mode of course but if you know how to setup port forwarding in your internet router you could, in theory, allow your remote user to login to the server running on your computer and share the database in situ.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.