SQL Server comparison script

Goal

To obtain specific comparison information  for the most common DBA specific tasks.

My way of achieving it

Using powershell.

This is not a final script is merely an example that can be used to create something that can be used when we need to compare 2 logins, 2 database users, 2 instances and so on. The script can contain other type of comparison and this example contains only what I am used to compare most of the time.  Another benefit is that provides an output that can be easily exported and filtered further in excel and provided to other people in an easily accessible format .

The output of the script look similar to this

comparison_script

 

The script can be downloaded from here

Leave a Reply

Your email address will not be published. Required fields are marked *