#943 DBDiff plugin: bad schema detection

[Cristiano Guadagnino]

I just tried to compare two tables on DB2 z/OS: one is called "ANA"."TXSTATI", the other is called "PNA"."TXSTATI".

DBDiff plugin does apparently nothing. If you look at the log, you see the message:

Logged by net.sourceforge.squirrel_sql.plugins.dbdiff.actions.CompareAction at 1/14/11 10:53 AM:

Source and destination schemas were the same schema

Obviously, this is not true.

[Rob Manning]

Cristiano,

Yes, it's a bug. There is a work-around however : open two sessions to the same database and select in one session, compare in the other one.

FWIW, I am embarking on some major changes to the plugin that I think will improve it's capabilities greatly. I am planning to take a different approach though, and I wonder what your feeling is about it. I am planning to display the differences in a viewer that shows the "sql script" equivalent in a diff viewer component. So, on one side would contain the objects that were "selected", and the other side would contain the objects to "compare". This component could be replaced with an external diff viewer as well. Would this give you what you need, or would you rather have access to the current graphical representation as well ?

Rob

[Cristiano Guadagnino]

Rob,
thank you for making me part of the decision process.

I like what you have in mind, and I think it would be a great enhancement.
On the other hand, if it is feasible, I'd like to keep the current graphical representation as well.

There is even another possibility that would surely be desirable, but probably too difficult to implement: a "sql script" view that shows the necessary statements one would have to apply to an object to bring it on par with the other.
I say this just as "food for thought", since you're rethinking this plugin.

Thank you for this plugin, it is very useful in my daily work.

Cris

[Rob Manning]

Yes - a synchronization feature is not simple, but possible. I will keep the original graphical representation at least for table column differences. But, I anticipate the "script difference" view will be a bit more capable. Thanks for the feedback.

Rob

[sfst]

Using squirrel-sql-snapshot-20230109_2301-standard.jar

I have tried with an Oracle database to compare 2 tables in different schemata (but different sessions) and got nothing. It logged:

ERROR net.sourceforge.squirrel_sql.client.Main - Exception occurred dispatching Event java.awt.event.MouseEvent[MOUSE_RELEASED,(538,836),absolute(530,868),button=1,modifiers=Button1,clickCount=1] on frame0

[Gerd Wagner]

Fixed in our GIT repositories. Will be available in future snapshots an versions.

Excerpt from change log:
'#943 Database table compare function (right mouse click on table in Object tree) raised NoClassDefFoundError.
The fix includes some minor UI improvements.