Last post Jun 26, 2013 03:31 AM by Angie xu - MSFT
Jun 22, 2013 09:34 PM|acheo|LINK
I have built a WebSite on my laptop which takes his data from a local a SLQ database. I did not insert the database in the solution through "Add New Item" but rather created an Sql connection. Now for the deployment phase, woudl I be better off to add this
database to my solution? I have never done this and I'm not sure what is better?
Jun 22, 2013 10:15 PM|oned_gk|LINK
Jun 23, 2013 05:06 PM|jats_ptl|LINK
Please go through the following threads that shows various ways to achieve this,
Hope this helps.
Jun 26, 2013 03:31 AM|Angie xu - MSFT|LINK
When you deploy a Web application that uses a SQL Server database, you might also have to propagate data structures, data, or both. Visual Studio can automatically create scripts (.sql files) to do this in the destination database, and these scripts can
be included in the Web package. You can also include custom SQL Server scripts and specify the order in which the scripts should run. Web Deploy runs the scripts on the destination server when the package is installed.
You specify SQL Server deployment options on the Package/Publish SQL tab of the project Properties page. You can refer the illustration to learn the procedures below,
# Deploying a SQL Server Database -