Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server

  •        523

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.


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.

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.

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

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

T.S.T. the T-SQL Test Tool


TST simplifies the task of writing and running test automation for T-SQL code. Written in T-SQL it provides an API similar to those provided by other Unit Testing frameworks. Can produce test reports in XML format. It provides automatic rollback, dataset comparison support, etc.

DBA Headquarters: SQL Server DBA Automation Tools


Tools for SQL Multi-Server Centralized Administration: * Performance * Indexing * Backups * Windows event logs * SQL Agent Jobs * SQL error logs * Database Statistics * Security * Compliance Auditing * Change Management * Scripts Library * Multi-Media Library