troubleshooting Question

Vbscript or Powershell to Compare SQL Databases - Rowcout

Avatar of Dhiraj Mutha
Dhiraj MuthaFlag for United States of America asked on
Scripting LanguagesPowershellMicrosoft SQL Server 2008
19 Comments1 Solution1201 ViewsLast Modified:
HI All,

I need a help in writing a script to compare two databases. We have a SQL script which gives us the rowcount of each table in a database.

What we do is, run this query on both the databases and copy it to excel and compare them.

Hence need a VBscript or PowerShell script to compare it in one shot.

I shiuld be able to enter two db server name and database name and the script should compare based on the rowcount.
Dhiraj Mutha
Level D

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 19 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros