1
I’m thinking of implanting the Sync Framework in a solution that I am developing, but I have had some doubts about the functioning of the Framework, I hope you can help me, I’ll be very grateful.
The first question is:
I have a local database on . 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 job of synchronizing local database changes with the external database? That is, everything that is added or removed in the local database, is also added or removed in the external database.
The second question is:
The sync framework does it perform well? For example: in a case where more than 5,000 database modifications are made it would take a long time to synchronize?
Sincerely yours.
For your second question, your performance problem is likely to be the Database and not the framework. SQL Server Express was not meant to run in production.
– gmsantos
@gmsantos Sqlexpress works very well in production, it was made, precisely, for lower competition scenarios. Its limitations today are the 10GB maximum size and amount of Cpus available for the database engine. With small loads the bench runs very quickly. What is not used for production is ACCESS database, nor as local application database. You can use Sqlexpress locally (great option for Sync) or SQL Compact that offers virtually the same capabilities and is much easier to distribute with the application.
– Loudenvier
Felipe, I would modify the local database to use SQL Compact. You will now use SQL language compatible with SQL Server, without the idiosyncrasies of Access, and avoid the high risks of basing your application on an MDF database. You can even share a lot of code between client and server (if you have code on the server). SYNC works with any ADO.NET bank, but I believe that compatible banks at both ends are the best option to avoid headaches.
– Loudenvier
Thanks for the feedback! @Loudenvier
– Felipe Gabriel