我使用哪些SQL脚本? [英] Which SQL Scripts do I use?
问题描述
我有VS2010的RC版本.当我查看工作流程的SQL脚本时，会看到:
I have the RC build of VS2010. When I look at my SQL Scripts for workflow, I see:
DropSqlPersistenceProviderLogic.sql
DropSqlPersistenceProviderLogic.sql
DropSqlPersistenceProviderSchema.sql
DropSqlPersistenceProviderSchema.sql
DropSqlWorkflowInstanceStoreLogic.sql
DropSqlWorkflowInstanceStoreLogic.sql
DropSqlWorkflowInstanceStoreSchema.sql
DropSqlWorkflowInstanceStoreSchema.sql
SqlPersistenceProviderLogic.sql
SqlPersistenceProviderLogic.sql
SqlPersistenceProviderSchema.sql
SqlPersistenceProviderSchema.sql
SqlPersistenceService_Logic.sql
SqlPersistenceService_Logic.sql
SqlPersistenceService_Schema.sql
SqlPersistenceService_Schema.sql
SqlWorkflowInstanceStoreLogic.sql
SqlWorkflowInstanceStoreLogic.sql
SqlWorkflowInstanceStoreSchema.sql
SqlWorkflowInstanceStoreSchema.sql
Tracking_Logic.sql
Tracking_Logic.sql
Tracking_Schema.sql
Tracking_Schema.sql
这是我的问题:
1.如果我只有WF4工作流程，我将使用哪些架构?
1. Which schemas would I use if I just have WF4 workflows?
2.如果我的工作流有延迟活动，而不是像书签这样的活动，是否有不同的架构/脚本.
2. Are there different schemas/scripts if my workflows have delay activities vs. something like bookmarks.
3.如果问题2的模式不同，我是否应该继续进行设置，以便在创建工作流程并添加延迟活动的情况下做好准备?
3. If there are different schemas for question 2, shouldn't I just go ahead and set them both up so I'll be ready in case I create a workflow and add a delay activity?
4.如果我仍然打算创建3.5个工作流，是否必须运行3.0脚本以及此处列出的脚本?
4. If I still intend on creating 3.5 workflows, do I have to run the 3.0 scripts plus any listed here?
我正在尝试从不需要的脚本中清除此脚本列表.
I am trying to just clean out this list of scripts from ones that don't need to be there.
谢谢！
推荐答案
使用SqlWorkflowInstanceStoreLogic.sql和SqlWorkflowInstanceStoreSchema.sql创建新的.NET 4工作流程的持久性存储.第一个脚本将所有必需的表和视图添加到现有数据库，而后者将所有必需的存储过程添加到数据库.首先安装架构文件，然后安装逻辑文件. .NET 4实例存储可应对延迟活动和书签.
Use SqlWorkflowInstanceStoreLogic.sql and SqlWorkflowInstanceStoreSchema.sql to create a new persistence store for .NET 4 workflows. The fist script adds all required tables and views to an exisiting database, whereas the latter adds all required stored procedure. Install the schema file first, then the logic file. The .NET 4 instance store copes with delay activities and bookmarks.
使用DropSqlWorkflowInstanceStoreLogic.sql和DropSqlWorkflowInstanceStoreSchema.sql删除由SqlWorkflowInstanceStoreLogic.sql和SqlWorkflowInstanceStoreSchema.sql添加的工件.
Use DropSqlWorkflowInstanceStoreLogic.sql and DropSqlWorkflowInstanceStoreSchema.sql to remove the artifacts that were added by SqlWorkflowInstanceStoreLogic.sql and SqlWorkflowInstanceStoreSchema.sql.
SqlPersistenceProvider文件是用于创建/删除SqlPersistenceProvider的等效文件，该SqlPersistenceProvider用于持久化.NET 3.5实例.这些脚本与.NET 3.5中附带的脚本相同.
The SqlPersistenceProvider files are the equvalent files to create/delete a SqlPersistenceProvider, which is used to persist .NET 3.5 instances.These scripts are identical to the scripts that shipped in .NET 3.5.
希望有帮助，
Ruppert
这篇关于我使用哪些SQL脚本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
