Initial Sync, populate data RRS feed

  • Question

  • Hello. I have two different SQL Server 2005 synchronizing with SqlSyncProvider without problem. 

    But now, I have to synchronize a table with 30.000.000 rows, now its replication with manually scripts with timestams and I want to include in the Scope. The problem its the first sync, its a critical service so I cant stop it until sync finishes, and I hace tried to populate metada creating scope in both servers (on another environment) and all rows crash with LocalInsertRemoteInsert conflict.

    How can I populate the initial metada on both peers witout first Sync?, What knowledge have I to give to the scope?.

    Thank you.
    Tuesday, January 26, 2010 7:40 PM


  • There is a recommended way to do initialization when the source table has a large amount of data.
    1. Do provisioning on source database.
    2. Backup the source database using TSQL.
    3. Restore the back on the target server.
    4. Create a SqlSyncStoreRestore object and invoke PerformPostRestoreFixup().

    This should help.

    Leo Zhou ------ This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, January 26, 2010 10:08 PM