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
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.Run the following Schema scripts on the new database:
%windir%\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\SQL\EN\SqlPersistenceService_Schema.sql
%windir%\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\SQL\EN\Tracking_Schema.sql
Run the following Logic scripts on the new database:
%windir%\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\SQL\EN\SqlPersistenceService_Logic.sql
%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