CODEWITHSUNDEEP
sql-serversynchronizationsql-server-cemicrosoft-sync-framework
raghavendra
raghavendra

Reputation: 23

Update schema changes using Microsoft sync framework 2.1

Is this possible to update the server side and Ce(local) Schema using sync framework 2.1.

1) Currently Sync is working fine. If i update server schema(adding an extra column to table). How to reflect this in SqlCe(Local)?

2) Is this kind of scenario Supported in MSF 4.0?

Upvotes: 2

Views: 1794

Answers (2)

JuneT
JuneT

Reputation: 7860

there is nothing in Sync Fx 4.0 around updating scope configuration to reflect schema changes. (there is now Sync Fx 4 either. What used to be known as Sync Fx CTP 4 was released as Sync Framework Toolkit)

if you're up to it, you can hack the scope_config to alter the scope configuration, see:

Modifying Sync Framework Scope Definition – Part 1 – Introduction

Modifying Sync Framework Scope Definition – Part 2 – Workarounds

Modifying Sync Framework Scope Definition – Part 3 – Workarounds – Adding/Removing Columns

Modifying Sync Framework Scope Definition – Part 4 – Workarounds – Adding a Table to an existing scope

Upvotes: 3

james
james

Reputation: 1

Yes, you can do that. You just need to drop the scope, recreate it and perform the sync again. I am not sure if this is available in MSF 4.0

Upvotes: 0

Related Questions