SQLyog is a GUI tool for the RDBMSMySQL. It is developed by Webyog, Inc., based in Bangalore, India, and Santa Clara, California. SQLyog is being used by more than 30,000 customers worldwide and has been downloaded more than 2,000,000 times.[2]
SQLyog v0.9 was first released to the public in 2001 after eight months of development. SQLyog was available free of charge, but with closed source code, until v3.0 when it was made a fully commercial software. Nowadays SQLyog is distributed both as free software as well as several paid, proprietary, versions. The free software version is known as Community Edition[3] at GitHub. Paid versions are sold as Professional, Enterprise and Ultimate Editions.[4]
Data manipulations (INSERT, UPDATE, DELETE) may be done from a spreadsheet-like interface. Both raw table data and a result set from a query can be manipulated.
Visual Schema Designer
Visual Query Builder
Query Formatter
Connectivity options: Direct client/server using MySQLAPI (SSL supported), HTTP/HTTPS tunneling, SSH tunneling
Wizard-driven tool for import of data from ODBC-databases
Backup Tool for performing unattended backups. Backups may be compressed and optionally stored as a file-per-table as well as identified with a timestamp.
"SQL Scheduler and Reporting Tool" - a tool for scheduling and automating execution of any sequence of SQL statements. Result of queries may be sent as HTML-formatted reports.
Schema/Structure Synchronization and Data Synchronization
Query Profiler and Redundant Index Finder
All automated jobs have mail alerting and reporting options.
Uses SQLite to store internal data like Grid settings. Consequently, these settings are persistent across sessions on a per-table basis.
Platformsedit
SQLyog works on the Windows platform ranging from Windows Vista[10] to Windows 10. (Windows 9x/ME support was removed in version 5.0, Windows 2000 support stopped with version 8.6, and Windows XP support ended with version 12.5.) It has also been made to work under Linux and various Unixes (including macOS) using the Wine environment.[11] Further, a subset of SQLyog Enterprise/Ultimate 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.[12]
Supportedit
Webyog provides priority support to customers primarily through a ticket based support system.[13] Users of Community Edition can get support through Webyog Forums which has more than 15000 registered users. Webyog also maintains an extensive FAQ[14] for most commonly asked questions.
Comparison Sheet between Community and commercial editions
SQLyog Screenshots
April 15, 2024
sqlyog, this, article, rely, excessively, sources, closely, associated, with, subject, potentially, preventing, article, from, being, verifiable, neutral, please, help, improve, replacing, them, with, more, appropriate, citations, reliable, independent, third,. This article may rely excessively on sources too closely associated with the subject potentially preventing the article from being verifiable and neutral Please help improve it by replacing them with more appropriate citations to reliable independent third party sources December 2014 Learn how and when to remove this template message SQLyog is a GUI tool for the RDBMS MySQL It is developed by Webyog Inc based in Bangalore India and Santa Clara California SQLyog is being used by more than 30 000 customers worldwide and has been downloaded more than 2 000 000 times 2 SQLyogDeveloper s Webyog Inc Stable release13 1 9 1 2022 01 11 Written inC Operating systemMicrosoft WindowsSize11 0MBAvailable inEnglishTypeDatabase administration toolsLicenseProprietary GPL Community Edition Websitehttp webyog com Contents 1 History 2 Features 3 Technical specification 4 Platforms 5 Support 6 See also 7 References 8 External linksHistory editSQLyog v0 9 was first released to the public in 2001 after eight months of development SQLyog was available free of charge but with closed source code until v3 0 when it was made a fully commercial software Nowadays SQLyog is distributed both as free software as well as several paid proprietary versions The free software version is known as Community Edition 3 at GitHub Paid versions are sold as Professional Enterprise and Ultimate Editions 4 Features editProminent features 5 of SQLyog are 64 bit binaries are available from version 11 0 6 Editor with syntax highlighting and various automatic formatting options Intelligent Code Completion Data manipulations INSERT UPDATE DELETE may be done from a spreadsheet like interface Both raw table data and a result set from a query can be manipulated Visual Schema Designer Visual Query Builder Query Formatter Connectivity options Direct client server using MySQL API SSL supported HTTP HTTPS tunneling SSH tunneling Wizard driven tool for import of data from ODBC databases Backup Tool for performing unattended backups Backups may be compressed and optionally stored as a file per table as well as identified with a timestamp SQL Scheduler and Reporting Tool a tool for scheduling and automating execution of any sequence of SQL statements Result of queries may be sent as HTML formatted reports Schema Structure Synchronization and Data Synchronization Query Profiler and Redundant Index Finder All automated jobs have mail alerting and reporting options Full character set Unicode support A Data Search 7 feature using a Google type search syntax translated transparently for user to SQL Form view 8 to display one row at a time Foreign key lookup Visual Data Compare 9 Technical specification editProgrammed and developed in C using Win32 API No dependencies on runtimes NET Java etc Uses MySQL C API to communicate with MySQL servers No dependencies on database abstraction layers like ODBC JDBC Uses SQLite to store internal data like Grid settings Consequently these settings are persistent across sessions on a per table basis Platforms editSQLyog works on the Windows platform ranging from Windows Vista 10 to Windows 10 Windows 9x ME support was removed in version 5 0 Windows 2000 support stopped with version 8 6 and Windows XP support ended with version 12 5 It has also been made to work under Linux and various Unixes including macOS using the Wine environment 11 Further a subset of SQLyog Enterprise Ultimate 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 12 Support editWebyog provides priority support to customers primarily through a ticket based support system 13 Users of Community Edition can get support through Webyog Forums which has more than 15000 registered users Webyog also maintains an extensive FAQ 14 for most commonly asked questions See also editComparison of database toolsReferences edit SQLyog MySQL GUI v13 1 9 Released sqlyog com Retrieved 2021 01 11 Webyog Manage Monitor and Secure Your MySQL Servers www webyog com Retrieved 2019 11 20 SQLyog Community Edition on Github Webyog Github Retrieved 20 June 2016 Online Shop Webyog Retrieved 3 December 2014 Comprehensive Feature List Webyog Retrieved 3 December 2014 MySQL GUI in 64 bit Webyog Archived from the original on 21 February 2013 Retrieved 3 December 2014 MySQL Data Search Webyog Archived from the original on 12 June 2011 Retrieved 3 December 2014 Form View Webyog Archived from the original on 22 November 2010 Retrieved 3 December 2014 Visual Data Compare Webyog Archived from the original on 15 December 2012 Retrieved 3 December 2014 SQLyog MySQL Admin FAQ Installation and Configuration faq webyog com Retrieved 2019 11 20 SQLyog on Wine Webyog Retrieved 3 December 2014 Version History 2017 SQLyog Knowledge Base sqlyogkb webyog com Retrieved 2019 11 20 Contact options Webyog Archived from the original on 31 August 2011 Retrieved 3 December 2014 FAQ Webyog Retrieved 3 December 2014 External links editOfficial Webyog home page Community Edition project page Comparison Sheet between Community and commercial editions SQLyog Screenshots Interview with Rohit Nadhani MySQL AB August 23rd 2006 Retrieved from https en wikipedia org w index php title SQLyog amp oldid 1215089622, wikipedia, wiki, book, books, library,
