Microsoft SQL Action Pack

Automate common deployment scenarios for MSSQL databases.

×


Request Sent!

Thanks for your inquiry. Someone will be in touch shortly.





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


Additional Notes

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

Available Actions:

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

Version 1.0.3

Download (zip)

Package.MSSQL 1.0.2

Automic released this

Auto Generated

Package.MSSQL 1.0.1

Automic released this

Auto Generated


Versions

Applications


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

Login to View or Leave Comments