title: Synchronization MSSQL databases with selected data in .NET
body: <p>We have database SQL server 2008 (db A). For better performance we will use next SQL server 2008 databases with the one workgroup (db B, C, ...). These databases will contain only necessary records and will can save some special records. These all databases are always full SQL server, not express.</p>
  
  <p>So we need to synchronize data from db A to db B, C. And then we need synchronize some data (with special sql query - for example only completed orders, not all) from db B to db A, from db C to db A, etc.</p>
  
  <p>The synchronization should be console application.</p>
  
  <p>I found some examples used MS Sync Framwork:</p>
  
  <ul>
  <li>SyncOrchestrator but I don't know how to select only some tables and some records.</li>
  <li>SyncTable but here I don't know how correct set RemoteProvider and LocalProvider to database SQL server 2008.</li>
  </ul>
  
  <p>Is there any way how to solve it? Or how can I correct use sync?</p>
  
  <p>Sorry for my english, it's not my native language.</p>
  
  <p>Many thanks.</p>