Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Data Integrity & Distributed Client Server Archit

Author  Topic 

Aiby
Yak Posting Veteran

71 Posts

Posted - 2008-01-05 : 20:24:59
I have a situation here..
I have 5 different applications with 5 Different DB which were implemented in more than 6 different sites. How can I maintain the data integrity between these shared application in different Databases across different servers.

One specific question which I can list here along with this is… Suppose if I have few same tables which has been maintained locally my each application. Can I separate them to Shared common Database. If I do so .. How can I maintain the relational Integrity?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-05 : 21:37:45
Different dbs in different site for same app? Take look at merge replication.
Go to Top of Page

Aiby
Yak Posting Veteran

71 Posts

Posted - 2008-01-08 : 14:32:42
quote:
Originally posted by rmiao

Different dbs in different site for same app? Take look at merge replication.



Different APPLICATIONS which are related to one other. Master Data's could be shared to each other..
Go to Top of Page
   

- Advertisement -