Post reply

Two tables in two databases

  • January 9, 2007 at 2:05 pm

    #103298

    Hi,

    Is it possible to establish a FK constraint on a table in DataBase1 into another table in a different database (DataBase2).

    I think it's not possible. Please let me know if there is a way.

    Thank you.

  • January 9, 2007 at 2:13 pm

    #682186

    Short Answer: No

    Long(er) Answer: Programmatically it can be done.  Most people use triggers to implement in my experience.  It's kind of kludgy, IMHO, but it can be done.

  • January 9, 2007 at 2:35 pm

    #682191

    That's what I thought, thanks Aaron.

  • January 9, 2007 at 2:51 pm

    #682203

    I also heard about 3rd party tools that did just that.  I have no experience with them so I can't really comment or recomment any of them.

  • January 10, 2007 at 4:40 am

    #682330

    You can try RemoteKeys. It does exactly that !

    http://www.remote-keys.com

    (currently in free BETA)

Viewing 5 posts - 1 through 4 (of 4 total)

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