I am interested in deploying a database with my set up programs. I have a few ideas for .net applications and Java applications, however I seem to meet the same problem every time. I am guessing that I am missing something obvious, but I was wondering if someone could point me in the right direction.
What I would like to do is, if the database does not exist on the PC it will automatically set up a database server instance, create the database and restore a database schema to the database, as part of the set up process. I want to make this as painless as possible for the user.
I am open to suggestions on database type, however I am looking for no or very low cost.
This seems like such a fundamental thing, that I must be missing something obvious.
I will consider a successful answer to be :
A link to a useful tutorial on how to do this, or
A database type, and a command line/.net/other tool to achieve the process described above.
The crucial thing is that the user must not have to do any more than perhaps click "Next" and "Finish", but the preference would be completely silent installation.
Thanks in advance,