• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

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

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).
0
rmmarsh
Asked:
rmmarsh
  • 3
  • 2
  • 2
1 Solution
 
Jaime OlivaresSoftware ArchitectCommented:
>>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.

0
 
rmmarshAuthor Commented:
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?

R
0
 
WodCommented:
have a look at this: http://www.devx.com/dbzone/Article/31648

(SQL Server 2005's Undocumented Solution for Unattended Installs)
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Jaime OlivaresSoftware ArchitectCommented:
yes, there are many features to install sql expres. Have a look to this Microsoft document ("Embedding SQL Server Express into Custom Applications")
http://msdn2.microsoft.com/en-us/library/bb264562.aspx

0
 
Jaime OlivaresSoftware ArchitectCommented:
Well, indeed it is no "undocumented" since there is a Microsoft's document about this.
0
 
WodCommented:
it might not be undocumented but that's the title of the article...
0
 
rmmarshAuthor Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now