script only FK differences between two sql db

Forum for users of SQL Compare schema synchronization utility

script only FK differences between two sql db

Postby ptran » Fri Jan 11, 2013 7:58 pm

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.

Posts: 1
Joined: Fri Jan 11, 2013 7:50 pm

Postby Brian Donahue » Tue Jan 15, 2013 10:54 am


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
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests