SQL Server DB & SSIS Powershell Deployment

  •        153

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

SSIS ReportGeneratorTask

  •    

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

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

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.

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

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

  •    CSharp

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.

dbatools - PowerShell module to help SQL Server Pros be more productive

  •    PowerShell

dbatools is sort of like a command-line SQL Server Management Studio. The project initially started out as Start-SqlMigration.ps1, but has now grown into a collection of over 400 commands that help automate SQL Server tasks and encourage best practices.

sql-docs - Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc

  •    PowerShell

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments. You've found the GitHub repository that houses the source for the SQL Server technical documentation published on https://docs.microsoft.com.

Arachnode.net

  •    CSharp

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.

Useful SharePoint Site Workflow Utilities

  •    

This project aims to make it easy use SharePoint 2010's Site Workflows as "event handlers" for various back end systems by providing ways to start site workflows on remote farms from SSIS, SQL CLR and any Soap Web Service Client.

SSIS Package Manager - PacMan

  •    

PacMan - The SQL Server Integration Services Package Manager is a utility designed to permit batch operations on arbitrary sets of SSIS packages. Users can select a single package, a Visual Studio project or solution or a file system folder tree and then validate or update all...