Database Scripts

Topics: Web Client Software Factory
Mar 1, 2007 at 5:43 PM
Can someone help me out, I am sure this is an easy question. I want to use the WCSF with the pageflow. What scripts and in what order do I need to run to setup a new database. I know I can run the SetUpDatabase command for the examples, but I want just the stuff I need to make it work, not any of the other stuff. Thanks,
Mar 2, 2007 at 1:27 PM
Edited Mar 2, 2007 at 1:38 PM
Hi, you need to execute the following scripts:

At %windir%\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\EN you will find:

  • SqlPersistenceService_Schema.sql
  • SqlPersistenceService_Logic.sql
The scripts set up the Windows Workflow Foundation persistence layer

At %programfiles%\Microsoft Web Client Factory\Source Code\Blocks\PageFlow\Scripts you will find:

  • PageFlowInstanceStore.sql
This script creates a database that maps users to page flow instances. This database is used by the PageFlowInstanceCorrelationSqlProvider component.

Let me know if this helps,

Ezequiel Jadib
http://staff.southworks.net/blogs/ejadib