Sql Compare is taking more time on a database at 'Reading object text' step

VIJAYETAN

Staying at below  step 'Reading object text' for about  20-30 Minutes

09:49:26.237|Info   |SQL Compare Engine  |21 |Reading synonyms

09:49:26.360|Info   |SQL Compare Engine  |21 |Reading object text 

It was working fine till before 1 week, also working fine with other copy of this database. But only issue with this particular version of database. Any issue with consistency of db ?

Kurt_M

Hi @VIJAYETAN

I'd have to take a look at the log file of the comparison to see what it's doing. Are you able to enable Verbose logging, run the comparison once more and then forward the log file through to support@red-gate.com?



Alternatively, you can try the option listed in our documentation to try and speed up the comparison:

https://documentation.red-gate.com/sc/troubleshooting/common-issues/comparison-seems-slow