deltasql for Linux 1.7.0

Renzo, dangermouse, stuckas in Servers / Other Server Applications

User Rating: 0 (0 votes)

deltasql is an Open Source tool to keep track of your database schemas.

A strong version control system for databases saves time to developers, who would like to keep their schema updated while developing with minimal effort. With a version control for databases, the number of mistakes dued to different schemas or missing scripts is considerably reduced. Critical errors in production due to schema inconsistencies disappear, too.

deltasql is an Open Source tool to synchronize databases with source code. While developing middle size or big applications, developers undertake changes to the data model which go along with changes to the source code. From time to time, branches of source code are done to stabilize the code which will go to production. A sort of data model branch is also needed.

deltasql provides a simple set of php scripts to be executed on an apache server backed by a mySQL database to collect all scripts which change the data model, and means to handle data model branches. The trick is to number the sql scripts and to create on each database instance a table which keeps the number of the latest executed script (the table deltasql uses is named TBSYNCHRONIZE).

A form allows the user to enter data from the synchronization table and thereafter the needed chain of datamodel updates is computed and shown to the user. The user has to manually execute all scripts. It is possible to update development schemas (the HEADs) and production schemas (the branches), to transform a production schema into a development schema and vice versa. Also in case of a schema dumped and imported into another database, it is still upgradeable as the synchronization table is contained into the copyed schema. However, it is not possible to downgrade a schema back to a previous version.

Features

Deltasql server manages SQL scripts which alter database structure and contents. It organizes scripts in modules, which can be grouped in projects. It allows to search among them.
Database synchronization by adding special synchronization table to each schema. Synchronization script generated by deltasql server. Handling of branches of branches and tags supported.
Verification step inside synchronization script to ensure script is executed on correct schema (available for Oracle and PostgreSQL).
Several teams of developers can manage several projects and several databases.
Ability to manage development schemas and production schemas by creating branches, branches of branches and tags.
Syncronization scripts can be generated for Oracle, postgreSQL, mySQL, Microsoft SQL Server and sqlite. On user request, any SQL-like database can be supported.
Synchronization script can be exported in several formats, including pretty printed HTML, text and XML or even a zipped package with each script stored in a file.
Free to use, Open Source tool licensed under GPL.
Integration on Windows platform (XP, 7) with multipurpose deltaclient tool.
Integration in Eclipse IDE with ant client or dbredactor client.
Bash client can perform continouus database integration on Linux.
RSS feed and iGoogle Gadget show latest submitted scripts.
Easy to install, like a webforum, as deltasql server runs on Apache/PHP backed by a mySQL database.
There is a manual, a list of frequently asked questions and a set of tutorial movies explaining how it works.
It is used productively by companies in Pakistan, USA, Italy, Switzerland and India and is popular in Japan and South Korea. In some companies it manages more than 2000 scripts and more than 10 projects.
Typically used for large J2EE/Oracle or J2EE/mySQL software architectures which are partially customized to the customer's wishes.
Ability to send email notifications to users who would like to work without deltasql.
Charting features to monitor how deltasql improves over time.
Ability to diff scripts if they were subsequently updated, ability to plot the tree of tags and branches and more...

File Size: 9.70 MB License: Open Source Price: FREE
Platform: Linux
Downloads: Total: 97 | This Month: 2 Released: 2014-06-24
deltasql for Linux Similar Software

DbVisualizer for Linux 9.1.9 B2148 DbVis Software AB    

DbVisualizer is the universal database tool for developers and database administrators. It is the perfect ... click · Database objects explorer · View information for: tables, indexes, primary keys, privileges, schemas, databases, procedures ... tables · Monitor row count differences · Support for BLOB, CLOB and binary data · View BMP, ... Auto Completion (aka code completion, intellisense) · Support for multiple SQL editors · Support for multiple result .... Free download of DbVisualizer for Linux 9.1.9 B2148

software pick   

Webmin for Linux 1.690 Webmin    

Webmin is a web-based interface for system administration for Unix. Using any modern web browser, you can setup user accounts, Apache, DNS, file sharing and much more. Webmin removes the need to manually edit Unix configuration .... Free download of Webmin for Linux 1.690

software pick   

GeoServer for Linux 2.3.3 Chris Holmes    

GeoServer for Linux is an Open Source server that will allow ... data. GeoServer's transactional capabilities offer robust support for shared editing. GeoServer's focus is ease of use and support for standards, in order to serve as 'glue' for the geospatial web, connecting from legacy databases to .... Free download of GeoServer for Linux 2.3.3

LightProfiler for Linux 0.8.00 Mid.Tier    

LightProfiler - profiler and diagnoses tool for Oracle extended SQL trace files, generated by 10046 pseudo-event. It convert raw trace file in human-readable format (session resource profile - method R), described session response time by varied statistics (e.g.: SQL statements, events groups, events dispensings and more...). Generated profile also contain .... Free download of LightProfiler for Linux 0.8.00

software pick   

WordNetScope for Linux 1.0.2 B20110914 Bernard Bou    

... a handy, easy to use browser specially designed for SQL database and Hibernate as Object-Relational Mapping. ... with SQLite WordNet database and ready-to-use install Wizard for other installs .... Free download of WordNetScope for Linux 1.0.2 B20110914

software pick   
Popular Software in Servers / Other Server Applications

Citrix XenServer 5.6.0 Citrix Systems, Inc.    

Complete, cost-effective datacenter and server virtualization. Free download of Citrix XenServer 5.6.0

software pick   

IP2Location IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-AREACODE-ELEVATION Database July.2014 IP2Location.com    

IP address to country, IDD code, weather station code, area code, elevation.. Free download of IP2Location IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-AREACODE-ELEVATION Database July.2014

Free SQL Health Monitor 1.0 ZOHO Corporation    

Monitors important parameters of MS SQL database. Free download of Free SQL Health Monitor 1.0

software pick   

CodeTwo Exchange Sync 2.2.4 CodeTwo    

Advanced synchronization of Exchange Server folders.. Free download of CodeTwo Exchange Sync 2.2.4

RTP RSS Feed 02.00.00 CodePlex    

Generates an RSS feed from a SQL query defined in the module settings. Free download of RTP RSS Feed 02.00.00

software pick