Seems you're using non-standard objects. I'd suggest to ask a question on proper GitHub:
GitHub - Mimetis/Dotmim.Sync: A brand new database synchronization, multi platform, multi databases, developed on top of .Net Standard 2.0.[
^]
For Microsoft specific database synchronization, please see:
Database Synchronization with the Microsoft Sync Framework -- Visual Studio Magazine[
^]. Note, that the
Microsoft Sync Framework Developer Center | Microsoft Docs[
^] is obsolete.
Because a database synchronization is the process of establishing data consistency between two or more databases (even if there's a one-way synchronization - from local to online database), you can choose few ways to implement it - via:
1.
linked server[
^] + stored procedures
Use a set of stored procedures which may help you to keep online data up to date. Create SP for every single CRUD operation. Inside of every sp add code to modify local and web database.
2. Linked server + Sql
scheduled job(s)[
^]
Use a job, which may be fired-up every half an hour, a day, etc.
3.
SqlDependency class[
^]
Use SQLDependency objects to inform final users about data changes.
4.
SqlBulkCopy class[
^]
Use SQLBulkCopy class for bulk load/copy data from off-line to on-line database.
Good luck!