Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 128 Views
- I also Faced
- E-Mail Answers
Answer / Mithlesh
In such a scenario, you can use Change Data Capture (CDC) or Log Shipping to keep the SQL Azure database in sync with the remote databases. However, circular foreign key relationships are not directly supported in SQL Server 2008 and may require a redesign of your database schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Which are the two editions in which SQL Azure database available?
What is SQL Azure?
What is the index requirement in SQL Azure?
What is sql azure database?
Define Business Edition in SQL Azure?
What are rest-style architecture's?
Explain iaas, paas and saas?
How many replicas are maintained for each sql azure db?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
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 happens when the SQL Azure database reaches Max Size?
What is the data tier application?
SSRS SQL Server Reporting Services 
