How can we help you today? How can we help you today?

script only FK differences between two sql db

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
ptran
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.