Smart Suite for MySQL 6.12.05

Smart Suite for MySQL 6.12.05 offers an effective tool which helps you to compare, synchronize, navigate and backup SQL databases manually. Smart Suite for MySQL includes: Backup Watcher for MySQL (for database backup), SQLBalance for MySQL (for synchronization database structure and data) and SQLNavigator for MySQL (for database navigation). One click and your databases are synched, viewed or backed up.

Backup Watcher for MySQL is very flexible, allows you to back up your data locally (to a PC’s hard-drive ), remotely (to a server via TCP/IP,even if your data is behind a firewall) or to removable storage media (floppies, flash drives, CDs, etc.) The program has a profile wizard, which allows you to create multiple backup profiles, so you may perform “minor” daily backups, while doing total database backup only once a week or month. There is also a data compression option to conserve disk space, which is no small thing, when your database contains millions of entries. The program supports multiple languages and can be used as a database transfer tool.

SQLBalance for MySQL is a powerful and extremely useful utility for DBA. It allows to compare and synchronize the structure of different databases, controlled by MySQL server and even more! You can also balance the structure of ANY database (through ODBC) with a database of MySQL type. Databases, located on different servers can be easily compared by means of SQL Balance for MySQL. It is also possible to save the database structure into the file and then compare it with the online database.

SQLNavigator for MySQL was developed for the work with any database objects (such as tables, triggers, procedures and functions). You can create them (using buit-in Wizards), edit and delete. This program allows to view data of the tables of any size and to change the rights of the MySQL server users.

Major Features:

1. SQLNavigator for MySQL
   • Work with MySQL server:
   • • compatible with MySQL servers of the versions from 3.23 to 5.0.18
     • views support
     • triggers support
     • procedures and functions support
     • MySQL 4.x User Privileges Extensions
     • Charsets and collations support for databases and tables.
   • User interface:
   • • Office 11 in Windows XP support, visual schemes support
     • convenient system of Wizards for the work with database objects
     • a panel, which allows to switch between MDI windows with one click.
   • Database explorer:
   • • access to any database object with one click on the corresponding tree entry
     • simultaneous work with several database objects.
   • Work with data:
   • • data sorting
     • data filtering (by one or several table columns)
     • browsing tables with great data volume.
2. SQLBalance for MySQL
   • Comparing databases on one or different servers
   • Synchronous navigation between the database objects with corresponding scripts displaying
   • Synchronous navigation between the database objects with displaying of the script, which will remove the differences
   • Compares the rows of two chosen tables or of the query and table
   • A possibility of executing scripts, which remove differences object by object or all the differences at once
   • A possibility of editing scripts and changing the order of their execution
   • Creates a database with specified parameters
   • A built-in SQL Script Editor with syntax highlighted
   • Adjustable and easy-to-use interface
   • A wide variety of variants for interface adjustment
3. Backup Watcher for MySQL
   • Make database backups of the MySQL server.
   • Using the remote server in the Internet.
   • Include the built–in and easily customized scheduler:  automatically make the backup of the specified databases daily, weekly, monthly or once on the established time.
   • Archive backup files after carrying out the backup.
   • Reduce considerably the place on a hard disk, occupied by these files. Archiving can be carried out with the help of any external archive program, which is available (RAR, ZIP, ARJ and so on).
   • Restore of the database to the condition, which was at the moment of the carrying out of backup.

Enhancements: Added the support of MySQL 5.1

Requirements:

• Win32
• MySQL