deltasql icon

deltasql

  n/a
Certified 100% FREE GPLv2   

Create data models and keep track of the schemas for a variety of SQL-like databases, monitoring performed changes as they happen. #Database schema  #Database version control  #SQL database  #Version control  #Manage  #Manager  

Description

features

changelog

Free Download

deltasql is a comprehensive and efficient software solution aimed to provide database developers with the means of keep tracking of changes performed by team members, acting as a version control instrument to enable them to keep their schema up to date, at all times, allowing them to carry on with their work.

By relying on version control, it is less likely for errors such as missing scripts or different schemas to occur, while also limiting the amount of critical errors in production, as a result of schema inconsistency.

deltasql does this by synchronizing the databases with the source code as it is being written by developers. It comes with a series of PHP scripts that will be run on an Apache server connected to a database, in order to gather the scripts altering the data model, along with method of handling its branches.

For this to happen, users need to number the SQL scripts and build a database instance table where they can store the number of the script that was run last. deltasql relies on a table names ‘TBSYNCHRONIZE’ for this precise purpose.

By means of a form, users can input data from the synchronization table, which automatically updates and computer the data model chain, returning the result to users. Scripts need to be manually executed.

Moreover, deltasql allows users to update the development as well as the production schemas, or they can transform them from one to the other. A dumped schema can be imported into a different DB and can be upgraded, given that the synchronization table is stored within the duplicate schema.

Downgrading a schema to an earlier version, however, is not supported. deltasql is equipped to handle Oracle, PostgreSQL, MySQL or SQL Server databases, but it can also work with other SQL-like DBs.

System requirements

  • SQL-like database environment

What's new in deltasql 1.8.2:

  • This release is a 10 year jubilee as deltasql development started on Easter 2007
  • and was continued occasionally during the last 10 years when free time allowed it.
  • As fortunate coincidence I also met my now wife at the same time :-)
Read the full changelog

deltasql 1.8.2

add to watchlist add to download basket send us an update REPORT
  runs on:
Windows All
  file size:
22.6 MB
  7 screenshots:
deltasql - deltasql is a complex piece of software that functions as a database schema version control tooldeltasql - It can work with all SQL-like servers, including MySQL, SQL Server, PostgreSQL or Oracledeltasql - You can view the evolution of the database being built as it happens and track changesdeltasql - screenshot #4deltasql - screenshot #5deltasql - screenshot #6deltasql - screenshot #7
  main category:
Internet
  developer:
  visit homepage
User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy