Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server

  •        388

SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

http://sqlspade.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

SQL Server DB & SSIS Powershell Deployment


A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.

DbDiff: Database Diff and Database Scripting


Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali ) Features: - compare database structures - scripting without dmo or smo - commandline scripting, commandline compare - standalone dll-s for referencing

Snippets Generator for SQL Server 2012


Snippets Generator allows the user to easily create T-SQL snippets for SQL Server 2012! You can create a snippet from scratch or by using snippet templates.

SQL Server Management Studio Add-in for Denali\SQL2012 (SSMS Addin)


Example/Framework of a SQL Server Management Studio Add-in (SSMS Addin) for Denali\2012. The aim of this project is to prove an example of an Add-in. The example add-in shows; * How to take the contents of the query window and format it. * How to use the context menu ...

SQL Server PowerShell Extensions


The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.



ReportingServicesTools - Reporting Services Powershell Tools


This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services. In order to use the scripts included in this project successfully, please download/clone the entire project as there are dependencies between the scripts.All of our scripts were written with the assumption that you will be executing them against SQL Server 2016 Reporting Services default instance (i.e. mssqlserver). However, we understand this may not be the case for you. So for each script, you will see that we have provided a way for you to specify the name and/or version of your SQL Server Reporting Services instance name. Sometimes the version of your SQL Server instance is also required. If you do not provide one, we will assume that you want to execute this against the default instance.

PowerShell SQL Developer Tools


Series of PowerShell Functions to assist in the scripting and rebuilding of SQL Server objects through automation.

SQL Power Doc


SQL Power Doc is a collection of Windows PowerShell scripts & modules that discover, document, & diagnose SQL Server instances & their underlying Windows OS.

RSBuild SQL Server Reporting Service Deployment Tool


RSBuild currently supports two types of tasks: executing SQL Server scripts and publishing SQL Server Reporting Serivce reports and shared data sources. It uses ADO.NET to execute database scripts in batch. Database script can be specified in the configuration file with speci...

An Un-sql SQL Database Installer


D.E.M.O.N SQL Database Installer is an Un-SQL(SQL means boring here) Database server installer for many types of Database :MySQL, FireBird, SQLite and others.

SQLDeploy.Net


SQLDeploy.Net is a utility to deploy [run] a set of SQL Scripts on SQL Server. The utility can be integrated with any deployment manager like Marimba , Hudson etc to automate database deployment. The project is developed on .Net Framework 4.0 but it is equally backward comp...

SQL Server Central Management System


The SQLCMS uses and extends a series of features in SQL Server 2008 to manage and monitor SQL Server Instances, from versions 2000-2008. It is a series of modular components that also allows integration with other solutions such as MOM or OpenView installations.

SQL Server FineBuild


FineBuild provides 1-click install and best-practice configuration of SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005

Powershell4SQL


Module designed to simplify working with SQL Server from Powershell

powerTrace - a PowerShell snapin for SQL Server Trace files


This is a snapin for Microsoft PowerShell which allows for the loading and exploration of SQL Trace files using PowerShell. This provider has been initially designed to work with trace files from SQL Server Analysis Services.

GetMsSqlDump - a mysqldump-like tool for MSSQL


GetMsSqlDump is the mssql counterpart (or something similar) of mysqldump, written for Microsoft SQL Server, in PowerShell. I'd call it mssqldump if it weren't in use. Using this script you can dump your database content into a file in a form of INSERT INTO statements.

sql-xplat-cli - Repository for the new SQL cross-platform command line tools


We’re excited to introduce mssql-scripter, a multi-platform command line experience for scripting SQL Server databases.mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard nix utilities (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control and subsequently execute the script in your existing SQL database deployment processes and DevOps pipelines with standard multiplatform SQL command line tools such as sqlcmd.

PowerShell Data Processing Extension for SQL Server Reporting Services


Plug this into SQL Server Reporting Services to create reporting based on your PowerShell scripts. The PowerShell DPE transforms your PowerShell output into a DataSet that can be consumed by SSRS.

SQL Installer.NET


SQL Installer.NET is a toolset which assists in the development, deployment, and maintenance of applications which interface with a relational database management system (RDBMS).

SQLBK; una solucion para respaldos de SQL Server. (SQL Server backups)


SQLBk es una aplicacion basada en .NET Framework 2.0 que permite realizar respaldos 'Full' de una base de datos de SQL Server, comprimirla y opcionalmente enviarla a un servidor FTP. En la proxima actualizacion se espera agregar respaldos diferenciales, multiples bases de dato...