Windows Workflow Persistence 4.5 Database Table Description

Question

Where can I find the SQL Server Persistence Database table description for .NET 4.0 or 4.5? I can find the following:

Workflow Tracking Service Database

But this is specific to 3.5, and I know the structure has changed in .Net 4. I also found this document, but it only describes the views, not the tables created.

Persistence Database Schema

Answer 1

In working with Microsoft Support I received this answer below, which is definitely not ideal, as it only really describes the views. I will update if I get a better response from them.

It looks like the database schema details is internal only and not available to public. Only public documentation is here:

http://msdn.microsoft.com/en-us/library/ee943755(v=vs.110).aspx

Documentation on DB scripts is here:

http://blogs.msdn.com/b/carlos/archive/2013/01/10/workflow-foundation-sql-scripts.aspx

Answer 2

You'll find the files installed under

C:\Windows\Microsoft.NET\Framework\v4.0.30319\SQL\en

I believe the files needed for WF4 are

SqlWorkflowInstanceStoreSchema.sql

and

SqlWorkflowInstanceStoreLogic.sql

It isn't clear which are WF3 and which are WF4, but you can usually figure it out as WF4 table names are all [System.Activities.DurableInstancing].[SomethingHere]. So if you're not sure about a file, crack it open and look for that namespace-style name.