title: SQL Server built-in Change Tracking vs Sync Framework's C#/VB libraries
body: <p>I went into a problem where using the following code did not change the scope_id value in the replica key map and scope_info table of Sync Framework 2.1 elements in my database, on a restored database on Windows XP 32-bit / SQL Server Express 2008 (x86). It DOES work on my other client that is Windows 7 64-bit / SQL Server Express 2008 (x86) :</p>
  
  <p>SqlSyncStoreRestore databaseRestore = new SqlSyncStoreRestore(clientConn);
                              databaseRestore.PerformPostRestoreFixup();</p>
  
  <p>SUB QUESTION 1:
  It does not work but does not throw any exception either, which makes it much harder to troubleshoot. It is executed from a small console application (target x86) I built on my x64 computer (using Visual Studio x86). I wonder if the 32/64 bit thing is the culprit. Any clue?? But then, this made me wonder:</p>
  
  <p>SUB QUESTION 2:
  "Is there an SQL query equivalent to using PerformPostRestoreFixup() of Sync Framework's C#?"</p>
  
  <p>I am fairly new to Sync Framework and I do not yet entirely see the whole picture of synchronization of Microsoft SQL Server databases. It came to my attention that the SyncOrchestrator/SqlSyncProvider combo does not use built-in SQL Change Tracking stuff. Incredibly surprising to me! It now made me haunted by an even more tormenting question:</p>
  
  <p>SUB QUESTION 3:
   Is the built-in SQL Server Change Tracking and Sync Framework two totally independent platform on which to build our synchronization scheme? I hope I am using the right words in English. In other words, is each of them completely unaware of the other??</p>
  
  <p>Thanks in advance for your help! I am soooo lost LOL!</p>
  
  <p>Kind Regards,</p>
  
  <p>Zyxy</p>