Activity Information Deploy Database to Staging Server
DescriptionOptionally you may wish to test the deployment on a staging server prior to deploying to the production server. Here you follow the same steps as if you were doing the actual deployment – execute the deploy script and verify the results. Attributes| Element Categories | [CMMI Level 3] VER SP 3.1, [CMMI Level 3] VER SP 3.2, [CMMI Track 5] Deploy | | Entry Criteria | Build Script Created:
The build script is generated and modified appropriately.
Target Database Backed Up:
The target database for the database project deployment is backed up. | | Exit Criteria | Database Deployed to Staging Server:
The database is deployed to a staging server. | | Is Required | No |
StepsExecute Build Script Against Staging Server (Optional):
Execute the build script against the staging server in the T-SQL editor to ensure that the deployment will succeed on this server prior to deployment to the target server.
Analyze any failures that occur. Use Schema Compare to Verify Deployment (Optional):
Create schema comparison sessions to view the differences between the project and the staging server.
Ensure no unknown differences exist between the two databases. Known differences include objects that are defined in pre-deployment or post-deployment scripts, because these objects will not appear as part of the schema comparison. Rules and defaults are examples of such objects.
|
Last modified at 12/19/2007 10:37 AM by Administrator
|
|