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

  • Full Stack Hands-On Development with .NET

    In the fast-paced realm of modern software development, proficiency across a full stack of technologies is not just beneficial, it's essential. Microsoft has an entire stack of open source development components in its .NET platform (formerly known as .NET Core) that can be used to build an end-to-end set of applications.

  • .NET-Centric Uno Platform Debuts 'Single Project' for 9 Targets

    "We've reduced the complexity of project files and eliminated the need for explicit NuGet package references, separate project libraries, or 'shared' projects."

  • Creating Reactive Applications in .NET

    In modern applications, data is being retrieved in asynchronous, real-time streams, as traditional pull requests where the clients asks for data from the server are becoming a thing of the past.

  • AI for GitHub Collaboration? Maybe Not So Much

    No doubt GitHub Copilot has been a boon for developers, but AI might not be the best tool for collaboration, according to developers weighing in on a recent social media post from the GitHub team.

  • Visual Studio 2022 Getting VS Code 'Command Palette' Equivalent

    As any Visual Studio Code user knows, the editor's command palette is a powerful tool for getting things done quickly, without having to navigate through menus and dialogs. Now, we learn how an equivalent is coming for Microsoft's flagship Visual Studio IDE, invoked by the same familiar Ctrl+Shift+P keyboard shortcut.

Most   Popular

Subscribe on YouTube