How to deploye SQL 2005 Express with my application

21 Nov 2006 3:24 PM

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

21 Nov 2006 3:37 PM

David Browne

"Rico" <m*@you.com> wrote in message

news:MSE8h.349364$R63.85587@pd7urf1no...

> 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

22 Nov 2006 3:23 AM

Rico

Excellent! Thanks David!

Rick

Show quoteHide quote

"David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in
message news:OTgVwLYDHHA.1196@TK2MSFTNGP02.phx.gbl...
>
>
> "Rico" <m*@you.com> wrote in message
> news:MSE8h.349364$R63.85587@pd7urf1no...
>> 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

21 Nov 2006 4:05 PM

Ken Tucker [MVP]

Hi,

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

Ken
----------------------------

Show quoteHide quote

"Rico" wrote:

> 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
>
>
>