We help IT Professionals succeed at work.
Get Started

Database server instance deployment with application setup

Last Modified: 2012-08-14

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,

Watch Question
This problem has been solved!
Unlock 2 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE