0

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
Improve this question

3 Answers 3

Reset to default
4

Microsoft has the SQL Azure Data Sync used with the Sync framework:

http://www.microsoft.com/windowsazure/developers/sqlazure/datasync/

This can be used from T-SQL and the SQL Agent:

Link

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Conversely, you could have a daily backup performed on your main database tables that only backs up changes. Then you could transfer the backup file to the SQL Azure database host and Restore from the file. At that point, you would have them in sync through daily scheduled tasks that shouldn't take very much effort. The BACKUP and RESTORE T-SQL commands should accomplish what you're looking for, and SQL Azure says it supports T-SQL.

Improve this answer

3 Comments

SQL Azure doesn't support BACKUP/RESTORE, unfortunately.
Oh snap, I guess I need to research more >_<
However, SQL Azure only supports a sub-set of T-SQL. There's a few things not supported.
0

Try SQL Examiner Suite http://www.sqlaccessories.com/SQL_Examiner_Suite/

This tool can synchronize your local database with SQL Azure database (both schema and data)

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.