How to deploye SQL 2005 Express with my application

[Rico]

Hello,

I have an application that uses SQL Server express. I'd like to be able to
package the SQL Server Express set up file and deploy it with my application
but all the searching I've done only tells me how to deploy SQL Server
Express manually (i.e. how to set it up yourself). I can script my set up
to see if an instance of SQL Server Express already exists but if it
doesn't, I'd like to know the best way to deploy this on the target machine
automatically.

Any help or direction would be greatly appreciated.

Thanks!
Rick

 

[David Browne]

Hello,

I have an application that uses SQL Server express. I'd like to be able
to package the SQL Server Express set up file and deploy it with my
application but all the searching I've done only tells me how to deploy
SQL Server Express manually (i.e. how to set it up yourself). I can
script my set up to see if an instance of SQL Server Express already
exists but if it doesn't, I'd like to know the best way to deploy this on
the target machine automatically.

Any help or direction would be greatly appreciated.

See:

Embedding SQL Server Express in Applications
http://msdn2.microsoft.com/en-us/library/ms165660.aspx

Embedding SQL Server Express into Custom Applications
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/emsqlexcustapp.asp

David

 

[Guest]

Hi,

In addition to David's comments if you use Click Once to deploy your
application it will install sql express for you.

Ken

 

[Rico]

Excellent! Thanks David!

Rick

See:

Embedding SQL Server Express in Applications
http://msdn2.microsoft.com/en-us/library/ms165660.aspx

Embedding SQL Server Express into Custom Applications
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/emsqlexcustapp.asp

David