Importing/Exporting access databases in C# Visual Studio 2010

I've made a program to manage a movie collection and it stores the data in an access database. I realise it can be done manually, but I'd like it to be possible to export and import the databases from within the program, so that users don't have to start their database from scratch every time I bring out a new version.

How do I go about doing that?

I'm still pretty new to programming so if I've forgotten to mention anything, please do ask!

Answers


You need to export each table's records to a file in a format of your choosing (ie, csv, xml, your own format, etc) with a export version number (so later versions of your program know what format they will be reading in). This is serializing your data, and you can find lots of information on how to save out data.

To import, you will need to read in each exported file, and insert this into a new database. This is just the other face of serializing your data, so again, there are lots of informaiton sources on how to do this.

If you are going to allow users to re-import data into an existing database, you will need to decide on how you handle duplicate entries, and whether there is a batch process that users can use so they only have to pick how to handle duplicates once (ie, have user choose once to overwrite all existing records or have user choose to skip all existing records).


This is a pretty broad question, so I'll answer it broadly. You can create the database through code, which I'll let you research how to do. Should be plenty of articles on how to do this.

You can also include the database as part of your deployment through whatever deployment means you have. You'd want to get their database, load up the results in code and fill in the deployed database and then remove their original.

You could also just change the existing database on their machine to match your new changes. If it's something like additional columns or another table, that would be pretty easy.

The choices are numerous and you just need to pick one. Hope these ideas help.


Need Your Help

Scala + Reactivemongo: Controling custom readers/writers for REST-API

json scala rest reactivemongo scalatra

I am working on a REST-API implemented in Scalatra and using reactivemongo. My persistent model is implemented using case classes and a thin repository layer uses the common approach for bson<->...

Can't click in a field in HTML/CSS LESS

html css less

I create a website and I have a problem, I can't click in some field (or buttons) on my page which are in the Login fieldset. I can just click in filed (or buttons) which are in the Register fields...