Task 3: Create the Tracking and Persistence Database

  • Article

This tutorial will use a SQL database for workflow tracking and persistence. Follow these steps to set up the database.

To create the tracking and persistence database

  1. Create a new database on your local SQL server called SqlPersistence.
    Note   When using both the SqlTrackingService and the SqlWorkflowPersistenceService in a workflow application, it is recommended that you use a single database for both persistence and tracking.

  2. Run the following Schema scripts on the new database:

    1. %windir%\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\SQL\EN\SqlPersistenceService_Schema.sql

    2. %windir%\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\SQL\EN\Tracking_Schema.sql

  3. Run the following Logic scripts on the new database:

    1. %windir%\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\SQL\EN\SqlPersistenceService_Logic.sql

    2. %windir%\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\SQL\EN\Tracking_Logic.sql

Copyright © 2007 by Microsoft Corporation. All rights reserved.
Last Published: 2010-03-04