 |
|
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.
| |
| By: Guest | Posted on: Oct 22 2025 at 11:30:22 AM | Yes. The backup file gets a .bak file name but that's just a file name. The file is a standard JET file but with the .bak file name extension. It doesn't need restoring or converting. You can connect to it as is but probably best if you rename it to a new name without the .bak
| |
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
|
|
|
