Database server instance deployment with application setup

Posted on 2012-08-14
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,

Question by:philkeene
    LVL 6

    Accepted Solution

    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:

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

    Assisted Solution

    LVL 4

    Author Closing Comment

    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).
    LVL 86

    Expert Comment

    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
    LVL 4

    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
    This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now