Sync Framework questions

0
votes

Okay so I have to sync data between two SQL Server Express instances and after a research I stopped at Sync Framework which I think can do the job.. but since I am pushed by time and I don't have much time to do a complete research I need to ask few questions before continuing..

Basically I will have a server database which will be cleaned once every two months and I need to have a mirror database that will contain all the records.

  1. Does sync synchronize the records only in the destination table or it also changes the server table if there is deleted records in it?
  2. Can I sync two SQL Server Express instances? Because I am reading the documentation and it only has SQL Server and SQL Server Express sync documentation..
  3. Do I need to create the mirror table or sync will create it for me?

Thanks in advance :)

2
c#sqlsyncsql-server-expressmicrosoft-sync-framework

2 Answers

0
votes
  1. You can specify the sync direction, upload, download, upload and download, download and upload, its all up to you.
  2. Yes, you can, the same SqlSyncProvider will work with SQL Express, SQL Server, Local DB and Azure SQL Database
  3. When you provision, you will have to define the tables that needs to be sync (table, columns, etc...). you will then provision the sync, when you provision, if the tables dont exist, it will create it for you.
-2
votes
  1. Sync framework is designed to work to synchronize databases, that means two way, and it includes some concept of conflict resolution. One way synchronization is called Mirroring.
  2. No you can't. Sync Framework is an enterprise level solution. You need to pay for it. With a SQL Server licence. Don't bother looking elsewhere, a SQL Server license is actually pretty cheap compared to the alternatives.
  3. Do not know the answer.