How can we help you today? How can we help you today?

Command line to compare row counts same named tables across different servers

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?
Easyzone
0

Comments

4 comments

Sort by
  • Ben_P

    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

    Ben_P
    0
  • tata
    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.
    tata
    0
  • noahharold
    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!
    noahharold
    0
  • prosohaib

    You can use Redgate SQL Data Compare to compare row counts between tables on different servers. While it focuses on data differences, you can run it from the command line with the /verbose flag to check row count differences. However, SQL Compare’s HTML report doesn’t natively include row counts.

    If you need a simple row count comparison, a custom SQL script or PowerShell command might be a better fit. Let us know if you’d like guidance on that!, Also checkout the guide here

    prosohaib
    0

Add comment

Please sign in to leave a comment.