SQLyog Enterprise The leading MySQL GUI for the last 5 years. Industrial strength C++ code. Uses MySQL C APIs - the fastest way to access MySQL.

SQLyog Enterprise
vendor: WEByog

Priority access to BETAs, new versions and patches
Unlimited "ticket-based" support for one year
Includes many additional tools like:
         Smart Autocomplete, Intelligent Code Completion
         Powerful Migration Toolkit, Get external data at scheduled intervals
         Manage hosted MySQL over SSH, HTTP, HTTPS tunnels
         Scheduled Data Synchronization, Both 1-way and 2-way sync supported
         Side by side visual Schema Comparison, Auto DDL generation for syncing
         Wizard Driven Scheduled Backups
         Notification Services, Job Scheduler
         and much more!
1 year of free upgrades and Maintenance
90-day Unconditional Money Back Guarantee

SQLyog Migration Toolkit

SQLyog Migration Toolkit allows you to import data, table structure, indexes, foreign keys, constraints from any ODBC compliant data source like Oracle, SQL Server, Access, DB2, CSV, Excel, Sybase, etc into MySQL. The import session can be saved in a XML configuration file. This configuration can then be executed repeatedly using SQLyog Job Agent (SJA). You can also schedule the job at regular intervals.

As usual, all SQLyog Enterprise features are optimized for SSH/HTTP tunneling. This means that you can upload a MS Access database or any other ODBC compliant database to your hosted MySQL server at regular intervals. This is possible even if your hosting provides disallows remote access (or allows access only through a web based tool like phpMyAdmin).

Powerful features such as the ability to fire row level triggers on the source upon successful import, email notifications for import status, etc give you unprecedented flexibility in your import tasks. For example, you can have a column in each table that indicates whether your data got successfully uploaded to MySQL. You can then configure to update this column with a value when a row is successfully uploaded in MySQL.

All of these mean that you can now use MySQL in conjunction with your existing proprietary databases and configure SQLyog Enterprise to transfer data at regular intervals. All your reporting tasks can be executed on the MySQL server leveraging on the low cost and high speed that MySQL offers.

SQLyog Enterprise has been tested successfully on datasets containing hundreds of columns and millions of rows making it the most cost effective solution for one time migration or regular transfer of data into MySQL. Unlike other tools in the market, SQLyog Enterprise uses MySQL C API and ODBC C APIs that give you raw speed.

The wizard driven interfaces are plain and simple. Go ahead, give it a try! You will be pleasantly surprised by its ease of use and POWER.

Manage hosted MySQL over SSH, HTTP, HTTPS tunnels

Does the responsiveness of your web-based MySQL admin tool decrease your efficiency? Or does it make you sleep-deprived!?
If yes, read on.

The reason is that most ISPs block the MySQL port or prevent remote connections to MySQL. They probably have their reasons to do so where hundreds or thousand of users (of which not everyone cares or undestands about security) share the same server. The only option is to manage MySQL with a web-based application running on the server. Thus you are forced to live with the annoying page-refreshes for every small operation!

SQLyog changes the rules of the game. Just by uploading a single PHP page to your web server, you can use all the cool features of SQLyog. The PHP page exposes the MySQL API as a set of web-services that can be consumed by SQLyog. This setup does not violate any reasonable security corncern that the ISP may have on behalf on their users. In this respect it makes no difference if the PHP-script connecting to MySQL is phpMyAdmin or it is the SQLyog Tunneller-script. Security is the same. However, efficiency is high, because with SQLyog, only data gets transferred without any graphics and GUI-elements.

Once you are connected over HTTP / HTTPs tunnel, you will not feel the limitations of a web-based application. Work with your local files, take backups on your local drive. Be Free!

Scheduled Data Synchronization

SQLyog Job Agent (SJA) is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts.

SJA does not require any installation at hosts running the MySQL server. You can use any host to run the SJA. You can use SJA to keep your production databases (probably hosted with an ISP) in complete sync with your test database located in your PC or LAN.

SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore, only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.

You can configure SJA for One Way or Two Way synchronization. In one way synchronization, no modification is done in the source database. Two way synchronization allows you to transfer data from the source to the target and vice-versa.

Additionally, you can configure SJA to detect changes only for specific rows and columns. For example, you can exclude blob columns or include only those rows that fulfill a WHERE clause. This makes it an ideal tool to sync data even if there is limited bandwidth.

SJA is a command line tool that accepts a Job Definition file encoded in XML as one of the parameters. You can either create the Job Definition file manually or use one of the wizards included with SQLyog Enterprise. If you use SQLyog Enterprise to create your job files, you don’t need to have any knowledge about XML or the Job Definition schema.

On Windows platforms, SQLyog uses the Task Scheduler services to schedule your jobs. On Linux, you can use cron to schedule jobs.

SQLyog Enterprise The leading MySQL GUI for the last 5 years. Industrial strength C++ code. Uses MySQL C APIs - the fastest way to access MySQL. Product licence price Buy online SQLyog Enterprise - Single Client 67,00 USD Purchase