Comments
Sort by recent activity
You’re correct — SQL Compare doesn’t support true pre-filtering before the comparison begins. It needs to load metadata for all objects first, and only then applies any filters you’ve set. That said, using Filter Setup or a saved .scpf filter file can still help narrow down the results effectively after the initial load. For scenarios like yours (multiple servers and large object counts), the most efficient approach is usually to automate comparisons via the SQL Compare CLI and run them in parallel. This can significantly reduce overall processing time compared to doing everything manually. Also, saving reusable project configurations can help streamline repeated comparisons. / comments
You’re correct — SQL Compare doesn’t support true pre-filtering before the comparison begins. It needs to load metadata for all objects first, and only then applies any filters you’ve set. That sai...