As it is very rare that I need to interact with the SqlPersistenceService (and TrackingService), I always seem to forget where on disk these artifacts are. To aid that situation – I’ve compiled the following list:
Persistence:
Step 1: Create a new database on your server
Step 2: Open and run (Sql Query Tool) this script against your newly created database (%WINDIR%\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\<language>\SqlPersistence_Schema)
Step 3: Open and run (Sql Query Tool) this script against your newlu created database (%WINDIR%\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation\SQL\<language>\SqlPersistence_Logic)
That’s what there is to it.