How to deploy a SQL Server Database with a VB.NET Project
I have a setup project in VB.NET under Visual Studio that I cannot get working. I have read many web pages on this subject and read the documentation articles I can find online but cannot get the answers to the specific questions below.
Please can an expert help me achieve the following specific tasks.
1) Create a deployment project that uses an Icon I provide on the users desktop and in the programs menu for launching the app. (Program files/application name)
2) In addition to installing pre-requisites (.NET 3.5 and SQL Server Express 2008 ) it installs the database that is the back end for the app and also inserts all of the data (There is alot of lookup data that has to ship with the database
3) adds a default login and password under SQL authentication.
That is it.
I would be grateful for help with these tasks. I can create a deployment project OK but cannot customise iot to do the above tasks.