Options
SQL Compare 13 - Ignore indexes & partitions still queries them
bhmsch
Posts: 2 New member
in SQL Compare
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.
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.
Tagged:
Answers
1. There isn't a way to do this. Sorry.
2. If you want to provide feedback on SQL Compare then please leave any suggestions on our Uservoice site.
All the best.
Redgate Software