Revisions Project Template

With the release of Blackbaud CRM version 2.93, the SDK includes a Revisions project template.

When you create an extensions solution from the SDK, the solution includes a Revisions project. This project includes a template revisions file, DBREV10001.XML:

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

  <DBRevision ID="5">
    <ExecuteSql>
      <![CDATA[	
if not exists(select 1 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>
  
</DBRevisions>

For more information about how to create a solution that contains a Revisions project, see Create a New Extensions Solution. For more information about revisions extensions in general, see BBDW Database Revisions Extensions.

You can edit this file for the first set of revisions extensions. After that, you can add further revisions specs with higher numbers than DBREV10001.XML. When you build the project, the build creates a DLL that you can use for revisions extensions during a Blackbaud Data Warehouse deployment. For information about DLLs for revisions extensions, see Compile Revisions to DLL.