We help IT Professionals succeed at work.

Database server instance deployment with application setup

Hi,

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,

Phil
Comment
Watch Question

Commented:
Microsoft SQL Express can be installed via command line where you can set it to install unattended by working thru the setup parameters in MSDN. Once the SQL is installed, you can have it to run T-SQL scripts to re-create the database you need. A tutorial is available at this address:

http://blogs.msdn.com/b/sqlexpress/archive/2006/09/20/configuring-sql-express-during-installation.aspx

Derek has some great articles on SQL unattended installation with install scripts on his blog.

http://derek858.blogspot.sg/2012/07/sql-2012-unattended-install-scripts.html
CERTIFIED EXPERT
Top Expert 2016
Commented:

Author

Commented:
Thanks to you both, these are great. I will let you know if I have any further questions (but obviously post a new question if necessary).
CERTIFIED EXPERT
Top Expert 2016

Commented:
Of course, there is no setup involved in the JavaDB approach. If there is already a VM, you have zero-install. If you don't, you can automate install via Java Web Start

Author

Commented:
Thanks for the clarification CEHJ, it certainly looks like the best option for Java applications...

Explore More ContentExplore courses, solutions, and other research materials related to this topic.