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
- 124 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
