Skip to main content
Synthetic Realities
Shopping cart
Empty
For enquiries:
synthetic.realities@outlook.com
0409 048 621
  • home
  • About us
  • Blogs
  • Contact us

Categories

  • Business Processes
  • Business Tools
  • DBA Tools
  • SQL Scripts
  • Software

Version Audit

Version Audit

Version Audit is a collection of scripts used to automate the creation of a spreadsheet (csv), detailing the Instance Version information of multiple MS SQL Instances.

Customer reviews:

Reviews (0)

Add a review

Availability:

Delivery:

Total price:
$10.00
Description Details Warranty

Business Case
When working with multiple environments using MSSQL database instances, it is often the case where different versions of MSSQL are deployed across development and test environments and left to languish until a decision to review and potentially upgrade, is made. This tool set expedites the auditing time for your DBA.

Overview
Version Audit is a collection of scripts used to automate the creation of a spreadsheet (csv), detailing the Instance Version information of multiple MS SQL Instances. This set of scripts can also be extended to automate other sql process as its core feature provides the ability to execute a single sql script across multiple MSSQL instances and capture the output.

Input Example
SRD01\DEVELOPMENT01,5022
SRD01\DEVELOPMENT02,5023

Output Example

SQL Version Pack Level Machine Name Instance Name Edition
Microsoft SQL Server 2012 - 11.0.2218.0 (X64) 11.0.2218.0 RTM SRD01 DEVELOPMENT01 Developer Edition (64-bit)
Microsoft SQL Server 2012 - 11.0.2218.0 (X64) 11.0.2218.0 RTM SRD01 DEVELOPMENT02 Developer Edition (64-bit)


Category: 
DBA Tools

Contents
Versions.zip
> Instances.txt
> README.txt
> Versions.csv
> Versions.sql
> Versions.cmd

Requirements
OS: Windows XP or higher Or Windows Server 2003 or higher.
SQL Instance: MSSQL 2008 R2 or Higher

Please note that the script requires sqlcmd to be enabled and the account that runs the batch file needs to have appropriate levels access and permissions on each server or computer on your domain

please refer to Terms and Conditions on this website

Related Products

Order support

  • Customer Service

Product support

  • Purchases and GST

Legal

  • Terms and Conditions
  • Returns & Refunds
  • Business Contact Details
  • Privacy