Microsoft SQL Action Pack

Automate common deployment scenarios for MSSQL databases.


Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languagesare T-SQL and ANSI SQL.

The database runbook functions allow you to cover basic deployment scenarios specific for MSSQL databases.
You can for example create new databases, backups etc. You can also execute arbitrary SQL-queries or -scripts (e.g. your deployment migration scripts).

Available Actions:

  • Create/Drop/Rename Database
  • Create/Drop User
  • Assign/Drop Role to Member
  • Create/Restore Backup
  • Create/Drop Login

Supported Databases

The runbook functions use standard SQL queries executed over a JDBC connection to the database. The following system was tested:

  • MSSQL on Windows Server 2008 R2
Please log in using your Broadcom account to download this plugin.
Find platform support and compatibility information for Package.MSSQL in our compatibility matrix.
Please log in using your Broadcom account to download this plugin.
Products Continuous Delivery Automation, Continuous Delivery Automation, Automic Automation
Versions 11.x
Operating Systems Windows
Solution Area Data
Last update 2016-03-23 12:15:13.0
Supported by
Community Source microsoft-sql-action-pack

Broadcom does not support, maintain or warrant Solutions, Templates, Actions and any other content published on the Community and is subject to Broadcom Community Terms and Conditions.