192a, Klochkovskaya St.,
Kharkiv,   61145 Ukraine
www.devart.ua

Solution Name

dbForge Studio for MySQL

Solution Summary

The universal MySQL and MariaDB client for database management, administration and development.

Solution Profile

dbForge Studio for MySQL is a universal GUI for MySQL and MariaDB databases managing, developing and administrating. The tool allows to create and execute queries, develop and debug routines, automate database object management in the convenient environment. dbForge Studio also provides utilities to compare, synchronize, and backup MySQL databases with scheduling, generate data, document DB, and gives possibility to analyze and report table data.

Distinguishing Features


Broad Compatibility Options
All MySQL server versions,
All MariaDB server versions,
Percona PAM Authentication for MySQL, Galera Cluster, Amazon RDS, Amazon Aurora, Google Cloud, Alibaba Cloud, Tencent Cloud, Sphinx Search Engine, TokuDB, SSL, SSH, HTTP Tunneling.

Intelligent SQL Coding
Intelligent code completion, formatting, MySQL prompt, and 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
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
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 settings and connections as a project for the next time or to use in the command line.

Database Administration
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
Renaming database objects with preview
Refactoring script.

Query Profiler
Offers visual query profiling
Compares profiling results.

Data Generator supports all data types, includes a large number of meaningful generators with customizable settings, and allows generating data via the command-line interface.

Documenter is a tool for generation of MySQL and MariaDB database documentation. Documenter allows you to: - Retrieve an overview of the database structure - View inter-object and inter-database dependencies - Customize documentation with style templates - Generate documentation files in the HTML, PDF and Markdown formats.

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.

Solution Name

dbForge Studio for MySQL

Solution Availability

Asia Pacific

Europe, Middle East, Africa

Latin America

North America

Industries

  • High Technology

Oracle Products

  • MySQL
  • Windows

Company Size Solution is Targeting

No data available.

Open Source Solutions

No data available.

About Private scientific and production enterprise "DataSoft" (Private scientific and production enterprise "Data)

The partners listed in the Oracle PartnerNetwork (OPN) Solutions Catalog are part of the Oracle PartnerNetwork Program, however Oracle does not endorse any of the partners or their software, solutions, services or training listed on this site. Oracle disclaims any and all liability arising out of your use of the Oracle PartnerNetwork Solutions Catalog, including use of partners, software, solutions, services and training listed on the site.