I'm thinking of deploying Sync Framework to a solution I'm developing, but I've had some doubts about how Framework works, I hope you guys can help me, I'll be very grateful.
The first question is:
I have a local database in .mdf and a database on an external server with SQL server Express. Where the local database works together with the program offline and SQL server works as a cloud to archive all data from my client.
Can Sync Framework do the work of synchronizing changes from the local database to the external database? That is, anything added or removed in the local database is also added or removed in the external database.
The second question is:
Does sync framework perform well? For example, in a case where more than 5,000 database modifications were made, would it take too long to sync?
Sincerely.