Multiple version of the web application running on different servers [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly开发者_如何学运维 broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 10 years ago.

How do I separate the web application (built in ASP.NET) and database (built in SQL Server 2005), so that we could have multiple version of the web application running on different servers?

---

Database: your best two options here are to:

• generate SQL scripts. This will allow you to run a bunch of CREATE statements against as many SQL Server instances as you need. Use the SQL Server Generate Scripts command

• create a backup of your current database. This will give you a .BAK file. For each SQL Server instance you need, here are two article to restore from backup: Create a New Database From an Existing Backup from MSDN and Restore a SQL Server database to a New Server from TechRepublic onto.

Web app: copy the application or deploy with Visual Studio to your targets. The target could be another directory on the server, or another machine entirely. Ensure your connection string points to the correct instance.