Download DevArt dbForge Studio for MySQL v9.0.338 Enterprise + Crack

DevArt dbForge Studio for MySQL v9.0.338 Professional

DevArt dbForge Studio for MySQL v9.0.338 Professional
DevArt dbForge Studio for MySQL v9.0.338 Enterprise

dbForge Studio for MySQL is a universal GUI tool for MySQL and MariaDB database development, management, and administration. The IDE allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface. The MySQL client delivers data and schema comparison and synchronization tools, database reporting tools, backup options with scheduling, and much more.

In addition, dbForge Studio for MySQL is a perfect alternative to MySQL Workbench. Check out the pros of our tool over MySQL Workbench!

Database Development
Building, editing, and running queries, as well as measuring and optimizing query performance get much simpler with the following functionality:

MySQL Code Completion
SQL code formatting
SQL syntax check
MySQL Debugger
Query Profiler

Database Design
Database design tools allow users to create a database diagram, objects, projects, as well as to compare and synchronize database schemas efficiently and in a user-friendly interface.

Visual query builder
Visual design and editing
Database project framework
Table Designer

Database Administration
With these features, users can manage their accounts, set up permissions, monitor open sessions and their activity, as well as perform table maintenance. In addition, it is possible to back up and restore databases to/from a backup file.

Backup and Restore
Service Control
Data Export and Import
Security Manager
Copy Database

Data Reports and Analysis
Creation of data reports and pivot tables, as well as data comparison and synchronization may take much time and efforts while your work can be more productive using the following features:

Data Report Wizard
Report Designer
Pivot Tables
Chart Designer
Command line support

Broad Compatibility Options
dbForge Studio for MySQL is compatible with:

All MySQL server versions
All MariaDB server versions
Percona PAM Authentication for MySQL
Sphinx Search Engine
...and more!

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
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

Data Generator
Populate your MySQL tables with thousands of rows of realistic test data. Data Generator supports all MySQL data types, includes a large number of meaningful generators with customizable settings, and allows generating data via the command-line interface.

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

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, indexes, primary keys, defaults, and CHECK constraints. Get full control over the changes you have made. The heuristics feature will suggest a column type on creating a column based 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.

Database Projects
The Database Project is a collection of SQL scripts and query files which allows you to logically organize them in one place and in an offline mode. With this technology you can compare a database project with a database, by receiving a synchronized script, and deploy database changes.

Copy Database
Transfer MySQL Server databases from one server instance to another with a handy Copy Databases tool. The tool allows you to:

Customize copying settings
Copy databases together with data
Drop a database if it already exists on a target server

9.0.338 23-Jun-20

User-reported bug fixes

Problems with lost connection after 30 sec are fixed (T310169, T310109, T310443)
Problems with cache file are fixed (T310122, T310087, T310299, T310274, T310263, T310369)
Problems with date and time format are fixed (T310125, T310219)
Problem with loosing DEFINER is fixed (T286087)
Other User-reported bugs are fixed (T310323, T310229, T309706, T310166, T310400, T310684, T310136, T310405, T310765, T310365, T310341, T310203, T310136, T310231, T310216, T310191, T310067, T310292, T310288, T310253, T310267, T310250, T310325, T310349, T310363, T310151, T310689, T310228, T310118, T310450, T310453, T310163, T310308, T310111, T308483)

9.0.304 15-May-20


Connectivity support for MariaDB 10.5 is added
Display of server type in the Property window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
Display of server type in the Connections section of the System window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
Database Connection Properties and Test Connection windows are redesigned
Connectivity support for SkySQL is added

Database Design

The Find Invalid Objects feature is implemented

Support for new objects

Working with the Packages and Sequences established in MariaDB 10.3 is supported

SQL Document

-- nowarn and -- endnowarn tags have been added to the Execution warnings functionality
Exporting execution history in the CSV file format is added

Code Completion

Code completion is available in the body of triggers and events

Data Editor

Cached Updates mode is implemented

Schema Compare

Scripts Folder comparison is added
Object Filter is implemented
Schema Comparison Report window is redesigned
HTML reports are redesigned.
Pre and post script execution during data synchronization
Ignore DEFINER and SQL SECURITY clauses option is modified
Ignore row format table option is added
Ignore AUTO_INCREMENT option is added
DDL Diff control is redesigned

Data Compare

Scripts Folder comparison is added.
Data Compare control is redesigned.
Data Comparison Report window is redesigned.
Pre and post script execution during data synchronization
Option to append timestamp to the name of the data sync script file is added to Data Synchronization Wizard
Option to set default values is added to Data Synchronization Wizard

Data Generator

Pre and post script execution during data population.

Database Backup

Option to disable reference tables from the backup is added

Data Export and Import

Output tab is added to Data Import Wizard and Data Export Wizard
Data Export, CSV tab is added to the Options window
Display of selected data export format is added to all tabs of Data Export Wizard

Other Improvements

Command line prompt is expanded with a full list of available exit codes
Activation of the tool via the command-line interface is implemented

User-reported bug fixes

Problem with precision for Update Timestamp on MariaDB 10.3 is fixed (T308074)
Problem with generating CREATE script 'curdate()' with quotes is fixed (T291580)
Problem with generating null is fixed (T305946)
Problem with error on backup is fixed (T306368)
Problem with increment update is fixed (T305660)
Problem with displaying multi-line comments is fixed (T302702)
Problem with scrolling fields is fixed (T306452)
Problem with error exporting .rdb report to DOCX is fixed (T297220)
Problem with options editing format is fixed (T303784)
Problem with Restore running is fixed (T286122)
Problem with "find and replace" window is fixed (T276631)
Problem with comparing projects and databases is fixed (T275714)
Problem with displaying warnings in Output is fixed (T274188)
Problem with displaying property AUTO_INCREMENT is fixed (T274234)
Problem with completion list in case of using JOIN is fixed (T267254)
Problem with highlighting error is fixed (T168164)
Problem with displaying of controls for 4K monitors is fixed (T170777, T178589, T179019, T179922, T181573, T200641)
Problem with generating backup scripts is fixed (T262371, T289756)
Other user reported bugs are fixed (T304700, T303372, T304446, T303784, T303489, T303493, T298032, T287765, T292618, T294439, T293607, T286741, T293282, T307549, T290262, T289774, T281791, T281405, T281405, T283707, T283443, T282407, T286087, T276599, T110356, T307583, T272555, T274127, T268888, T284077, T269644, T269389, T294286, T268112, T262328, T304183, T267421, T266303, T266092, T219152, T215877, T205999, T228108, T252627, T252936, T257937, T260282, T198222, T279106, T302623, T256317, T262169, T260727, T308878, T286087, T309067)


Users of Guests are not allowed to comment this publication.