dbForge Studio for MySQL 7.2

Advertising
Software information
Platform:
Windows 7/Vista/XP/2000/Server
Publisher:
Devart
Price:
$119.95
File size:
25.07 Mb
Date added:
July 25, 2014
Screenshot:
Product page:
Description from the Publisher

The Best MySQL GUI Tool You Can Find

dbForge Studio is a universal MySQL client for Windows that enables MySQL developers and administrators to create and execute queries, develop and debug MySQL routines, automate MySQL database object management in the convenient environment, and many others.

This MySQL frontend GUI tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data. Over 15,000 users rely on dbForge Studio for MySQL to manage, maintain, and monitor their MySQL databases.

dbForge Studio for MySQL works with any MariaDB database servers, and supports all MariaDB objects types. You can visually design database structures, execute SQL queries and scripts, and manage MariaDB users and their privileges.

Intelligent SQL Coding

Intelligent code completion, formatting, code snippets bring convenience and effectiveness to your SQL code writing. Code navigation, obtaining quick object information, and syntax check are performed instantly.

Database Compare and Sync

When modifying MySQL database structure, transferring data between servers, analyzing differences between databases, you will:

  • Compare and sync data and schemas
  • Schedule regular database sync tasks
  • Generate comparison report

Visual Query Builder

Visual query creation with diagram and expression editor. Queries of any complexity can be created in several seconds. The GUI tool automatically adds joins between tables and allows working with INSERT, UPDATE, DELETE statements.

Database Designer

Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your MySQL databases and for:

  • Viewing foreign key relations
  • Displaying DB objects with properties
  • Execution of stored routines

Import/Export Data

Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. Templates, automating data import and data export tasks through command line are also available.

Database Backup

Dump databases in SQL format and schedule regular MySQL database backups. Use 5 levels of file compression and wide set of options to fine-tune backups. Save your settings and connections as a project for the next time or to use in the command line.

Database Administration

Tools for MySQL database administration and management include means for:

  • Managing user privileges
  • MySQL service control
  • Managing server variables
  • Table maintenance
  • Managing server sessions

MySQL Debugger

The first debugger for MySQL that offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of MySQL stored routines and triggers and keeps MySQL server's logic of procedure execution.

Table Designer

Visual designer for modifying or creating table structure and indexes. Get full control over the changes you have made, the heuristics feature will suggest the column type on creating a column basing on the name you enter.

Database Refactoring

Improve MySQL database design by applying small changes. When such changes are performed, they are fully transparent and application takes care of all dependencies in the database:

  • Renaming database objects with preview
  • Refactoring script

Query Profiler

Improve multi-second queries using Query Profiler. The tool helps you detect problems and optimize SQL queries via GUI. Profiler:

  • Offers visual query profiling
  • Compares profiling results

Report and Analysis

Data reporting is performed using wizard with rich feature set, manually, or via command line. Ready reports can be imported to 9 formats and delivered to their recipients.

Group and summarize your data in pivot tables to make it easier to read and understand.

Features

MySQL Connectivity

  • Support of Sphinx and Percona
  • Support of all MySQL server versions 3.23-5.x
  • Support of MariaDB
  • Secure connections via SSL/SSH
  • HTTP connections via PHP tunnel
  • Support of UTF-8 databases
  • Work with MySQL embedded server
  • Direct access to MySQL server without client libraries
  • Support of MySQL pluggable authentication when creating connection to MySQL server (PAM)
  • Support of Windows authentication when creating connection to MySQL server
  • Working with MySQL on Amazon RDS

Administration and Maintenance

  • Comprehensive Security Manager to administer user accounts and privileges
  • Session manager for monitoring active MySQL server connections
  • Service control for starting and stopping MySQL servers
  • Table maintenance wizard for check, analysis, repair, and optimization of tables
  • Server Variables window
  • Server objects flush dialog

Data Analysis

  • Master-detail data browser
  • Data report generation wizard
  • Data report designer
  • Pivot table designer
  • Chart building wizard
  • Data search on a live database
  • Automatic data report generation and delivery to the requested destination

Data Comparison and Sync

  • Comparing and synchronizing data in databases of any size
  • Optional view comparison
  • Custom comparison keys support
  • Option for BLOB data comparison
  • Comparison results filtering
  • Data synchronization script generation
  • Per record viewing of data differences
  • Exclude tables and records from synchronization
  • Saving and loading of comparison settings
  • Command line interface for data comparison and synchronization
  • Generating accurate comparison reports in HTML and Excel formats
  • Comparison of custom query results (along with tables and views)
  • Possibility to include objects into comparison by mask, which is useful when comparing groups of tables

Data Editor

  • Asynchronous data fetch with ability to cancel the operation
  • Batch table update mode when changes are accumulated and applied explicitly
  • Copying data with column headers for quick paste to spreadsheet
  • Custom data filters of any complexity
  • Data Viewer window for browsing images, rtf, and binary cell values
  • Date time editor with visual interface
  • Foreign key lookup editor for easy editing of fields referencing other tables
  • Free copying of any block of data to clipboard
  • Full-text search (Ctrl+F) through data grid
  • Graphical card view
  • Grouping by arbitrary columns
  • Incremental search (Ctrl+I) through data grid
  • Large objects (LOB) editor
  • Multi-table query result set editing
  • Paginal data browsing for large result sets
  • Printing of data
  • Quick filter feature available for each data cell
  • Record numbering option
  • Read-only state indication
  • Report, chart, and pivot building directly from data editor
  • Server-side sorting and filtering to help dealing with large data sets
  • Visible columns picking dialog box
  • Editing microseconds in columns with the TIME, DATETIME and TIMESTAMP data types

Database Backup

  • Comprehensive MySQL backup and restore wizards
  • Schema or data only backups in addition to full backups
  • Large database (exceeding 2 Gb) support
  • Backup projects to save settings for future use
  • Zip compression for backup files
  • Command line support for scheduling backup tasks
  • Error and status logging

Database Explorer

  • Multiple database connections allowed
  • Asynchronous connect to server with ability to cancel the operation
  • Detailed object properties and data browsing in Object Viewer window
  • Dependency tree browsing for each object
  • Duplicate object feature
  • Quick template script generation for selected object: SELECT, INSERT, EXECUTE, etc
  • Customizable DDL generation via wizard
  • 'Send To' command for quick sending of tables to Query Builder, Data Report, and other tools
  • Smart column renaming that allows rebuilding dependent tables
  • Quick access to object privileges (GRANT) from the popup menu
  • Multi-selection for batch operations on objects
  • Database navigation history

Database Refactoring

  • Renaming of tables, columns, views, procedures, and functions
  • Preview of changes in the database with possibility to cancel them selectively
  • Possibility to generate refactoring script of a database without changing it
  • Refactoring feature can be accessed from Database Explorer and object editors
  • Possibility to rename several columns from object editor
  • If an error in processing dependencies is encountered, a user can fix it manually

Debugger

  • Stored procedure and function debugging
  • Trigger debugging
  • Script debugging
  • Step Into, Step Over, and Step Out commands for step-by-step execution
  • Breakpoints support for procedures, functions, triggers, and scripts
  • Breakpoints window
  • Call Stack window with navigation
  • Watches window for variable evaluation
  • Evaluation of session variables when debugging a script
  • Single-click debug engine deployment

MariaDB specific features

  • SELECT (LIMIT ROWS EXAMINED) extended syntax
  • INSTALL SONAME statement supported
  • SHOW EXPLAIN syntax
  • Multi-source replication syntax
  • Dynamic Columns syntax for DML statements
  • New KILL syntax
  • Expanded CREATE TABLE or ALTER TABLE syntax
  • Aria storage Engine supported
  • Virtual columns supported
  • Microseconds supported
  • Pluggable Authentication supported

Exporting and Importing Data

  • Data export to:
    • CSV
    • XML
    • Text
    • XLS
    • PDF
    • DBF
    • HTML
    • RTF
    • MDB (Access)
    • ODBC
    • SQL
  • Export data from multiple tables at once
  • Export data from command line interface
  • Data import from:
    • CSV
    • XML
    • Text
    • XLS
    • XLSX
    • DBF (Foxpro, dBase III, dBase IV, dBase 7)
    • MDB (Access)
    • ODBC
  • Import data from command line interface
  • Templates for exporting and importing

Flat Table Editor

  • Visual editor for tables
  • Convenient editor for foreign keys
  • Partitioning support
  • Editable column grid: columns can be added and edited without opening the popup dialog
  • Full-text search on the column grid
  • Schema changes can be viewed before updating database
  • Heuristics helps define data type of new columns

Object Editors

  • Visual editors for columns, indexes, and views
  • Visual editors for triggers, events, and user-defined functions
  • Combined editors for stored procedures and functions
  • Ability to browse schema objects in a single editor (pin document)
  • Schema object search based on a variety of parameters

Database Projects

  • New project wizard with import from an existing database
  • Project Explorer window for managing project files
  • Schema View window for browsing logical project structure
  • Project export into one script
  • Reference checking while building
  • Multiple build configurations
  • Single-click project deployment on the server
  • Code refactoring
  • Schema comparison tool integration
  • Workspace saving

Query Builder

  • The state-of-art diagram with zooming and keyboard support
  • Preview and printing of the diagram
  • Visual addition of sub-queries to any part of the main query
  • Query outline (displayed in Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creating complex conditions
  • Copy/Paste for tables on the diagram
  • Undo/Redo support
  • Saving queries to a file
  • Support of visual building of INSERT, UPDATE, and DELETE statements
  • Conversion of SELECT queries into INSERT statements
  • One-click conversion of SELECT query into UPDATE or DELETE with saving of WHERE condition

Query Profiler

  • SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
  • Plan of the query displayed in the tree view for easy review
  • Profiling history that can be saved for further analysis
  • Compare profiling results feature with differences highlight
  • Profiling results printing

Schema Comparison

  • Capability to compare a database with a database
  • Capability to compare a database with a project
  • Schema comparison reports generation
  • Command line launch for schema comparison and synchronization
  • Synchronization between different server versions
  • Comparison results filtering
  • Schema synchronization script generation
  • Per object viewing of DDL differences
  • Objects exclusion from synchronization
  • Saving and loading comparison settings

SQL Editing and Execution

  • Automatic SQL syntax check
  • Code outlining with support of user-defined collapsing regions
  • Code Snippet Wizard
  • Context-sensitive code completion
  • Context-sensitive dynamic MySQL help accessible from the editor
  • Document Outline window for quick navigation through large scripts
  • Execution of scripts, selected SQL fragments, and statements
  • One step access to a schema object editor from code (go to definition)
  • Parameter information for stored routines
  • Quick access to favorite templates from SQL editor
  • Quick information about schema objects
  • SQL editor with syntax coloring, bookmarks, and text searching
  • SQL formatting on-the-fly in the editor
  • Executed SQL history window for the document
  • Wizard for batch SQL formatting of files on the disk

Visual Database Designer

  • Visualization of tables, views, and stored routines
  • Easy access to database objects for viewing their properties, editing, retrieving data,
  • executing stored routines, etc.
  • Support for IDEF1X and IE notations
  • Customizable diagram look and feel with skin support
  • Smart diagram layout
  • Diagram export to different image formats
  • Searching database objects on diagram
  • Organizing diagram shapes with containers
  • Customizable diagram printing with a rich set of options
  • Optional displaying of table constraints, indexes, and triggers
  • Integration with Document Outline window
  • Diagram navigation with Diagram Overview window
  • Notes for adding your comments to the diagram

User Interface

  • Start page providing easy access to main product features
  • Rich user settings
  • UI skins
  • Customizable window layout
  • Tool windows with 'auto-hide' and 'float' modes
  • Multiple shortcut schemes with full shortcut customization
  • Syntax highlight customization
  • Tabbed groups for documents
  • Toolbars customization
  • Ability to browse schema objects in a single editor (pin document option)
  • Wizard for exporting/importing user settings
Users reviews & testimonials

This software is not reviewed yet.

Advertising
Other downloads from this publisher

Devart ODBC Driver for Firebird provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Firebird databases from Windows, Linux, MacOS, both 32-bit and 64-bit.

dotConnect for SQLite Standard Edition is a free of charge database connectivity solution built over ADO.NET architecture. It offers basic functionality for developing database-related applications, web sites.

SDAC is a VCL/VCL.NET/CLX component library for fast direct access to SQL Server from Delphi and C++Builder. Supports all SQL Server data types and functionality, including MARS, bulk copy operations and reliable messaging.

dbForge Source Control for SQL Server is a SSMS add-in for managing SQL Server database changes in source control. The tool can link your databases to all popular source control systems, and delivers smooth and clear workflow in a familiar interface

dbExpress is database-independent layer that defines common interface for fast access to MySQL database from Delphi. It provides high performance database connectivity and is easy to deploy. It can work using native network protocol or MySQL client