These revisions extensions exercises will guide you through the process of creating a revisions file to be run by the deployment utility. The revisions you create in these exercises create a fact table that mirrors the FACT_INTERACTIONRESPONSE table in a Blackbaud Data Warehouse database.
Revisions Spec Exercise: Create New Spec
Revisions Spec Exercise Steps: Create New Spec
Revisions Spec Exercise: Create Table
Revisions Spec Exercise Steps: Create Table
Revisions Spec Exercise: Drop and Create Indices Stored Procedure
Revisions Spec Exercise Steps: Drop and Create Indices Stored Procedure
Revisions Spec Exercise: Map Source to Target
Revisions Spec Exercise Steps: Map Source to Target
Revisions Spec Exercise: Create Staging Table
Revisions Spec Exercise Steps: Create Staging Table
Revisions Spec Exercise: Drop and Create Indices Stored Procedure - Staging Table
Revisions Spec Exercise: Map Source to Target - Staging Table
Revisions Spec Exercise: Truncate Tables and Drop Indices
Revisions Spec Exercise Steps: Truncate Tables and Drop Indices
Revisions Spec Exercise: Create Table View
Revisions Spec Exercise: Create Table View Steps
Revisions Spec Exercise: Create Project and Compile DLL
Revisions Spec Exercise Steps: Create Project and Compile DLL
Other Groups of Exercises