Screenshot Preview

SQLyog - Summary

by Webyog - Product Type: Application

Summary

SQLyog by Webyog

URLs: sqlyog, webyog

MySQL manager and admin tool. SQLyog MySQL GUI is a MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools in a single intuitive interface. SQLyog is an easy to use, compact and very fast graphical tool for managing your MySQL databases. SQLyog was developed for all who use MySQL as their preferred RDBMS. Whether you enjoy the control of handwritten SQL or prefer to work in a visual environment, SQLyog makes it easy for you get started and provides you with tools to enhance your MySQL experience.

SQLyog provides you with powerful means to manage your MySQL databases.

Runs on all Windows versions from 98SE to Vista. Runs on Linux with WINE.

MySQL 5.x compatible

Create/Drop/Alter Tables, Stored Procedures, Functions, Views, Triggers and Events.

HTTP and SSH Tunneling - smartly manage your MySQL server even if the MySQL port is blocked or remote access to MySQL is disallowed!

Protect your data with SSL encryption

Smart AutoComplete

Formats SQL statements

Proactive Query Profiler

Favorite Manager to neatly organize your favorite SQL statements

Very fast retrieval of data

Advanced GUI Query Builder. Supports JOINs, aggregate as well as 'common' functions, sorting (ORDER BY) and filtering (WHERE and HAVING) and ALIAS.

SQLyog Migration Toolkit - use the GUI or specify a query

Schema and Data synchronization tools

Powerful Scheduled Backup with email notification

Schedule various jobs

Notification Services - execute unattended queries for database maintainence of data verification with flexible email option

Update result returned from query - also supports queries with JOINs. No dialogues - just edit

Manage foreign key relationships

Fully InnoDB compliant

Supports MySQL pluggable storage engines architecture

Multi-threaded query execution with option to allow multiple query execution simultaneously

View your results in GRID/TEXT mode

Filter data and resultsets directly form the context menu of a displayed value

Execute (very large) SQL-scripts as batch files

Execute multiple queries returning more than 1000s of rows per resultset. Its very efficient in memory.

Very compact binary

Written entirely in C/C++/Win32 APIs using native MySQL C APIs. No wrapper classes used.

Connection manager

Excel like grid interface to create/alter tables

View and edit advanced table-properties, such as Comment, Key_Length etc.

Do table-diagnostics (check, optimize, repair, analyze)

Duplicate tables to new table-names

Excel like grid interface to edit data with support for Enum/Set

Create/drop databases

Manage indexes

Comprehensive user/security manager. Control every available privilege on what level you like (server/database/table/column).

Reorder columns of table

Copy database between two MySQL hosts

Drop all tables of a database with a single click

Edit BLOBs in TEXT or GRAPICHS mode. All common (non-proprioritary) graphics format (including 'high-resolution' TIFFs and PNGs) supported.

Export table-structure and data into SQL-dumps

Direct export to Microsoft Excel

Export/import data in/from CSV files

Export database schema in HTML

Log all queries for a session

Syntax-highlighting

Save resultset in CSV, HTML and XML

Copy your result as CSV to clipboard

Is very keyboard friendly. You can work with 99% features of SQLyog with keyboard.

View and kill other user-processes

Flush Host/Logs/Privileges/Tables

Quick access to processlist, status, variables etc.

And a lot more...

SQLyog gives you a choice between four different connectivity options. No matter whatever your firewall/proxy/ISP settings are, you should be able to smartly manage your MySQL Server(s). The various connectivity options (in the order of responsiveness and network efficiency) are:

Direct connection using MySQL C API: This is by far the fastest way to connect and manage your MySQL server. This is the preferred method if you are not concerned about your MySQL traffic being spoofed. However, this requires direct access to your MySQL server. Most ISPs block the MySQL port or disallow remote access.

SSH Tunneling *: Use this option if you need to encrypt the contents of your MySQL traffic, but still want the efficiency of the MySQL C API. If your host supports SSH tunneling, SQLyog can use the tunnel to communicate with MySQL.

HTTP Tunneling *: This option saves your day if your ISP/MySQL provider disallows remote access, either my blocking the MySQL port or by giving access to “localhost” only. The response is slow compared to the previous options since the data is XML encoded and HTTP is stateless by nature. However, you can use all the cool features of SQLyog (and start getting more sleep!).

HTTPS Tunneling *: This option is similar to HTTP Tunneling but adds another layer of security by establishing a secure channel. *

SSL Encryption *: With this option all communication between SQLyog and the MySQL server is encrypted. The MySQL server must support this option. Not all servers do

Favorites

SQLyog allows easy access to frequently used SQL scripts. The script files can be stored as files from the SQLyog interface or you can link to an existing file anywhere where windows can access it - on a local drive or a shared network drive. The SQL scripts and the file links can be organized in folder and subfolders. The number of script files and file links and the number of nested folders you can manage is limited by an Operating System and the File System only.

Object Browser

The Object browser window gives you complete details of the server you are connected to in a tree format. Expanding database nodes will show the table(s), view(s), store procedure(s), function(s), trigger(s) and event(s) in the database and expanding the table name node will show the columns and indexes available for the table. When you right click on any object in the Object Browser, you will get a context sensitive popup menu. The options in the popup menu allow you to perform different operations on the selected object such as Open Table, Create Table, Alter Table, Manage Indexes, Relationships/Foreign Keys, Backup/Export, Import and more.

Database Synchronization

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

SJA can also be used as 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. If you use SQLyog to create your job files, you don't need to have any knowledge about XML or the Job Definition schema.

SJA does not require any installation at hosts running the MySQL server. You can use any host to run the SJA. For example - you can use SJA to keep your production database (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.

Compare between the editions of SQLyog MySQL Visual Editor

The following table shows the features included in the different editions of SQLyog.

EditionsUltimateEnterpriseProfessional

Features:

Core Features (See list below)•••

Optimizing Tools

Redundant Index Analyzer New!•--

Schema Optimizer•--

Query Profiling Tools

Query Profiler•--

Advanced Connectivity Options

HTTP/HTTPs Tunneling•••

SSH Tunneling•••

SSL Connections•••

Visual Tools

SQL Formatter••-

Visual Query Builder••-

Visual Schema Designer••-

Enhanced Services

Priority access to BETAs, new versions and patches•••

Installation support for 1 month•••

Unlimited Priority Support (Optional)•••

Enhanced Productivity

Smart Autocomplete•••

Intelligent Code Completion•••

Migration Tools

Wizard Driven Migration Toolkit••-

Import tasks can be scheduled••-

Synchronization Tools

Schema Synchronization••-

Data Synchronization••-

Data Synchronization can be scheduled••-

Other Power Tools

Compressed Scheduled Backups New!••-

Notification Services••-

Job Manager••-

SQLyog Core Features:

Internationalization

Complete Unicode/UTF8 Support

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

Table duplication with two clicks

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

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

MySQL manager and admin tool.

Pricing: SQLyog v11.5.1 Professional with Premium Support Single User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Professional with Premium Support 5 User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Professional with Premium Support Unlimited User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Enterprise with Premium Support Single User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Enterprise with Premium Support 5 User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Enterprise with Premium Support Unlimited User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Ultimate with Premium Support Single User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Ultimate with Premium Support 5 User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Ultimate with Premium Support Unlimited User License - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog v11.5.1 Professional without Premium Support Single User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Professional without Premium Support 5 User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Professional without Premium Support Unlimited User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Enterprise without Premium Support Single User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Enterprise without Premium Support 5 User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Enterprise without Premium Support Unlimited User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Ultimate without Premium Support Single User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Ultimate without Premium Support 5 User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog v11.5.1 Ultimate without Premium Support Unlimited User License - includes 1 year of free upgrades (both minor and major) and 1 month installation support, SQLyog Professional Premium Support and Upgrade Renewal Single User Premium Support and Upgrade Renewal - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog Professional Premium Support and Upgrade Renewal 5 User Premium Support and Upgrade Renewal - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog Professional Premium Support and Upgrade Renewal Unlimited User Premium Support and Upgrade Renewal - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog Enterprise Premium Support and Upgrade Renewal Single User Premium Support and Upgrade Renewal - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog Enterprise Premium Support and Upgrade Renewal 5 User Premium Support and Upgrade Renewal - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog Enterprise Premium Support and Upgrade Renewal Unlimited User Premium Support and Upgrade Renewal - includes 1 year of free upgrades (both minor and major) and Premium Support, SQLyog Ultimate Premium Support and Upgrade Renewal Single User Premium Support and Upgrade Renewal - includes 1 year of free upgrades (both minor and

Evals & Downloads: Read the SQLyog help file, Download the SQLyog v11.5.1 32-bit evaluation on to your computer - Expires after 30 days, Download the SQLyog v11.5.1 64-bit evaluation on to your computer - Expires after 30 days

Operating System for Deployment: Windows Server 2008, Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit, 64Bit

Product Type: Application

Compatible Containers: MySQL 5.0

Keywords: convert sql server to mysql, convert ms sql to mysql, convert mssql to mysql

Webyog Softworks

Database DB Management

Part numbers: PC-516270-715579 516270-715579 PC-516270-715593 516270-715593 PC-516270-715595 516270-715595 PC-516270-715597 516270-715597 PC-516270-715599 516270-715599 PC-516270-715601 516270-715601 PC-516270-715603 516270-715603 PC-516270-715605 516270-715605 PC-516270-715607 516270-715607 PC-516270-715573 516270-715573 PC-516270-715575 516270-715575 PC-516270-715577 516270-715577 PC-516270-715581 516270-715581 PC-516270-715583 516270-715583 PC-516270-715585 516270-715585 PC-516270-715587 516270-715587 PC-516270-715589 516270-715589 PC-516270-715591 516270-715591 PC-516270-715609 516270-715609 PC-516270-715611 516270-715611 PC-516270-715613 516270-715613 PC-516270-715615 516270-715615 PC-516270-715617 516270-715617 PC-516270-715619 516270-715619 PC-516270-715621 516270-715621 PC-516270-715623 516270-715623 PC-516270-715625 516270-715625 PC-516270-715627 516270-715627 PC-516270-715628 516270-715628 PC-516270-715629 516270-715629 PC-516270-715630 516270-715630 PC-516270-715631 516270-715631 PC-516270-715632 516270-715632 PC-516270-715633 516270-715633 PC-516270-715634 516270-715634 PC-516270-715635 516270-715635

Product Search

Enter search words:

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Award