SQL Server 2008 synchronization at 00:00 every day

1
votes

I have desktop application and I want that all new data in this application that are stored in local DB will synchronize every day at 00:00 to production database.

I was looking at the MS Sync Framework

http://www.vitalygorn.com/blog/post/2008/01/05/Microsoft-Sync-Framework-Support-in-Visual-Studio-2008.aspx

is this solution correct or how is the best way to synchronize two databases at 00:00 every day.

Application is written in C# and using local SQL Server 2008

1
c#sql-server-2008
The Sync Framework looks like a great solution to me. Do you have any concern? - Ignacio Soler Garcia
The time of day is distacting from the real issue - you're just asking how to sync two databases essentially. - Widor
Widor exactly. How to sync two databases. - senzacionale
SoMoS I am just thinking if this is the right approach with MS Sync Framework. - senzacionale
In addition to other comments, can I suggest that you run your sync (or any other scheduled process) at either 23h55 or 00h05, but never 00h00. It just causes confusion (in code, discussions, documentation etc.) about what day it is when the process starts, as well as potentially leading to bugs in any related date/time calculations. - Pondlife

1 Answers

1
votes

I would use database replication and specify a synchronization schedule.