How to deploy vb.net application with database(sqlserver)

Question

How to deploy vb.net application with database(sqlserver)

I developed a project on vb.net and used sqlserver as database(has 1 table only). Now i want to make a setup of it so that i could just send the setUp via cd or email and the receiver could easily install the software in his system.

I have never deployed or created a setup. Please help

Answer 1

Embedding SQL Server Express into Custom Applications
http://msdn.microsoft.com/en-us/library/bb264562%28SQL.90%29.aspx

Using a Custom Action to Create a Database at Installation
http://msdn.microsoft.com/en-us/library/49b92ztk%28VS.80%29.aspx

Answer 2

Inside of the Visual Basic editor you can click Project--> Properties. Click the tab for Publish, then click the button for Prerequisits and check SQL Server as a prerequisite. Then, when you publish, your setup will automatically prompt the user for and assist them with downloading and installing SQL server onto their machine.