Red Gate forums :: View topic - script only FK differences between two sql db
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Compare 10
SQL Compare 10 forum

script only FK differences between two sql db

 Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ptran



Joined: 11 Jan 2013
Posts: 1
PostPosted: Fri Jan 11, 2013 8:58 pm    Post subject: script only FK differences between two sql db Reply with quote
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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6346
Location: Red Gate Software
PostPosted: Tue Jan 15, 2013 11:54 am    Post subject: Reply with quote
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group