Red Gate SQL Compare

What do you like best?

most helpful feature about redgate SQL compare tool is that its enables to be compare different tables and datasets across multiple databases and saves a lot of time to figure out differences and discrepancies.

What do you dislike?

downside of using the redgate sql compare tool is that there is a learning curve to be able to understand how to effectively use this tool and is not very intuitive.

Recommendations to others considering the product:

It is worth understanding and learning how to use this tool as it saves a ton of time over time and saves erroneous data comparisons once you put in the time and effort to learn to use this tool.

What problems are you solving with the product? What benefits have you realized?

I use this tool every now and then to compare huge datasets in tables across multiple databases within the same environments as well as across test and production environment to sync the data across all servers and databases. This saves a lot of time as it would be very painful to do this manually without the use of this tool and also allows room for user error otherwise.