SQLyog Wiki

	SQLyog wiki
Category Business Databases & Tools

From Software Informer

Jump to: navigation, search

SQLyog
Developed by	Webyog Softworks Pvt. Ltd.
Latest release	7.15 / 6 January 2009
Written in	C%2B%2B
Operating system	Microsoft Windows
Size	8MB
Available in	English
Development status	Active
Type	RDBMS
License	GPL
Website	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 Webyog, based in Bangalore, India.

1 History
2 Current Version (February 2009)
3 Features
- 3.1 Technical Specification
- 3.2 Platforms
4 Support
5 References
6 See also

[edit] 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)

[edit] Current Version (February 2009)

Current version of SQLyog Enterprise is 8.x.

[edit] 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 ^[1]
Fully unicode support.

[edit] Technical Specification

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

[edit] 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 various Unix's (including Mac OS X) using the 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.

[edit] Support

Webyog provides priority support to Enterprise customers through their ticket based support system. Users of community edition can get support through 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 FAQ for most commonly asked questions.