Task 3: Create the Tracking and Persistence Database

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