June 1, 2011 at 9:21 am
Hi there, Is it possbile to perform a comparsion of instances in different enviorments i.e prod and dev and how can it be done.? not looking for data comparsion, looking for instance/enviorment settings. thnx
Goher
June 1, 2011 at 9:35 am
Powershell would be one way to do it:
http://www.youdidwhatwithtsql.com/auditing-your-sql-server-with-powershell/133
June 1, 2011 at 9:49 am
June 1, 2011 at 10:04 am
Thanks much, now I have a starting point.
April 11, 2019 at 8:21 am
For others performing a similar task, you could use Aireforge Compare (it's free) to compare sys.configurations and many other server objects.
Comparing SQL Server configurations with Aireforge Studio
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply