Activity Information Modify Generated Scripts
DescriptionThe database project is scoped at the database level and therefore does not support required server-level objects directly. In addition, some other schema object types are not directly supported in the project. However, these objects can easily be added to the pre and post deployment scripts. Therefore it is important at project creation to appropriately modify these scripts to include the required objects. There may be other SQL statements that you want to add before and after the deployment. These should be added here as well. Attributes| Element Categories | [CMMI Track 2] Planning, [CMMI Level 3] PI SP 1.3 | | Entry Criteria | Build and Deploy Settings Configured:
The default build and deploy settings are configured. | | Exit Criteria | Generated Scripts Modified:
The generated scripts are modified. | | Is Required | Yes |
StepsModify Pre-deployment Script:
Add Server Logins to the pre-deployment script so that users can be appropriately mapped to logins.
Add Keys & Certificates to the pre-deployment script.
Add Linked Servers to the pre-deployment script.
Add Custom Errors to the pre-deployment script. Modify Post-deployment Script:
Add Permissions to the post-deployment script so that schema objects have the appropriate grant, deny, and revoke permissions after creation.
Add Signatures to the post-deployment script.
Add stock data that you want to associate with your database project as a post-deployment script by adding insert statements for this data.
|
Last modified at 12/19/2007 10:37 AM by Administrator
|
|