I have an application that currently uses a proprietary binary file to store transactional data. In theory it works fine. The only problem is that it requires the entire set of data to be loaded into memory when the user opens the database. Additionally it makes it hard if not impossible to allow more than on user to use the data at the same time.
For these reasons and general robustness I would like to switch over to using some type of a prebuilt database solution. I have been trying to read up about using ADO.NET, microsoft Jet and others. I am kind of just brand new to all of this and wanted to get some leads on what I need to do to develop a database to store this data in. I am mostly looking initially at just determining which database I should use.
Can you give me a rundown of my options?