SQL Deploy Anything

  •        40

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

http://sqlanything.codeplex.com/

Tags
Implementation
License
Platform

   




Related Projects

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.

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

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.

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

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



DB Setup Helper


DbSetupHelper makes it easier for development teams to deploy their development databases across local systems. DB SQL Scripts can also be written in a way that lets end users configure some install options. The project is written in C#.NET and currently supports MSSQL.

MSSQL Deployment Tool


It is a utility based on MSSQL Server, to make deployment more easily and fully control with Version Management & Configuration & Deployment Tracking.

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

Mini SQL Query


Mini SQL Query is a minimalist SQL query tool for multiple databases (MSSQL, MSSQL CE, SQLite, OLEDB, MS Access/Excel files etc). The tool uses a generic schema engine taking advantage of the ADO.NET providers. Mini SQL Query is also easily extended with plugins.

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

PackageMetadataExtractor


Package Metadata Extractor is a C# project that reads column information from a SQL Server 2005 DTSX package and writes it into a SQL database, making it easier to obtain error information in SSIS packages. The resultant table can be used in a Lookup.

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 Exporter


This is a simple but fully customizable software intented to help dba, developer to export structure, data or users from an entire mssql database to a .sql file.

Cross Database Engine for PHP


CDE is a PHP class which implements the general database functions in PHP and provides a common SQL platform for php development where developers change their databases but not their code. Supports Firebird, MySQL,Oracle,SQLite, MSSQL(both drivers),CUBRID,ODBC. CDE now supports date uniformity, param passing amp; BLOB handling across all the databases supported. CDE is not a replacement for PDO, in fact we may implement PDO in CDE to standardize PDO results and calls. Some PDO drivers are

SQLbuddy – Microsoft SQL Server Management Tool


SqlBuddy is a tool for use with Microsoft SQL Server and MSDE, written in csharp/ DotNet (.NET), to facilitate SQL script writing. It is serves a slightly different purpose that of Query Analyser, in that it is aimed to *help* the user write SQL. It helps to explore the database schema, Organise SQL code and snippets, To expose the in-built SQL Server functionality (functions, procedures etc) to the developer.

pdoMap - ORM for PHP


pdoMap is a PHP ORM (object-relational mapping) framework. The main aim of this project is to provide to PHP developers a RAD framework and a new way of dealing with databases.

campus-convert - Local project to convert data from MSSQL database to MySQL


Local project to convert data from MSSQL database to MySQL

MssqlBundle - Manage connection to MsSQL database from your Symfony2 project


Manage connection to MsSQL database from your Symfony2 project