Automated SQL Server 2005 Express Installation as part of an Application Install.

Question

Post reply

Automated SQL Server 2005 Express Installation as part of an Application Install.

rag

Newbie

Points: 4
More actions
July 17, 2006 at 2:28 am

#173384

Has anyone tried this?

Creating a .bat file which installs SQLServer2005Express edition on fresh XP machine.

I want to include the SQLServer2005Express files as part of a VisualStudio Install package.
The install packing will install my application I then want the install package to run a bat file which will install SQLExpressEdition?

Has anyone done this?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

bledu SSChampion Points: 12335 More actions · Answer 1

I haven't done it, but i am thinking why would microsoft give you the functionality for an express edition?

Everything you can imagine is real.

rag Newbie Points: 4 More actions · Answer 2

to create demo\trial software etc

full version would use full sql server

ie not express edition!

bledu SSChampion Points: 12335 More actions · Answer 3

yes i hear you. but i think sql express was maybe aimed at the hobbist and entry level developers etc to play around with.

i am saying that because they ms have a trial edition of sql 2005, look at the comparison page

http://www.microsoft.com/sql/downloads/trial-software.mspx

and

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

so what i was saying in essence is that you might not get the install functionality that you want because it is my thinking that this is aimed at enterprise customers.

Everything you can imagine is real.

rag Newbie Points: 4 More actions · Answer 4

SQL Server 2005 Express Edition is free to download, has no time limits, and is freely redistributable (with registration). With a database size limit of 4 gigabytes (GB) and support for 1 CPU and up to 1 GB of RAM, SQL Server 2005 Express Edition is suitable for application embedding or lightweight application development.

So anyone done this

all im asking is for syntax of a BAT file which will install express edition on a machine

anyone out there lol

bledu SSChampion Points: 12335 More actions · Answer 5

oops raq, i might have to eat my words.

please goto

http://blogs.msdn.com/astebner/archive/2006/03/19/555326.aspx#605285

and

http://blogs.msdn.com/astebner/archive/2006/05/29/610435.aspx

i am trying to extract the files in the .exe file using winrar and see if i can run the silent install using the setup.exe file or whatever is extracted.

tell me if the solutions suggested in the above urls work for you

Everything you can imagine is real.

rag Newbie Points: 4 More actions · Answer 6

rag

Newbie

Points: 4

July 17, 2006 at 9:46 am

#649596

cheers mate

second link looks good!

Dan Jones-279024 Ten Centuries Points: 1362 More actions · Answer 7

Take a look at the following white paper for embedding SQL Express into your application's setup program: http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp