Relationship Databases
Hi,
I have a DataBase called "ServerInformation" where theres a table called "Clients"
Another database aplication "Index2003" using the same SQL Server, will acess the information in the table "Clients" from then "ServerInformation" Database.
My question is... How can I ensure data integrity using a relationship that "cascade update related Fields" from two different databases in the field "ID_Client" when its equal fields in :
Index2003 - > Documents - > ID_Clients
ServerInformation - > Clients - > ID_Clients
How can I do the relationship of two tables in different databases?
Thanks for attetion
Leonardo Almeida
Recife - PE - Brazil
55-81-9152-5106You would have to do this via triggers, or by making all data changes through stored procedures that maintain relational integrity.
blindman
Friday, February 10, 2012
Come on...Somebody help with Relationship two Databases
Labels:
aplication,
clients,
database,
databases,
index2003,
microsoft,
mysql,
onsomebody,
oracle,
relationship,
server,
serverinformation,
sql,
table,
theres
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment