Microsoft Sync Framework - 如何在架构更改后重新配置表(或整个范围)? [英] Microsoft Sync Framework - How to reprovision a table (or entire scope) after schema changes?

问题描述

我已经设置了与 Microsoft Sync Framework 的同步，现在我需要向表中添加字段.如何重新配置​​数据库?

I have already setup syncing with Microsoft Sync Framework, and now I need to add fields to a table. How do I re-provision the databases?

设置非常简单:

• 两台 SQL Express 2008 服务器
• 范围包括整个数据库
• 使用 Microsoft 同步框架 2.0
• 通过直接访问进行同步.使用标准的新 SqlSyncProvider

我是否对两端的结构进行了更改?还是我只更改一台服务器并让 Sync Framework 以某种方式传播更改?

Do I make the structural changes at both ends? Or do I only change one server and let Sync Framework somehow propagate the change?

我是否需要删除 _tracking 表和/或存储过程?触发器怎么样?

Do I need to delete the _tracking tables and/or the stored procedures? How about the triggers?

有人使用过同步框架吗?请帮忙.

Has anyone been using the Sync Framework? Please help.

推荐答案

实际上，我在我的博客上发布了自己的答案 http://myazurejourney.blogspot.com/

Actually, I posted my own answer on my blog http://myazurejourney.blogspot.com/

它有几个步骤，它绝对是一个黑客.但它有效.

It has a few step, and it's definitely a hack. But it works.

检查一下.告诉我你的想法

check it out. tell me what you think

这篇关于Microsoft Sync Framework - 如何在架构更改后重新配置表(或整个范围)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！