Projects

DBSourceTools

DBSourceTools is a GUI utility to help developers bring SQL Server databases under source control. A powerful database scripter, code editor, sql generator, and database versioning tool. Compare Schemas, create diff scripts, edit T-SQL with ease. Better than Management Studio.

dbdeploy.net

Database delta script management utility Manages the deployment of numbered change scripts to a database, using a simple table in the database to track the current schema version. Support for multiple database platforms including MS SQL & Oracle. Port of dbdeploy to .NET

CASI

Easily run large and continuously changing batches of scripts. CASI is a tool to make instillations easier. If you've ever maintained software with an sql database that is installed on many different sites you are probably familiar with the problems associated with making changes to the ... [More] database. Continuous integration, branching, Q‎A, and building release sets are all difficult because you have to keep track of what changes have been applied to what copies of the database. CASI along with a few development guidelines will cut though these problems and will help streamline your development and install process. [Less]

DbCurator

DbCurator is a simple database versioning tool. It allows you to manage mutations to your database schema in a structured manner using patch scripts.

Phinx

PHP Database Migrations for Everyone

Dub

dub manages databasemodifications (schema-evolution) during the development process/maintenance. It centralizes the changes, in order to execute them to the target database, and will keep an overview of all exising changes (new, current and past).

dbkeepernet

IntroductionDo you work on a database project and you need quickly and simply distribute your new or modified database schema? DbKeeperNet is a right way for you. DbKeeperNet is a project which goal is to provide a simple, easy to use and free ADO.NET platform for distribution of relational ... [More] database schema updates/changes (database schema updater, RDBMS schema distribution tool). You can use it freely in both commercial and non-commercial applications as you need. Next release planOracle Support See Feature planes for more information. Basic features.NET 2.0 or newer Highly configurable functionality with support for user extensions In basic scenarious only a very little of code (for about 4 lines), behaviour of the engine can be configured in App.Config or Web.Config files Update scripts are written in XML Planned with support for multiple database engines, single XML script may contain engine specific SQL commands for all application supported databases .NET written custom steps can be used when SQL is not strong enough (such as data conversion etc.) XML update script structure is strictly defined by XSD schema which can be used in any XML editor with autocompletion (intellisense) Supported databases: MSSQL 2000, MSSQL 2005, MSSQL 2008, SQL EXPRESS DB, MySQL, PostgreSQL Localized logging messages Future plansMySQL over ODBC support (looking for help, contact me if you are interested) [Less]

pydbmigrate

Database migration is a painful process. The tools to do this are, well, lacking, particularly in the python world. The particular features this offers are: distutils commands for managing migrations automatic database creation and destruction support for plain SQL in migration steps support ... [More] for Python functions in migration steps command line tool for performing migrations sparse migrations to facilitate code merging without the need to renumber migrations support for running tests from unit tests support for embedding the migration system in your code pluggable database support architecture the ability to control the database connections used This is the first publication of the code outlined in my 'Fundamentals of Agile Development in Python'. The initial deployed version has been available on PyPI for a while, but until now I've never gotten around to publishing the code itself. [Less]

MDT Web FrontEnd

The MDT Web FrontEnd has been created as an easy to use, customizable and flexible solution to access and configure the MDT Database. It is a full feature replacement of the database option of the MDT Deployment Workbench.

sqlmake

Sqlmake is an Oracle database schema deployment tool. It is used for Installing data model baseline from sql scripts Upgrading existing schema with data model with delta scripts Deploying stored procedures, views, grants to other users, private synonyms Development of this tool was motivated ... [More] with day to day issues around deployment of schema changes in development environments. With sqlmake it is very easy to keep local schema up to date with new changes from other developers. Database development must be based on sql scripts preferably stored in a version control like SVN: Data model changes are organized with delta scripts; sqlmake takes care of which delta scripts are already installed, which have to be installed, logs errors during install and so on Stored procedure changes are detected by comparing schema and sql scripts; if any differences are found they are automatically deployed to database schema One of the goals set when developing sqlmake was to make minimal impact to an existing database development process: Sql scripts require no additional choreography to be supported by sqlmake. Plain old SQL*Plus syntax is used. How SQL commands are placed inside scripts is completely up to user. All SQL commands can be in one big file for example, every command can be in its own file and so on. This way all existing data model and code generator output can be used with no changes. There is no custom XML or any other configuration needed when adding new content to schema PL/SQL development requires no additional work except for saving stored procedures as files. To start with sqlmake look at GettingStarted and examples included in Download section. [Less]