SQLyog Community Edition
Publisher's description:
SQLyog Community Edition 8.03
SQLyog is an all-round Management Tool (/'GUI'/'Frontend') for the MySQL database. MySQL versions from 3.23 to 5.1.x are supported. SQLyog provides an efficient and intuitive User Interface for management of MySQL. It is at the same time an easy-to-use tool for beginners and an efficient timesaver for MySQL power users - Developers and DBA's as well.
SQLyog is a mature program that has been in existence for almost 5 years but now (Sept. 2006) released as Open Source under the GPL license. SQLyog 'development rate' is being continously accelerated. SQLyog runs on Windows and Wine (on Linux and other *nix variants where Wine is available). SQLyog has full support for MySQL 5.
Here are some key features of "SQLyog Community Edition":
Nag Screen on startup displaying SQLyog Enterprise features
Complete Unicode/UTF8 Support
Developer / User Productivity
Favorites Manager
HTML Schema Documentation
Shortcuts to generate SQL DML statements from schema definition
Creating/Dropping/Altering tables
Multi-tab Query Editor and Result-set Editor
Multiple Query Execution
Multi-threaded Query execution - Ability to stop long running queries
SQL Templates
Excel-style grid interface to view/update resultsets
Multi-format Blob editor
View data in Grid/Text Mode
ResultSet/Data Export to CSV/XML/HTML/Excel
Full Support from 3.23.38 to the latest 5.x
Support for all MySQL table handlers
Excel friendly resultsets/table-data export to clipboard/file
Dialog-less table and resultset editor
DBA Productivity
Restoring / Importing large SQL dumps
MySQL 5.x objects support
User Management
Managing hosted MySQL
Connection Manager
Index Management
Relationship/Foreign Key Manager
Reorder Columns
Copy objects to another Host with single click
Table diagnostics
Flush Tools
Object Browser
Creating/dropping database
Optimized for managing Hosted MySQL
Multiple database connections
Technology
Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way to communicate with MySQL server
100% keyboard friendly
Small compact binary
Minimal use of Registry - easy migration of User Preferences by dragging and dropping config files.
Non-cluttered look and feel, ability to show/hide panes
You can
free download SQLyog Community Edition 8.03 now.
What's New in This Release:
Bug fixes:
Schema Sync did not distinguish default NULL and default (empty string) for string types.
When multiple connections were open in one program instance and one connection was in wait-state (for instance due to a TABLE LOCK), the whole program could become non-responding.
If a server thread running a query sent by SQLyog was killed, SQLyog would not always detect it. The connection window associated with that thread would then stay in wait-state forever. Due to the ???multiple connections issue as described just above also the whole program could be affected.
With MySQL servers 4.0 and before and when connecting with HTTP-tunnel, SQLyog could send an invalid SET SQL_MODE statement when copying large amounts of data. The copy operation would then abort. This bug was introduced in 7.12.
Reconnecting while populating Object Browser could crash SQLyog.
Fixed 2 rare crashes in Schema Sync and DATA tab (reported internally).
Fixed a bug with replace in editor. replace took effect *after* cursor position not *from* cursor position, so if cursor was positioned inside the string to be replaced that particular instance would not replace.
Refreshing the GRID moved the cursor to home position.
Fixed a bug in Autocomplete transaction handling (introduced in 7.13) that could cause a crash at statup.
Migration Tool could fail to find rows when migrating from SQL server 2008.
System Requirements:
No special requirements.
-
Download SQLyog Community Edition 8.03 free