Microsoft SQL Action Pack

Automate common deployment scenarios for MSSQL databases.

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.