Home Button  Buy Button 

Topic:   Convert back from SQL to local database

By: DecoPosted on: Nov 9 2017 at 03:05:22 AM
Hi, i would like to know whether it would be possible to convert back a SQL database to a local databse. I used the SQL database and it is quite unsuitable for my operations and i would revert back to a local database. Is there any way you can do that using a migration tool, etc?

By: SupportPosted on: Nov 9 2017 at 11:16:56 AM
Sorry. Currently there is only the upgrade tool (Up to SQL Server) but not a downgrade tool. Nobody ever asked for a DownGrade tool before.

The Local "MRP4DATA" database is based on Microsoft's "JET" database. (That's the same file format used by previous versions of MS Access)

Microsoft are dropping support for their JET format so we're moving away from JET in the next version (v5) of MiniMRP.

Version 5 will include migration tools to switch from all current databases to the new database formats. So if you can wait a few months then it might be better if you stay with SQL Server and switch to the new technology when it's released early next year.

By: DecoPosted on: Nov 9 2017 at 11:19:49 AM
And in version 5, i would be able to switch from SQL to the new technology?

By: SupportPosted on: Nov 9 2017 at 12:51:12 PM
Yes. Exactly.

We must be able to convert any existing user's database - MS SQL Server and JET/MRP4DATA files - to the new database format.

By: SupportPosted on: Nov 9 2017 at 12:57:36 PM
I just want to add that v5 will continue to work with MS SQL Server so users wishing to stay with MS SQL Server or migrate up to MS SQL Server can continue to do so.

But in v5 there will also be options to switch to MySQL databases. Either full server or a Local/zero admin (ie auto) setup running on the MySQL database format for single users or smaller work groups of users who do not wish to get involved with server admin.

It will also work directly with MySQL running as standard on many NAS Drives.

By: TammyPosted on: Nov 9 2017 at 01:24:15 PM
MySQL? Does that mean it will also connect to Mysql server on our internet web server and then our users can access it quickly from anywhere in the world?

By: DecoPosted on: Nov 9 2017 at 01:55:11 PM
Great! Thank you very much for the info. Can't wait for version 5.

By: GuestPosted on: Feb 27 2020 at 12:35:45 AM
Has the functionality to transfer from MySQL back to local database been introduced in the last few years?

By: GuestPosted on: Feb 28 2020 at 03:07:57 PM
Yes. Backup from MySQL and Restore that backup file into Standard.

Not sure if this is the official way to do it but this below worked for me.

Go to the C: drive. Go to the MiniMRP program folder. Go to the Tools folder. In there you have the tools program that you will have used to create the MySQL database and/or migrate from standard to MySQL. You use that same tools program to migrate the other way too. Run the tools program. Connect to MySQL Server. You see the Backup tab.

Once you've made the backup. Rename that backup file to something sensible "DATAFILE" or something like that and put it somewhere you and other users can see it.

Close the tools program. You won't need it again.
Start the MiniMRP program.
Go to the Left hand menu bar - Tools - Database Setup.
Switch it to use Standard Database (instead of SQL Server).
Click 'Browse' and point MiniMRP at the file you made earlier.

If you have other users then on each one go to the left hand menu bar, database setup and switch them to use standard database and point them at the data file.

That's basically it.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Convert back from SQL to local database

Enter the numbers.

Your name here is optional