Comparison seems slow
Published 13 December 2022
The process of comparing databases may seem slow, especially if you have thousands text objects such as stored procedures.
SQL Compare can decrypt encrypted objects on SQL Server databases. If the database contains a large number of objects that reside in SQL Server's SYSCOMMENTS table, such as stored procedures and user-defined functions, SQL Compare has to read through the code for all of these objects whether they are encrypted or not. The performance will improve after turning off the "Decrypt encrypted objects" option in the project options tab.