 |
|
Topic: MariaDB to Jet?
|
| By: Guest | Posted on: Oct 16 2025 at 04:17:28 PM | I will be out in the field without internet access, but may still need MiniMRP access. In the office, we use MariaDB. Is it possible to export to a standalone Jet DB for temporary use? Lookup only - I will not be making any changes in the Jet DB that would need to be uploaded to MariaDB.
| |
| By: Guest | Posted on: Oct 17 2025 at 05:34:34 AM | On your computer In the folder where MiniMRP is installed you see a 'Tools' folder.
In there is a program name DBTools or sqlTools or something like that (depending on version)
Open that and you'll have a login window. One you've entered the server's name/address, login name and password you'll get a row of Tabs. One of those is 'backup'. It backs up to what they call a 'Migration File'.
Put that onto your laptop. Then, on your laptop, start MiniMRP. Go to database Setup and switch it to Local/Default/Jet mode and navigate to that backup file. Voila, you're now using a Jet database identical to the one on your SQLServer. | |
| By: Guest | Posted on: Oct 17 2025 at 09:11:20 AM | | Perfect! Thanks! | |
| By: Guest | Posted on: Oct 18 2025 at 08:14:40 AM | I think there's a step missing...
The DBTools app makes a .bak backup file. MiniMRP can't read that file directly, so it must be restored or converted somehow.
| |
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
|
|
|
