Database and deployment

Question

User-2020366656 posted

Hi,

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?

 

thanks

Answer 1

User-1716253493 posted

http://msdn.microsoft.com/en-us/library/bb907585(v=vs.100).aspx

Answer 2

User-1635195291 posted

Hi acheo,

Please go through the following threads that shows various ways to achieve this,

http://www.asp.net/web-forms/tutorials/deployment/deploying-web-site-projects/deploying-a-database-cs

http://www.windowshostingasp.net/windows_hosting_forums/showthread.php?t=22

http://forums.asp.net/t/1903127.aspx/1

http://msdn.microsoft.com/en-us/library/dd465343(v=vs.100).aspx

Hope this helps.

Thanks,

Jatin

Answer 3

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 refer the illustration to learn the procedures below,

# Deploying a SQL Server Database - http://msdn.microsoft.com/en-us/library/dd394698(v=vs.100).aspx 

Regards