Silent install of SQL Express 2005

Question

4.00/5 (1 vote)

See more:

Hi,

I've create setup for my windows database application.SQLExpress 2005 is back end of my application so i create a bootstraper with the help of dotNetInstaller.
My questionis how to silent install SQLExpress 2005 ?
regards,
ambarish

Posted 23-May-11 22:44pm

ambarishtv

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-05-23T22:50:00

Solution 1

You shouldn't.

SQL is a very separate program: if you need it you should give the user the option to install it, or a later version, or to use any existing full or express version.

Think about it: If I have SQL 2008 R2 installed on a DB server, why would I want every PC in my building to have it's own, separate installation of SQL express 2005?

If you need to use a single user database for you application, then use something like SqlCE, which provides most of the full Sql functionality, with no additional software installation, other than that needed for .NET anyway.

Posted 23-May-11 22:50pm

OriginalGriff

Comments

ambarishtv 24-May-11 5:01am

I've use stored procedure, Is support SQLCE?

OriginalGriff 24-May-11 5:15am

No. Stored Procedures aren't supported in SqlCE - there isn't a lot of point in a single user environment where the processing takes place in the callers context, rather than a separate application as in SQL. However if you are using this as a single user DB anyway, it shouldn't take much to extract them into scripts anyway.

ambarishtv 24-May-11 5:29am

Thank you Griff