SQLyog

Infobox Software
name = SQLyog



caption =
collapsible =
author =
developer = Webyog Softworks Pvt. Ltd.
released =
latest release version = 6.5
latest release date = 1 April 2008
latest preview version =
latest preview date =
frequently updated =
programming language = C%2B%2B
operating system = Microsoft Windows
platform =
size = 8MB
language = English
status = Active
genre = RDBMS
license = GPL
website = [http://webyog.com/en/ webyog.com]

SQLyog is a Graphical User Interface (GUI) tool for the popular Relational Database Management System (RDBMS) MySQL. The software is created by the software development company [http://webyog.com/en/about_webyog.php Webyog] , based in Bangalore, India.

__TOC__

History

SQLyog v0.9 was first released for public in the year 2001 as a closed source free software after 8 months of development. SQLyog was a free software until v3.0 when it was made a commercial software.

Starting from v5.0, SQLyog is now available in two editions: Enterprise and Free Community Edition.

From version 5.2 Community Edition has been available as Open Source (GPL license)

Current Version (August 2008)

Current version of SQLyog Enterprise is 7.x.

Features

Prominent features of SQLyog are:

* Visual Schema Designer
* Visual Query Builder
* Smart Autocomplete
* Intelligent Code Completion
* HTTP/HTTPs Tunneling
* SSH Tunneling
* SSL Connections
* Wizard driven Migration Tool
* Data/Structure Synchronization [ [http://webyog.com/en/sqlyog_feature_matrix.php Complete Feature List] , "Webyog"]
* Fully unicode support.

Program specifications

Technical Specification

* Developed using Win32 API
* Uses MySQL C API to communicate with MySQL servers
* Uses Sqlite to store all internal data

Platforms

SQLyog works on the Windows platform starting from Windows 2000 to Windows Vista/Server 2008 (Windows 9x/ME/NT4 support was removed in version 5.0 because of lack of unicode support in those early Windows versions). It has also been made to work under Linux and variousUnix's (including Mac OS-X) using WINE environment. Further a subset of SQLyog Enterprise functionalities are available with the free SJA (SQLyog Job Agent) for Linux as a native Linux utility. This makes it possible to specify and test 'scheduled jobs' on a Windows environment and port execution parameters seamlessly to a Linux environment.

Support

Webyog provides priority support to Enterprise customers through their ticket based support system. Users of community edition can get support through [http://www.webyog.com/forums Webyog Forums] which has more than 5000 registered users. Core SQLyog developers also respond to queries asked in the forums.

Webyog also maintains an extensive [http://www.webyog.com/faq FAQ] for most commonly asked questions.

References

External links

* [http://webyog.com/en/ Official Webyog home page] Official Webyog home page.
* [http://www.webyog.com/en/whitepapers/MONyogWhitePaper.pdf MONyog - Monitoring and Advisory Tool for MySQL] MySQL Monitoring and Advisory Tool from Webyog
* [http://webyog.com/en/sqlyog_feature_matrix.php Comparison Sheet between Community and Enterprise Edition]
* [http://webyog.com/en/screenshots.php Screenshots]
* [http://www.weberdev.com/ViewArticle/352 Managing Foreign Key Relationships]
* [http://www.sitepoint.com/article/mysql-data-sqlyog-job-agent Synchronize MySQL Data Using SQLyog Job Agent]
* [http://code.google.com/p/sqlyog/ Community Edition project page]
* [http://dev.mysql.com/tech-resources/interviews/rohit-nadhani-webyog.html Interview with Rohit Nadhani, "MySQL AB", August 23rd, 2006]