Print Thread
Request - Option to exclude partitioning from Compare User Objects
#55583 01/30/17 12:42 PM
Joined: Sep 2003
Posts: 387
London, UK
Member
OP Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
If I run a schema compare between production or a full test environment and a dev schema, it takes a long time (an hour is not uncommon) and the resulting huge report is full of thousands of 'alter table add partition' statements, which I am not interested in and don't want to apply to my dev schema.

Can we have a checkbox option to ignore partitioning differences so we can quickly compare the structure in terms of tables and columns etc?

Update: by way of example, I have just run a comparison for a schema of just under 600 tables of which 150 are partitioned. It took 2 hours and the diff report is 118K lines.

Re: Request - Option to exclude partitioning from Compare User Objects
William Robertson #55596 01/31/17 10:14 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

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.051s Queries: 14 (0.023s) Memory: 2.4973 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 08:04:50 UTC
Valid HTML 5 and Valid CSS