{"id":350,"date":"2009-06-11T09:57:30","date_gmt":"2009-06-11T16:57:30","guid":{"rendered":"http:\/\/kennyw.com\/workflow\/350"},"modified":"2009-06-11T09:57:30","modified_gmt":"2009-06-11T16:57:30","slug":"setting-up-sql-persistence-for-wf4-beta-1","status":"publish","type":"post","link":"https:\/\/kennyw.com\/?p=350","title":{"rendered":"Setting up SQL Persistence for WF4 Beta 1"},"content":{"rendered":"<p>A few customers have hit a speed bump when trying to setup persistence with WF4 Beta1. We have multiple sql scripts included (for 3.5 persistence and 4.0 persistence). The problem is that depending on your WF application model in Beta1 you have to execute different scripts (we\u2019ve fixed this in Beta2).<\/p>\n<p>For WorkflowServiceHost usage, use these SQL scripts:<\/p>\n<ul>\n<li>C:WindowsMicrosoft.NETFrameworkv4.0.20408SQLenSqlPersistenceProviderSchema40.sql<\/li>\n<li>C:WindowsMicrosoft.NETFrameworkv4.0.20408SQLenSqlPersistenceProviderLogic40.sql<\/li>\n<\/ul>\n<p>For WorkflowInstance usage, use these SQL scripts (note the lack of \u201c40\u201d):<\/p>\n<ul>\n<li>C:WindowsMicrosoft.NETFrameworkv4.0.20408SQLenSqlPersistenceProviderSchema.sql<\/li>\n<li>C:WindowsMicrosoft.NETFrameworkv4.0.20408SQLenSqlPersistenceProviderLogic.sql<\/li>\n<\/ul>\n<p>Also make sure that the connection string in your application matches the database you created. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>A few customers have hit a speed bump when trying to setup persistence with WF4 Beta1. We have multiple sql scripts included (for 3.5 persistence and 4.0 persistence). The problem is that depending on your WF application model in Beta1 you have to execute different scripts (we\u2019ve fixed this in Beta2). For WorkflowServiceHost usage, use [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-350","post","type-post","status-publish","format-standard","hentry","category-workflow"],"_links":{"self":[{"href":"https:\/\/kennyw.com\/index.php?rest_route=\/wp\/v2\/posts\/350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kennyw.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kennyw.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kennyw.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kennyw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=350"}],"version-history":[{"count":0,"href":"https:\/\/kennyw.com\/index.php?rest_route=\/wp\/v2\/posts\/350\/revisions"}],"wp:attachment":[{"href":"https:\/\/kennyw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kennyw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kennyw.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}