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.

Thanks,
ptran
ptran
 
Posts: 1
Joined: Fri Jan 11, 2013 8:50 pm

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

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
 
Posts: 6668
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