Sync Database MySQL Edition

Software that allows you to compare and synchronize MySQL databases
Download

Sync Database MySQL Edition Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Free to try
  • Language:
  • English
  • Price:
  • $149.00
  • Publisher Name:
  • Spectral Core | metadata d.o.o. | more software
  • Operating Systems:
  • Windows
  • File Size:
  • 5.62MB

Sync Database MySQL Edition Tags


Sync Database MySQL Edition Description

Sync Database is an easy solution to synchronize schema of mySQL databases. When you alter database, add or change columns, indices or constraints, sync is done in an quick and painless process and enables you to change the structure of your older database to its newest version while preserving its data. · Select source database or load an SQL script. · Select target database (you can also create it using builtin script editor) · Press Synchronize synchronizes column, index, constraint information. Conversion between table types is supported, as well as transactions. Typical Sync Database use: A software developer constantly tweaks application and database design. When a new version is is released, you have to apply changes to your customers' existing database so new code can work for them, too. If you have a clients with one version and release a new one, you have to run a script to the underlying database. If you have 5 different versions spread, you need to have 5 different scripts or apply a difference scripts from version 1 to 2, from 2 to 3 etc. Why not going the simpler way? Using this efficient standalone app (all is contained in a single executable), you can be assured that sync will be done quickly and easily. No need to remember your versions. You provide the latest (reference) SQL script or database, choose your target, and run. The process is done in seconds! Performance The process is typically done in few seconds, and in only a few minutes on several hundred tables databases with many differences. Safety The reference database is not touched at all. Target database data is left intact. Only work database structure is changed, so you need not worry about losing or corrupting your data. Of course, if your reference database column is shorter than your work database column, you might trim your work data. SQL Dump Script support You can even compare and synchronize target database to reference SQL scripts defining reference database structure. So you don't need to have physical connection to reference server. Make a database dump (only of structure, so the file stays small) and take only one file with you. Main features: Full support for MySQL 5 Command-line support Synchronization of columns, indexes, constraints, views, stored procedures and functions Built-in difference viewer Built-in color-coded SQL script editor Synchronization between different servers supported Saving of settings and generated SQL scripts to files Detection of changed table types


Sync Database MySQL Edition Related Software