2

I would like to develop an application in C# which use the mySQL dbms. I will have to install this software on different pc and all of them will have different records inside their database. Is it possible to store this database in a single file to provide a better mobility or will I have to install the mySQL dbms on all these machines and store the db inside the local server? If it can't be done, is there any performant dbms that allows the database to be stored inside a single file? Thank you for your answers!

Improve this question

1 Answer 1

Reset to default
1

You can store a whole Innodb database in a single file - but you'll still need to install MySQL on the target machine. For a single user DBMS, this doesn't make a lot of sense. Since you're writing in C# the application will only run on MSWindows machines which would point one towards a JET based approach - but the MDAC legacy has got a bit confused. SQLite looks a lot less painful.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you for your answer. You are right, installing a whole server program like mySQL on all the target machines is pointless. I will definitely try SQLite as it seems enough for my needs and it is also free.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.