SQL Server DB & SSIS Powershell Deployment

  •        137

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.

http://bideploy.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server


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.

SSIS ReportGeneratorTask


SSIS Task for SQL Server 2008 and 2012 to create server reports or local reports from a recordset data source.

PowerShell-ETL-SQL-Server


PowerShell scripts for more object-oriented ETL than SSIS & remote SQL Server job initiation

SSIS command line package uploader


This goal of this project is to create a stronger command line deploy utility for SSIS packages destined for SQL server. Capabilities will include purging of existing content, creation and deployment to subfolders and uploads based off deployment manifest generated by Visual ...

PowerShell Script Task for SSIS


To produce a control flow task for SSIS that can be used to run PowerShell scripts within SSIS. It should integrate SSIS and PowerShell so that SSIS specific information (i,e. variables) can be accessed etc from within your script. The initial versionn has the following feat...



SSIS GoogleAnalyticsSource


A SSIS Data Source Component for SQL Server 2008 and SQL Server 2012 to load data from the Google Data API.

Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE)


Originally an internal MSIT solution that has been released as an open source project, the Microsoft SQL Server Metadata-Driven ETL Management Studio (a.k.a. MDDE) provides a tool for rapidly generating SQL Server Integration Services (SSIS) packages from a shared central metadat

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.

SQL Server Integration Services (SSIS) Application Server


SQL Server Integration Services (SSIS) Application Server is an application server built around managed Microsoft SqlServer.Runtime API designed to extend standard Integration services management and execution model.

TaskUnZip for SSIS


Simple Task for SSIS (SQL Server Integration Services) for manage compress file ZIP. This task (Control Flow Items), permit compress/decompress file zip in SSIS Task context. Support password. _Work in Progress!_ ;-) Tnx to: *[url:http://sharpdevelop.net/OpenSource/SharpZi...

SSIS Expression Editor & Tester


An expression editing and testing tool for SQL Server Integration Services (SSIS). It also offers a reusable editor control for custom tasks or other utilities.

SQL Deploy Anything


This project was created to create a standard tool to deploy anything to Microsoft SQL, SSIS packages, SQL scripts, and Database or SQL projects.

CopyLogins task


CopyLogins is a SSIS control flow task that can transfer logins from one SQL instance to another including the passwords for the SQL Logins

SSIS Multiple Hash


SSIS Multiple Hash makes it possible to generate many Hash values from each input row. Hash's supported include MD5 and SHA1.

Dynamic Data System - ETL for SQL Server using dynamic SSIS


DDS makes loading a data warehouse much easier and faster. This system uses SSIS to load standard and partitioned tables via SSIS packages created on the fly using metadata. No longer will you have to maintain complex SSIS packages. Only basic T-SQL skills are needed. Pr...

SSIS Event Log Source


An SSIS 2005 Data Source component for loading Windows 2003/XP event logs (*.evt) into SQL Server 2005 for analysis

SSIS Custom Task BewiseSmartIndexManager


This project show an Maintenance Task which is availaible in Control Flow into SSIS Package.

Arachnode.net


An open source .NET web crawler written in C# using SQL 2005/2008. Arachnode.net is a complete and comprehensive .NET web crawler for downloading, indexing and storing Internet content including e-mail addresses, files, hyperlinks, images, and Web pages.

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.