How to Sync Two SQL Azure Databases?
Answer / Tulika Chatterjee
You can sync two SQL Azure databases using the Database Synchronization Service (DSS). DSS provides real-time data replication between databases. Another option is Change Data Capture (CDC), which captures changes to a table and allows you to replicate those changes to another database.
| Is This Answer Correct ? | 0 Yes | 0 No |
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What were the latest updates to SQL Azure service?
Where actually sql azure database is hosted?
What is a fan-out query in SQL Azure?
What is the current pricing model of SQL Azure?
How to connect to SQL Azure Database by using sqlcmd?
How many replicas are maintained for each sql azure db?
What are rest-style architecture's?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How can we migrate from SQL server to SQL Azure?
Which tools are available to manage SQL Azure databases and servers?
How can you manage sql azure security?