Post reply

Establishing the relationship across the database

  • January 24, 2006 at 2:35 am

    #113168

    Hello,
       I want to know, whether is it possible to establish the relationship between the tables, which are present in different databases? Because, I am in a situation, where I need to maintain two databases for the same application, doing different situation. But I need to maintain strict relationship among the master tablse. These master tables should be same in both the tables. Is there any way to achieve this?
     
    --With Regards,
    Sheshadrinath.R

  • January 24, 2006 at 3:39 pm

    #616777

    You can't enforce a relationship between databases with foreign key constraints, but you may be able to do it with triggers or, possibly, replication.

    Greg

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

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