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

  • Build Your First AI Applications with Local AI

    "AI right now feels like a vast space which can be hard to jump into," says Craig Loewen, a senior product manager at Microsoft who is helping devs unsure about making that first daunting leap.

  • On Blazor Component Reusability - From Day 0

    "We want to try to design from Day One, even Day Zero, with reusability in mind," says Blazor expert Allen Conway in imparting his expertise to an audience of hundreds in an online tech event on Tuesday.

  • Decision Tree Regression from Scratch Using C#

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of decision tree regression using the C# language. Unlike most implementations, this one does not use recursion or pointers, which makes the code easy to understand and modify.

  • Visual Studio's AI Future: Copilot .NET Upgrades and More

    At this week's Microsoft Ignite conference, the Visual Studio team showed off a future AI-powered IDE that will leverage GitHub Copilot for legacy app .NET upgrades, along with several more cutting-edge features.

  • PowerShell Gets AI-ified in 'AI Shell' Preview

    Eschewing the term "Copilot," Microsoft introduced a new AI-powered tool for PowerShell called "AI Shell," available in preview.

Subscribe on YouTube