Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

Chapter 16. Publishing Your Database - Pg. 123

123 Chapter 16. Publishing Your Database Copying a SQL Server Database, 174 Understanding and Connecting to SQL Server, 175 When your Web site uses a database and you copy the site to another Web server, it's quite common to copy the database as well. In some cases, the two Web servers and the two database servers are so similar that the same database settings and the same file locations work in both sites without modification. If you find yourself in this situation, you probably won't need this chapter. In a more common scenario, your development database server and your production database server will require different connection settings or different file locations, and you'll need to fix these settings on the production site. To do this, you'll need to know a little about Microsoft ® SQL ServerTM, connection settings, and connections strings (which store those settings). This chapter will explain the basics. Copying a SQL Server Database