What are the challenges you face when working across database platforms? Take the survey
Options

SQL Compare 13 - Ignore indexes & partitions still queries them

bhmschbhmsch Posts: 2 New member
One of our databases has a large number of partitions (almost 15k for a single partition function, basically a daily) and even though selecting to ignore indexes & partitions the comparison still queries this which causes 10-30 seconds to each recompare.

1. Is there a way to change the SQL Compare registry or config files to not try to enumerate & query index partitions?

2. How do I provide feedback for product suggestions?  The request is that if indexes & partition schemas/functions are set to be ignored, SQL Compare should not attempt to query them.  Additionally would be helpful for other object types that are ignored so that the queries are streamlined to only what is selected for compare.

Answers

Sign In or Register to comment.