Foreign key Referencing a column in another linked server

Question

Foreign key Referencing a column in another linked server

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Ramji29 Hall of Fame Points: 3832 More actions · Answer 1

as per me the best way is to create the exact table in your database and then write a job in your server to sink up this table with the original table residing at other server and schedule it on the basis as how frequently the source (main) table is updated.

I've followed the same approach in one of our databases and it's working fine.

Rohit

Johan Bijnens SSC Guru Points: 135374 More actions · Answer 2

If your DA / DBA do a good job documenting the relationships, they would for sure use DRI in the database itself AND document the external relationship in the comment of the column !!

Not only in erwin or whatever da-document tool they use !

Any programmer studying the datamodel will benifit from that.

On the other hand .... do programmers still study the DM ?? :ermm:

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

peace2007 SSCrazy Points: 2154 More actions · Answer 3

Does it mean there's no tool to show that in diagram?:(

Actually no programmer is willing to review data model; unless they have to 😉 I think I'll refer to that more than anyone else :laugh:

Johan Bijnens SSC Guru Points: 135374 More actions · Answer 4

peace2007 (4/26/2008)
Does it mean there's no tool to show that in diagram?:(

AFAIK you dan define logical relationships in ERwin in the logical model.

But I think that will be about the only place one can do it.

That's why I suggest at least to put it in the FK-column's comment !