Print Thread
Compare user objects enhancement
#63780 04/08/22 11:52 AM
Joined: Apr 2022
Posts: 2
J
JureM Offline OP
Member
OP Offline
Member
J
Joined: Apr 2022
Posts: 2
When comparing tables with identity columns, values of these columns are always compared. In case the values differ between source and target database, the table is displayed as having differences and the following script is generated (example):

SQL Query
alter table MY_TABLE modify MY_IDENTITY_COLUMN generated as identity (start with 1);

When a schema has a lot of tables with identity columns, it is really hard to find "real" differences in tables.

I suggest adding a checkbox in the Options tab to either enable or disable comparing values of identity columns.

Re: Compare user objects enhancement
JureM #63781 04/08/22 01:09 PM
Joined: Aug 1999
Posts: 21,723
Member
Offline
Member
Joined: Aug 1999
Posts: 21,723
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4