deployment of application along with database ???

[mihirpatel83]

I have developed an application in VB.net and Sql Server 2005 Express Edition..

I hv tried a lot searching for Packaging and deployment of application along with database...

Can anyone guide me how to make a setup tat included sql server as well ...

Thanks

 

[jmcilhinney]

If you've added the MDF file to your project then you can simply publish the project and the ClickOnce installer created will deploy your app, the database and SQL Server Express. Just make sure that SQL Server Express is checked in the Prerequisites dialogue.

 

[mihirpatel83]

Thanks 4 reply, bt Can you please elaborate or help with any links where i can get to know how to select prerequisites nd create setup...

I tried as u said..selected prerequisite and then published which created a setup file bt wen i executed it..It threw database connectivity error....

Plz help me..its gettin on my nerves cause i almost spent 2nd day just learning how to deploy an application bt yet unsuccessful...