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.

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