Keep local MS SQL 2008 DB table and remote SQL Azure DB table in sync
- by Boomerangertanger
Hi there, I have a dedicated server which hosts a Windows Service which does a lot of very heavy load stuff and populates a number of SQL Server database tables.
However, of all the database tables it populates and works with, I want only one to be synchronised with a remote SQL Azure DB table. This is because this table holds what I called Resolved data, which is the end result of the Windows Service's work.
I would like to keep a SQL Azure database table in sync with this database table.
As far as I understand, my options are:
Move everything onto Azure (but that involves a massive development overhead and risk)
Have another Windows Service on the dedicated server which essentially looks at changed records since the last update and then manually update the SQL Azure table