SQLBalance for MySQL 2.0.17

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[!] An important remark
[+] Innovation
[-] Corrected mistake
[*] Changes
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Version 2.0.17
[-] The program is adjusted for the work with OS Microsoft Vista SP1.

Version 2.0.16
[*] The program was successfully tested on the server 5.1.23
[-] Some minor bugs were fixed.

Version 2.0.15
[*] The program was successfully tested on the server 6.0.1
[-] Some minor bugs were fixed.

Version 2.0.14
[*] Parsing speed extremly emproved
[-] Some minor bugs were fixed.

Version 2.0.13
[+] The program was successfully tested on the server 6.0.0
[-] Some minor bugs were fixed.

Version 2.0.12
[+] The program was successfully tested on the server 5.1.22
[-] Some minor bugs were fixed.

Version 2.0.11
[+] The program was successfully tested on the server 5.1.21
[-] Some minor bugs were fixed.

Version 2.0.10
[+] The program was successfully tested on the server 5.0.45
[-] Some minor bugs were fixed.

Version 2.0.8
[+] The program was successfully tested on the server 5.1.18
[-] Some minor bugs were fixed.

Version 2.0.7
[+] The program was successfully tested on the server 5.0.41
[-] Some minor bugs were fixed.

Version 2.0.6
[+] The program was successfully tested on the server 5.0.37
[-] Some minor bugs were fixed.

Version 2.0.5
[+] Comparison mechanism was changed. Now you can created DLL scripts, considering:
- the order of fields;
- the order of indexes;
- indexes names.

Version 2.0.4
[-] The mistake, which appeared when using DEFAULT values, containing the " (inverted commas) sign, was successfully fixed.
[+] Table Data Comparer settings can now be saved into the profile, which allows to restore them easily, when needed.
[*] New keywords were added for syntax highlighting.
[*] Now you can enjoy the proper display of comments.
[-] Some minor bugs were fixed.
[-] The mistake, which appeared while proceeding to the second step of the wizard (SQLNavigator 1.3.1), was successfully fixed.

Version 2.0.3
[-] The mistake, which appeared when using DEFAULT values, containing the " (inverted commas) sign, was successfully fixed.
[+] A possibility of correct comparison for the default and default '' definitions was added.
[+] Now, while comparing tables, not only the set of fields is taken into consideration, but their sequence as well.
[-] The bug of foreign keys parsing was successfully fixed.
[+] A new possibility was added: now you can clear or reset MySQL inner storages using the FLUSH command (SQLNavigator 1.3.0).
[+] Now it is possible to ping selected MySQL servers (SQLNavigator 1.3.0).
[+] A possibility of viewing the list of MySQL server variables and processes was added (SQLNavigator 1.3.0).
[+] Now it is also possible to manage MySQL server services (SQLNavigator 1.3.0).
[+] Now you can analyse, optimize, check and repair tables of the MySQL server database (SQLNavigator 1.3.0).

Version 2.0.2
[-] The mistake, which appeared when using DEFAULT values, containing the " (inverted commas) sign, was successfully fixed.
[-] The mistake of loading saved snapshots was successfully corrected.
[-] We corrected the mistake of comparing table structures of MySQL versions 4.x.x and 5.x.x in fields, containing NOT NULL feature.
[+] This version of the program was successfully tested on MySQL 5.0.24 and MySQL 5.1.11-beta.

Version 2.0.1
[-] We had corrected the mistake, which appeared while comparing tables from different servers and with different MySQL versions (4 and 5).
[-] NON-unique fields processing (in MySQL servers 4.х) now works properly.
[-] The bug on tab "Modify Scripts (All)" was fixed. Tables modifications, when the changes were made to indexes and fields of the modified table, were not displayed correctly.
[-] The mistake, which appeared at generating DDL scripts and EVENTS-objects, was successfully corrected.

Version 2.0.0
[*] The mechanism of Master and Target databases comparison was fully rewritten. Thus, the speed of information processing was increased and the RAM requirements were reduced.
[+] The program was successfully tested on the MySQL servers 5.0 and 5.1
[+] Added the support of EVENTS (for the MySQL server 5.1).
[+] Added the support of data integrity. Now the result script is created considering data integrity.
[+] Added new interface "Show Structure DB".
[*] Snapshot file format changed.
[*] Changed the format of the file "Project Options".
[-] The mistake of displaying DDL scripts, procedures and functions was successfully corrected.

Version 1.7.5
[+] Now the program works with FOREIGN KEY.
[+] The program was successfully tested on MySQL server 5.0.19

Version 1.7.4
[+] Added a new property of the project "Client Charset". It allows to correctly write the string data into the result script (during data comparison on the tables level), even if data have the encoding, different from "latin1".
[+] The program was successfully tested on the server 5.0.18.

Version 1.7.3
[+] Now you can print SQL-scripts with a possibility of Print Preview.
[+] The program works witn MySQL server 5.0.17.

Version 1.7.0
[+] Now the program works witn MySQL server 5.0 triggers.
[+] The program works witn MySQL server 5.0.16.

Version 1.6.0
[+] Added support of the MySQL server 5.0 procedures and functions.

Version 1.5.0
[+] Now available "view" support (realized starting with version 5.0.2)

Version 1.4.1
[+] The program works now with MySQL servers v.5.0.x

Version 1.4.0
[+] Starting with version 1.4.0 SQLBalance can compare not only database structures, but also data of any two chosen tables. Besides, the program makes it possible to compare the query (which may contain any union of Master database tables) and a table from the Target Database.

Version 1.3.1
[-] Corrected the mistake, which appeared when there were spaces in the table name.
[-] Corrected the mistake, which appeared when the table fields names contained spaces.

Version 1.3.0
[+] Now you can balance the structure of any database type (through ODBC) with the database of the MySQL typeAdded the support of the MySQL - server v.4.1.x
[+] LTEditor utility was added. Allows to transform data types of the certain server according to MySQL standard
[*] Program interface improved

Version 1.2.0
[+] Added the support of the MySQL - server v.4.1.x
[+] Now it is possible to save the database structure into the file.
[+] Now it is possible to restore the database structure from the file.
[+] Added the possibility to compare the structute of the database from file
with online database.
[+] Program interface was improved

Version 1.1.0
[+] The following features were added for the work with SQL-editor:
- work with a block;
- work with clipboard;
- search;
- replacement;
- tabs.
[*] Syntax highlighting was improved according to the words, reserved in
MySQL.
[+] A possibility to save user's SQL-scripts into the file was added.
[+] A new chapter "Editor Options" was added. It includes:
- Editor options;
- Display options;
- Color options.

Version 1.0.0
[+] The first version of the program.

---