How to persist workflow in different Schema RRS feed

  • Question

  • Hi,

    the database scripts which are shipped with workflow foundation (%WINDIR%\Microsoft.NET\Framework\v4.0.30319\SQL\en) create a new Schema  [System.Activities.DurableInstancing] in the persistence database.

    How can I use another Schema (like [msh])? I ask the question, because we want to persist the workflows of sevaral development systems in the same database, but in different schemas.

    I already tried search/replace in the scripts SqlWorkflowInstanceStoreSchema.sql and SqlWorkflowInstanceStoreLogic.sql, but that did not do the job. Persistence now crashes with the error Message: "Exception Details: System.Data.SqlClient.SqlException:Invalid objectName 'LockOwnersTable'."

    Please help me.

    Thursday, July 28, 2011 9:39 AM


All replies