WF4 Persistence in SQL Azure

The .NET Framework Platform Update 1 release (KB2495593) contains new versions of the SQL Scripts for creating a database that can be used with the SqlWorkflowInstanceStore in WF4. The nice thing about these new versions, is that they are compatible with SQL Azure! This enables us to host long-running workflows (declarative workflowservices) in a Windows Azure web-role while using SQL Azure as persistence store, without having to write our own instance-store implementation.

During the installation of the update, the original versions of the SQL Scripts (SqlWorkflowInstanceStoreSchema.sql and SqlWorkflowInstanceStoreLogic.sql) are overwritten. You can find them in the following folder: %windir%Microsoft.NETFrameworkv4.0.30319SQLen.