User-166373564 posted
Hi,
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 learn more about ASP.NET Web Application Project Deployment with SQL Server database from link below,
#ASP.NET Web Application Project Deployment
http://msdn.microsoft.com/en-us/library/dd394698%28v=VS.100%29.aspx
Regards