Command line to compare row counts same named tables across different servers
Easyzone
Posts: 1 New member
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?
Tagged:
Answers
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