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

Is there a way to exclude tables while compare is registering its source/target?

jclignettjclignett Posts: 1 New member
I know how to use the exclude filters once the entire schema has been read - prob is that we have potentially 1000s of tables that live for a certain amount of time. It takes about 15 minutes to process all of these when reading schema.
Tagged:

Answers

  • Options
    Hi @jclignett

    Thanks for reaching out to us regarding this!

    Unfortunately it isn't currently possible to exclude objects from the comparison process, only after the comparison has completed is it possible to include/exclude/filter certain objects for deployment.

    SQL Compare first needs to 'look' at everything within the databases being compared so that it can serve up the list of objects for selection for deployment. 

    It may be worth reviewing the following help article which outlines how you might be able to speed up the comparison process by disabling "Decrypt encrypted objects": https://documentation.red-gate.com/sc/troubleshooting/common-issues/comparison-seems-slow

    I hope this helps!
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.