Database Synchronization with the Microsoft Sync Framework: Listing 1.

Calling the custom synchronization library from Visual Basic.

Public Sub Sample_SQLStandard_SQLExpress_Sync()
  Dim dbSS8_SX8_TT_SyncInfo As New DatabaseSyncInfo
  Dim dbSS8_SX8_TT_Helper As SynchronizationHelper

  dbSS8_SX8_TT_SyncInfo.LocalConnectionString = 
    My.Settings.SQLServerTrackingTablesConnectionString
  dbSS8_SX8_TT_SyncInfo.LocalDriverType = eSyncDriverType.SQLServer
  dbSS8_SX8_TT_SyncInfo.RemoteConnectionString = 
    My.Settings.SQLExpressTrackingTablesConnectionString
  dbSS8_SX8_TT_SyncInfo.RemoteDriverType = eSyncDriverType.SQLServer
  dbSS8_SX8_TT_SyncInfo.ScopeName = My.Settings.ScopeName
  dbSS8_SX8_TT_SyncInfo.FillSyncTables(My.Settings.SyncTables)
  dbSS8_SX8_TT_Helper = New SynchronizationHelper(dbSS8_SX8_TT_SyncInfo)
  Dim SyncStats As Microsoft.Synchronization.SyncOperationStatistics = 
    dbSS8_SX8_TT_Helper.DoSync(Nothing)
  'Display SyncStats to user if desired
  'The DoSync() parameter is an optional ListBox to show in-progress 
    status information if desired
  End Sub

About the Author

Joe Kunk is a Microsoft MVP in Visual Basic, three-time president of the Greater Lansing User Group for .NET, and developer for Dart Container Corporation of Mason, Michigan. He's been developing software for over 30 years and has worked in the education, government, financial and manufacturing industries. Kunk's co-authored the book "Professional DevExpress ASP.NET Controls" (Wrox Programmer to Programmer, 2009). He can be reached via email at [email protected].

comments powered by Disqus

Featured

  • VS Code Now Has Apple Silicon Builds for Native Mac Development

    Goodbye Rosetta, hello M1. Visual Studio Code has been updated with new builds that let it run natively on machines with Apple Silicon (M1), the company's own ARM64 chips.

  • Visual Studio 2019 for Mac v8.9 Ships with .NET 6 Preview 1 Support

    During its Ignite 2021 online event for IT pros and developers this week, Microsoft shipped Visual Studio 2019 for Mac v8.9, arriving with out-of-the-box support for .NET 6 Preview 1, which the company also released recently.

  • Analyst: TypeScript Now Firmly in Top 10 Echelon (Ruby, Not So Much)

    RedMonk analyst Stephen O'Grady believes TypeScript has achieved the rare feat of firmly ensconcing itself into the top 10 echelon of his ranking, now questioning how high it might go.

  • Black White Wave IMage

    Neural Regression Using PyTorch: Training

    The goal of a regression problem is to predict a single numeric value, for example, predicting the annual revenue of a new restaurant based on variables such as menu prices, number of tables, location and so on.

Upcoming Events