Can I install SQL Server Express 2005 from the command line?

Posted on 2007-12-02
Last Modified: 2010-04-21
My users constantly complain that the installation of SQL Server Express 2005 is too complicated... is there a similiar database that is easier to install (like from the command line, so I could do it programmatically), or is there a better, smaller, free t-sql compliant database engine I have missed?  I looked at SQL Server Compact 3.5, but it is missing most of the t-sql statements (like IF for starters).
Question by:rmmarsh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 55

Expert Comment

by:Jaime Olivares
ID: 20392956
>>My users constantly complain that the installation of SQL Server Express 2005 is too complicated
That's not a good reason to switch to another database, maybe you need to write an installation manual.
An sql server is a big product with lots of configurations, SQL Server EE is one of the simplest to install

>> or is there a better, smaller, free t-sql compliant database engine I have missed?  
no, all sql engines have differences.


Author Comment

ID: 20392965
Hi Jaime... yes, I have written an installation page/manual... most of them get it right, just taking the defaults, but then some of them are clueless... so, I'm trying to find another way to do this... wouldn't mind staying with EE because all of the work is already done (program has been running for years)...

Do you know of a way to automate the installation?  Like from the command line, or keyboard recorder/player, etc?


Expert Comment

ID: 20392998
have a look at this:

(SQL Server 2005's Undocumented Solution for Unattended Installs)
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

LVL 55

Accepted Solution

Jaime Olivares earned 500 total points
ID: 20393005
yes, there are many features to install sql expres. Have a look to this Microsoft document ("Embedding SQL Server Express into Custom Applications")

LVL 55

Expert Comment

by:Jaime Olivares
ID: 20393026
Well, indeed it is no "undocumented" since there is a Microsoft's document about this.

Expert Comment

ID: 20393036
it might not be undocumented but that's the title of the article...

Author Closing Comment

ID: 31412239
Wod:  your suggestion is unsupported and I can't take the chance that it will not work.  Jaime hit it right on the head.

Thanks Jaime... again!

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Upgrading SQL 2005 Express to 2008 R2 Express 31 163
Move SQL 2005 Express to Server 2012R2 19 168
Help with simplifying SQL 6 54
Addition to SQL for dynamic fields 6 56
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.…

726 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