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
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.
|