Print Thread
Compare user objects enhancement
#63780 04/08/22 11:52 AM
Joined: Apr 2022
Posts: 3
J
JureM Offline OP
Member
OP Offline
Member
J
Joined: Apr 2022
Posts: 3
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: 22,198
Member
Offline
Member
Joined: Aug 1999
Posts: 22,198
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
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.032s Queries: 15 (0.010s) Memory: 2.4954 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-04-18 09:28:18 UTC
Valid HTML 5 and Valid CSS