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
- 127 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 |
How can we migrate from SQL server to SQL Azure?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
What is federation member?
How many replicas are maintained for each sql azure db?
Explain iaas, paas and saas?
How many databases can we create in a single server?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is sql azure database?
What is code near application topology?
What is TDS(Tabular Data Stream) Gateway?
Tell me something about security and sql azure?
How to connect Azure federated root database and apply federation in entity framework?
SSRS SQL Server Reporting Services 
