Thursday, July 05, 2007 1:11 PMWe are bringing together data from two sources into one table in our local SQLCE database.
Source A: Table1: PK1, Col1,Col2,Col3
Source B: Table2: PK1, Col4,Col5
Are mapped to
SQLce: MergeTable: PK1, Col1,Col2,Col3,Col4,Col5
Source A is the "Master" i.e. there will not be a row in Source B for which there is not a corresponding row in Source A (but there may be a row in Source A for which there is no row in Source B, and hence Col4 and Col5 must take default values)
I really want to be sure that MSSync will allow me to set up two Sync Agents to different destination data sources, but mapping to same local SQLce table (but to different columns in this table).
- Moved by Max Wang_Chinasoft Friday, April 22, 2011 10:30 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Monday, July 09, 2007 4:36 PM
Sync Services does not support multiple server scenario. The sync relationship in the first release of sync services will be restricted to 1 to 1. 1-n and n-n are possible but not in the scope of this release.
Monday, July 09, 2007 4:39 PMModerator
this is an interesting case but unfortunately this is not supported. the sync may run without exception, but since the tracking info was stored based on the table, you may get into situations where data is not convergent with the servers with this case.
Tuesday, July 10, 2007 10:14 AMHi
Thanks for the replies... there is still an element of confusion:
From your post, I can see that it is not supported to synchronise parts of a table with more than one data source, owing to tracking information being stored against the table.
From Rafik's post, things seem a little more draconian: It would appear that it is not supported to synchronise one SQLce database to more than one data source (even if the tables are entirely independent but just happen to be in the same database)
Synchronising to different datasources is important for us although we can probably do without having to merge multiple sources into one table (but a nice feature that would be!)
I really need to be clear on this one.
Tuesday, July 10, 2007 4:50 PM
Let me clarify; One table can synchronize with one data source. Another table in the same database can synchronize with a different data source.