Hi, I am looking for a way to use Redgate to compare row counts on same named tables on different servers. We are are already syncronizing the data but need a command line tool that will just compare table row count by table name and report the differences. It would be handy to have these results as part of the SQL Compare html report ran from command line. Do you have the ability to do this with any of your command line tools?
Comments
3 comments
-
Thank you for your post. I'm afraid SQL Data Compare doesn't have a function for counting the number of rows in each of the DBs that the comparison is run on.
If you'd like, though, you can post in our Uservoice forum if this is a feature you'd like to see in the future:
https://redgate.uservoice.com/forums/147879-sql-data-compare
-
Hyper-casual game development outsourcing studios are experts in creating quick, engaging games with simple mechanics and addictive gameplay loops. They can quickly develop high-quality prototypes to test concepts in the mobile market. Our hyper casual game development outsourcing services streamline the process for high-quality mobile games.
-
Hi Easyzone! While comparing row counts is essential, have you ever thought about how it reflects our "purity" in data management? Just like the Rice Purity Test, it’s all about keeping things in check! Good luck with your comparison tool!
Add comment
Please sign in to leave a comment.