none
"Phantom" inserts while synchronizing with Sync Framework 2.1 RRS feed

  • Question

  • I am synchronizing two SQL Server databases using MS Sync Framework 2.1.

    One database is in my Windows 8.1 Pro 64 bits desktop - SQL 2012 Standard.

    The other is in a Windows 10 Enterprise 64 bits Virtual Machine (Hyper-V) - SQL 2014 Express, running in my desktop.

    The Windows 10 database is a copy of the Windows 8.1 database (created from a backup of the original database).

    I am using the following Provisioning Code

    For the local database
            Dim myScopeDescription As New DbSyncScopeDescription
    Dim tableDesc As New DbSyncTableDescription

            tableDesc = SqlSyncDescriptionBuilder.GetDescriptionForTable("APNSTable", sqlConC1)
    myScopeDescription.Tables.Add(tableDesc)

    Dim serverProvision As New SqlSyncScopeProvisioning(sqlConC1, myScopeDescription)
            serverProvision.SetCreateTableDefault(DbSyncCreationOption.skip)
            serverProvision.Apply()

    For the remote database
    Dim myScopeDescription As New DbSyncScopeDescription
            myScopeDescription = SqlSyncDescriptionBuilder.GetDescriptionForScope("APNScope", sqlConC1)

    Dim serverProvision As New SqlSyncScopeProvisioning(sqlConC2, myScopeDescription)
            serverProvision.SetCreateTableDefault(DbSyncCreationOption.CreateOrUseExisting)
            serverProvision.Apply()

    And my Synchronizing Code is

    Dim mySyncOrch As New SyncOrchestrator
    Dim sspLocalP, sspRemoteP As SqlSyncProvider

    sspLocalP = New SqlSyncProvider
            sspLocalP.ScopeName = "APNScope"
            sspLocalP.Connection = sqlConC1

    sspRemoteP = New SqlSyncProvider
            sspRemoteP.ScopeName = "APNScope"
            sspRemoteP.Connection = sqlConC2

            mySyncOrch.Direction = SyncDirectionOrder.UploadAndDownload

            Dim syncStats As SyncOperationStatistics = mySyncOrch.Synchronize

            Console.WriteLine()
            Console.WriteLine("Start Time: " + syncStats.SyncStartTime.ToString)
            Console.WriteLine("Total Changes Uploaded: " + syncStats.UploadChangesTotal.ToString)
            Console.WriteLine("Total Changes Downloaded: " + syncStats.DownloadChangesTotal.ToString)
            Console.WriteLine("Complete Time: " + syncStats.SyncEndTime.ToString)
            Console.WriteLine("Press Enter to finish...")
            Dim input As String = Console.ReadLine

    APNScope includes one only table with 3753 rows.

    If I add /delete rows in any of the databases and synchronize, the changes are propagated just fine to the other database.

    My question has to do with the sync results when there has been no changes in the tables.

    I would think that, since there is no change, there would be no inserts, updates or deletes while synchronizing.

    Nevertheless, I get 3753 "inserts" uploaded from the Windows 8.1 database to the Windows 10 database

    The synchronizing statistics:

    Start Time: 11/23/2015 9:28:28 AM
    Total Changes Uploaded 3753
    Total Changes Downloaded 0
    Complete Time: 11/23/2015 9:29:07 AM

    If I check the base and tracking tables, they both have 3753 rows.

    Where are this "inserts" going? Is this normal? Am I doing something wrong?

    Thanks,

    Monday, November 23, 2015 4:22 PM