Remove From My Forums

Adding a table or a column to Existing Scope or ScopeProvision

Question
0

Sign in to vote

I am using Microsoft Sync 2.1 for synchronizing Sql Server and SQL CE DB.

Everything is working fine and now i wanted to add a table to the Existing Scope i.e {Scope1 has "Agents", "Products", "Region" tables etc}.

Now i wanted to add one more table "country" to Scope1.

1) Is there any way that i can add this "country" to the Scope1 with out Deprovisioning the Sql and Sqlce?

2) how to add a column to already Synchronized table.

Thanks in Advance

lavanyar

Monday, November 29, 2010 11:20 PM

Answers

0

Sign in to vote
Hi Paola,

Sync Framework does not support schema synchronization today. Are you using SyncFx 4.0 or an earlier version of the framework?

You can have a look at the threads below to get an idea of previous discussions on this topic.

http://social.microsoft.com/forums/en-us/syncdevdiscussions/thread/86F834C4-E482-4FE6-9FD3-5F49441879F7

http://social.msdn.microsoft.com/Forums/en-US/synclab/thread/2e1f0e3a-58a7-4368-b08e-5b67d9c86b75

http://social.microsoft.com/Forums/en-US/syncdevdiscussions/thread/9c5e2818-20bf-459c-947e-bcb1ee4fa7c1

http://social.microsoft.com/forums/en-us/syncdevdiscussions/thread/210CE4D2-0D0A-47CA-A16E-FB0B96F440C0
SDE, Sync Framework - http://www.giyer.com
- Marked as answer by Ganeshan Friday, January 28, 2011 3:10 AM
Wednesday, January 12, 2011 5:53 PM

All replies

0

Sign in to vote

When run provision cmd, it's will create some table, store procedure, trigger,... base on your config file.

So if you want to change structure (add more table, add column, delete column, rename column,....) you have to deprovision before provision with new structure.

I think this is only way to make change effect.

Tuesday, November 30, 2010 3:01 AM
0

Sign in to vote

thanks for the reply, deprovision and Provision on Server (SQL) Side is fine. But to keep track of each client (SQLCe) is going to be a big problem.

Is there any best way to deal with this kind of scenario?

Thanks Again

lavanyar

Tuesday, November 30, 2010 4:03 PM
0

Sign in to vote

Is there any better way to deal with this scenario?

Thanks
lavanyar

Monday, December 6, 2010 3:25 PM
0

Sign in to vote

Hi,

I´m having the same problem that lavanyar is describing above. Is there a way to solve this scenario without having to update each client database manually? Moreover, Does Microsoft Sync Framework 4.0 supports synchronization of database structure in order to solve this problem?

Thanks in advance

Paola

Wednesday, January 12, 2011 2:26 PM
0

Sign in to vote
Hi Paola,

Sync Framework does not support schema synchronization today. Are you using SyncFx 4.0 or an earlier version of the framework?

You can have a look at the threads below to get an idea of previous discussions on this topic.

http://social.microsoft.com/forums/en-us/syncdevdiscussions/thread/86F834C4-E482-4FE6-9FD3-5F49441879F7

http://social.msdn.microsoft.com/Forums/en-US/synclab/thread/2e1f0e3a-58a7-4368-b08e-5b67d9c86b75

http://social.microsoft.com/Forums/en-US/syncdevdiscussions/thread/9c5e2818-20bf-459c-947e-bcb1ee4fa7c1

http://social.microsoft.com/forums/en-us/syncdevdiscussions/thread/210CE4D2-0D0A-47CA-A16E-FB0B96F440C0
SDE, Sync Framework - http://www.giyer.com
- Marked as answer by Ganeshan Friday, January 28, 2011 3:10 AM
Wednesday, January 12, 2011 5:53 PM

Answered by:

Adding a table or a column to Existing Scope or ScopeProvision

Question

Answers

All replies