Revisions Spec Exercise Steps: Create New Spec

1. Create a new revisions file. You can base it on a previous file.
2. Ensure the filename follows the Blackbaud Professional Services numbering scheme.

3. Add a header and a comments section.

   <?xml version="1.0" ?>
   <DBRevisions xmlns="bb_appfx_dbrevisions">
     <DBRevision ID="1">
       <Comment>Extended Database Schema</Comment>
     </DBRevision>

4. Use "1" to number the ID for the comment revision.
5. Don't forget to close the <DBRevisions xmlns="bb_appfx_dbrevisions"> node at the end of the document with </DBRevisions>.
6. According to best practices, add a section for ETL Reset. For more information, see the exampleRevisions Spec: Reset

7. You can copy and paste from examples. But in some cases, you will have to modify the contents.

     <DBRevision ID="5">
       <ExecuteSql>
         <![CDATA[	
   if not exists(select * from sysobjects so where so.type = 'P' and so.name = 'RESETETL_EXT')
   	exec sp_executesql N'create procedure BBDW.[RESETETL_EXT] as set nocount on;'
   	]]>
       </ExecuteSql>
     </DBRevision>

8. Use "5" to number the ID for the ETL Reset revision.
9. Save your revisions file in your Business Intelligence project.