DB Setup Helper

  •        59

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.

http://dbsetuphelper.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.

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

DBScripter - Library for scripting SQL Server database objects


This project is library that allows users to script SQL Server database objects. Library uses dynamic management views for extracting data about databases objects. This library could be used in various situations. The most interesting areas are comparing database objects a...

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.

SqlHarvester Database Scripting Engine


SqlHarvester is a free command-line based scripting engine written in .Net. It enables the import/export of database content across disconnected Sql Server databases.



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.

ExportSQLScript - Export MS SQL 2008R2/2008/2005/2000 objects to script


Command line driven utility to export MS SQL objects to script files suitable for database creation and revision control. Uses 2008R2 Server Management Objects (SMO) which are compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

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.

SQL Database script generation for Visual Studio 2008


This project host a Visual Studio Add-In for creating schema scripts, stored procedures and views from SQL Server. Basically, with a couple of clicks you can generate all your tables, stored procedures, and views as individual scripts with DROP/Add statements for foreign keys...

SQL Compact data and schema script utility


This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

ScriptDB


ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database. It will work against any SQL Server 2000 or 2005 database. It creates a directory tree structure with a similar hierarchy to that in Object Explorer i...

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

Scriptio - A SQL Server Object Scripting Utility


A utility for generating object scripts for Microsoft SQL Server. It is specifically designed to script DROPs and CREATEs in the same script.

Chinook Database


Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

CSV to SQL Server Compact scripting utility


This command line utility allows you to generate a SQL Server Compact INSERT script based on a csv file and an existing SQL Compact table.

Big SQL Script File Runner


Here's project that enables any developers or others to run the big sql script file greater than 300MB or any size. It also supports rollback feature & others.

SQL Compact Command Line Tool


Administer SQL Compact databases directly from the command line, without having Visual Studio or SQL Server Management Studio installed. Only requires NetFx 2.0 and SQL Compact installed. Command line options similar to sqlcmd. Also runs any SQL Compact script files.

Northwind database


Northwind database that can be downloaded as an executable sql script or as a backup that can be restored with sample data currently works with Sql Server 2005 and Sql Server 2008

Free SQL Server Database Templates & SQL Code Download


You can download here SQL Server Database Templates an SQL Source codes for various type of projects, Template Downloads for SQL Server