SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[11.1.115 Pro] - FR: Compare Schema

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[11.1.115 Pro] - FR: Compare Schema
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post [11.1.115 Pro] - FR: Compare Schema Reply with quote
When comparing schema, there should be an option to ignore the schema name. Each compared object pair will have a difference in their create scripts (for tables that come in addition to each foreign key statements), meaning that it will mark all the otherwise completely identical objects as different.


Tue Dec 17, 2019 12:33 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
There is an option in the Ignore section "Semantical schema differences" that is generally responsible for what you described above.

When comparing tables in two schemas, first tables are matched by name, schema name isn't a factor there. After that all matched tables are compared by their attributes, columns, constraints, storage parameters, etc... The code view available at the bottom simply shows the reverse engineered DDL and highlights textual code differences, that's just a complimentary view. The actual differences are shown in the comparison tree.
Wed Dec 18, 2019 1:21 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
Yes, I've tried comparing schemas with that option both checked and unchecked. If by comparison tree you mean the pane above Code Differences, it marked the objects blue, or different, regardless of the state of the checkbox.
Wed Dec 18, 2019 4:56 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
Just in case... if you expand a table shown in blue in the top tree, it should show specific folders with the differences, for example, Columns, and if you expand it further, it should show which specific columns it found different and why. It's kind of a drill-down interface.
Wed Dec 18, 2019 10:11 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
Yes, that's exactly the feature I'd like to use but it marks tables as different it should not. It seems to 'forget' to disregard the schema name differences in foreign keys (the property Refer Table, to be precise). Can you check that one, please?
Fri Dec 20, 2019 6:46 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
Any updates on this one?
Wed Jun 17, 2020 3:08 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7141

Post Reply with quote
We are trying to get it fixed before the 11.2 maintenance release planned for the end of next week, but I'm not sure it will make it. Too little time is left for that, code freeze is in effect.
Fri Jun 19, 2020 12:35 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1741

Post Reply with quote
Don't bother with it then, no need to increase the risk of breaking something.
Fri Jun 19, 2020 3:12 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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
Design by Freestyle XL / Flowers Online.