script only FK differences between two sql db

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

script only FK differences between two sql db

Postby ptran » Fri Jan 11, 2013 8: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 8:50 pm

Postby Brian Donahue » Tue Jan 15, 2013 11: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: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests