script only FK differences between two sql db

ptranptran Posts: 2
edited January 15, 2013 5:54AM in SQL Compare Previous Versions
using SQL Compare 10, I'm trying to see if there is a way to compare only the FKs of db1 with db2, and then generate the SQL script to synch db2. I only want the FKs, there are other differences between the two databases such as datatype and column names, but all columns with FK use the same cloumn name.

Thanks,
ptran

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    It's currently not possible to isolate the comparisons so that you only compare keys. Basically, tables can't be ignored -- primary and foreign keys are viewed by SQL Compare as attributes of tables.
Sign In or Register to comment.