deltasql for Linux 1.7.3

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.

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

Author Renzo, dangermouse, stuckas
License Open Source
Price FREE
Released 2015-12-01
Downloads 524
Filesize 9.70 MB
Requirements
Installation Instal And Uninstall
Keywords database management, schema, manage database, version control, SQL database, management, manage, manager
Users' rating
(8 rating)
deltasql for LinuxOther Server ApplicationsLinux
deltasql for Linux - Download Notice

Using deltasql for Linux Free Download crack, warez, password, serial numbers, torrent, keygen, registration codes, key generators is illegal and your business could subject you to lawsuits and leave your operating systems without patches. We do not host any torrent files or links of deltasql for Linux on rapidshare.com, depositfiles.com, megaupload.com etc. All deltasql for Linux download links are direct deltasql for Linux full download from publisher site or their selected mirrors.
Avoid: oem software, old version, warez, serial, torrent, deltasql for Linux keygen, crack.
Consider: deltasql for Linux full version, full download, premium download, licensed copy.

deltasql for Linux - The Latest User Reviews

Most popular Other Server Applications downloads

IP2Location IP-IDDCODE-AREACODE Database

March.2024 download

IP address to country, IDD code, area code, net speed, ZIP Code, ISP, domain.

IP2Location IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-AREACODE-ELEVATION Database

March.2024 download

IP address to country, IDD code, weather station code, area code, elevation.

IP2Location IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE-ISP-DOMAIN-NETSPEED-AREACODE-

March.2024 download

IP address to country, ISP, domain name, mobile, elevation and usage type.

ESF Database Migration Toolkit Standard

11.2.27 download

This software converts between various database formats

ESF Database Migration Toolkit Professional Editon

11.2.27 download

A simple application, allows you to convert from one database type to another

Openfire for Linux

4.8.1 download

Cross-platform realtime collaboration server based on the XMPP (Jabber) protocol

Copssh

7.13.0 download

Copssh is an OpenSSH server and client implementation for Windows systems

H2 Database Engine

2.2.224 download

Lets you access a database using a browser

Log Monitor Export

5.9.6.306 download

Log Monitor Export - Real-time text log files monitoring with export features!

Smart Alert Pro

1.30.10 download

Take the good old alerts to a new level in SharePoint