修改新添加列的Scope Config [英] Modifying Scope Config for newly added column

问题描述

您好，

          我正在使用HUB n Spoke模型来同步数据。我已经配置了许多特定于相应站点的范围（特定于站点的过滤器）。现在其中一个表已被修改，并在其中添加了
一列。我想在范围配置中添加此列，以便新添加的列也同步。删除和重新配置范围不是选项，因为我在数据库中有大量数据需要数周才能同步（删除和重新配置
范围从头开始启动同步）。 我使用的是版本SyncFx2.1

           I am using HUB n Spoke model for syncronizing the data. I have configured many of the scopes specific to the respective site (site specific filters). Now one of the table has been Altered and added one column into it. I want to add this column in the scope config, so that the newly added column also syncronizes. Deleting and reconfiguring the scope is not the option as I have lot of data in the database which takes weeks to syncronize (Deleting and reconfiguring scope initiats the sync from the scratch). I am using the version SyncFx2.1

      我已经浏览了SyncFx创建的对象，如触发器，SP，_tracking表，并发现我可能需要修改它们。以下是我的发现：

       I have gone through the objects that SyncFx creates like triggers, SPs, _tracking tables and found that I may need to modify those. Here are my findings :

1	_插入Sp需要修改以适应新列	参数和插入查询列
2	_需要修改SelectChanges SP以适应新列	选择查询列
3	_ SelectRow SP需要为m odified以容纳新列	选择查询列
4	_更新SP需要修改为容纳新列	更新查询列
5	需要修改config_data xml以适应新专栏	具有新Col元素的相应Adapter元素

1	_Insert Sp needs to be modified to accommodate the new column	Parameters and Insert Query columns
2	_SelectChanges SP needs to be modified to accommodate the new column	The Select Query columns
3	_SelectRow SP needs to be modified to accommodate the new column	The Select Query columns
4	_Update SP needs to be modified to accommodate the new column	The Update Query columns
5	config_data xml needs to be modified to accommodate the new column	The respective Adapter Element with new Col element

            如果我在所有站点和HUB上手动执行上述修改， SyncFx会正常工作吗？有什么遗漏吗？

              If I do the above said modifications manually at all the sites and HUB, will the SyncFx work normally ? Is there anything missing ?

如果有人遇到同样的问题并找到了其他方法，我会恭喜您分享相同的内容。

If anyone encountered the same issue and found other way of doing this, I would appriciate if you share the same.

请记住，单个表格包含在近100个范围内，其中包含差异.sesechanges_ * SPs。

-Ajinath

推荐答案

有没有人对此有所了解？

Does anyone have idea about this?

  ;

-Ajinath

这篇关于修改新添加列的Scope Config的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！