Using Your Test Environment for Updates
Before updating the servers in your production environment, always deploy and test your updates in a separate staging/test environment. This will help ensure that you efficiently deploy a fully tested and updated site.
For example, suppose you want to update your product catalog. Before you modify the catalogs in your production environment, first update the ones in your staging environment. Test the updated catalogs there. Once you are satisfied that these updates are fully functional, use SQL Server to replicate the updates to your production servers.
See Also
Using SQL Server to Replicate Databases
Copyright © 2005 Microsoft Corporation.
All rights reserved.