How can I use my applications in any machine without building the databse and its tables every time in the new machine?

Question

0.00/5 (No votes)

See more:

, +

I have developed application which mainly uses sql databases to store and save data. My problem is, the application works well in my machine because MySQL Workbench installed locally in my machine and no problem with connections between the application and my sql. However once I installed the application in another computer, I can not work and am always getting (Unhandled exception has occurred in your application). I know that the problem is because of missing databases and sql in the second machine.

My question is: How can i use my applications in any machine without building the databse and its table every time in the new machine? is it possible to export sql databse and use it sepearately from MySQL workbench? By other words, is there any way which can make my application works well in any computer by using sql databse files in my application and make my software independent from MySQL workbench

What I have tried:

The problem can be solved; if I installed MySQL workbench in the second computer and setup the tables of database. each time should I do like this procedure.
How can I use the databses files in my application which can make the application useable in any software without installing MySQL each time.

Posted 27-Jan-19 21:01pm

EngAb1989

Updated 27-Jan-19 23:02pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2019-01-27T21:13:00

MySQL is a multiuser database - which means it is installed on a server, and various client applications (such as yours) connect to it and they all access the same database.
This is fine, but it requires a substantial investment on a single computer to support the DB server, and it requires new databases to be constructed on that server by MySQL before any of the clients can access them.

And that's what you are doing when you install Workbench - installing MySQL on a local machine to use it in your app.

Which isn't the idea at all - if you want multiple copies of a DB so each user has his own, then use a single user DB such as SQLite, or Access - dont; use MySql or SQL Server at all as they are "heavyweight" solutions designed for multiple users and require substantial investment from the client which is not likely to be popular.
For example, if your app came to me and insisted on installing MySQL it would get deleted post haste: I already run SQL Server locally for dev and don;t need another server DB system installed!

If you need multiuser access use a server based DB, and make the client having a working installation a precondition of your installer. If you don't, use a single user DB which has a much smaller footprint, and just include the required DLL files with your app.

RickZeeland · Accepted Answer · 2019-01-27T23:03:00

Solution 2

Here is an overview of lightweight databases, with their pros and cons:
https://www.slant.co/topics/69/~best-lightweight-databases[^]

Posted 27-Jan-19 23:03pm

RickZeeland

Comments

EngAb1989 28-Jan-19 5:33am

Thanks very much, I found, it is very helpful