New tool for database developers - Query Profiler
dbForge Studio offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN in a convenient and clear GUI. Besides you get STATUS variables for the required query automatically calculated.
Additional benefits:
- Plan of the query displayed in the tree view for easy review
- Profiling history that can be saved for further analysis
- Capability to compare profiling results in two clicks
- Capability to print profiling results
Revised Data Comparison tool
Diverse testing and close interaction with database developers, admins and casual users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now it embraces the following:
- Capability to compare and synchronize database of any length
- Increased performance of comparison processes
- Generating accurate comparison reports in HTML and Excel formats
- Capability to change synchronization direction in one click
- New comparison options: Ignore columns by mask, Ignore trailing spaces, Round float types
- Quick filtering tables in comparison results
- Optimized object management during custom synchronization
- Capability to edit values of default comparison options
- New synchronization option Exclude Comments
Improved Query Builder tool
- Optimized performance of the Selection tab in the expression editor
- New Wrap to Subquery option to wrap tables into a subquery
- Visual addition of subqueries to any part of the main query
- Optimized navigation in the editor, particularly between subqueries
- Capability to edit view location in the query document
- Joins show connection direction; better described connection properties
- New skin for objects on the diagram
Quick generating template SQL scripts for database objects
Thanks to this new functionality, you can save your time while working with database objects. For example, you can quickly generate template SQL scripts CREATE, DROP, SELECT, INSERT, UPDATE or DELETE scripts for tables. This option is available in the context menu and called "Create Script As".
A few improvements in Schema Comparison tool
- Extended capabilities of Schema Comparison wizard
- New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns
Other improvements
- New SQL document view layout - now you can see query text and retrieved data at the same time
- Generate DDL wizard was renamed into Generate Schema Script
Updates in V4.5
Redesigned Database Backup Wizard
Schema Export wizard has been totally redesigned to provide more freedom for backing up schemas. It features the following:
- Capability to save backup options for future use
- Support of command line interface. You can back up schemas in automatic mode using Windows task scheduler
- Automatic archiving of schema backup scripts
- Writing a report about backup process into a log file
- Automatic removing old backup files based on date or quantity
New tool for database developers - Query Profiler
dbForge Studio offers results of internal MySQL tools like SHOW PROFILE and EXPLAIN in a convenient and clear GUI. Besides you get STATUS variables for the required query automatically calculated.
Additional benefits:
- Plan of the query displayed in the tree view for easy review
- Profiling history that can be saved for further analysis
- Capability to compare profiling results in two clicks
- Capability to print profiling results
Revised Data Comparison tool
Diverse testing and close interaction with database developers, admins and casual users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now it embraces the following:
- Capability to compare and synchronize database of any length
- Increased performance of comparison processes
- Generating accurate comparison reports in HTML and Excel formats
- Capability to change synchronization direction in one click
- New comparison options: Ignore columns by mask, Ignore trailing spaces, Round float types
- Quick filtering tables in comparison results
- Optimized object management during custom synchronization
- Capability to edit values of default comparison options
- New synchronization option Exclude Comments
Improved Query Builder tool
- Optimized performance of the Selection tab in the expression editor
- New Wrap to Subquery option to wrap tables into a subquery
- Visual addition of subqueries to any part of the main query
- Optimized navigation in the editor, particularly between subqueries
- Capability to edit view location in the query document
- Joins show connection direction; better described connection properties
- New skin for objects on the diagram
Quick generating template SQL scripts for database objects
Thanks to this new functionality, you can save your time while working with database objects. For example, you can quickly generate template SQL scripts CREATE, DROP, SELECT, INSERT, UPDATE or DELETE scripts for tables. This option is available in the context menu and called "Create Script As".
A few improvements in Schema Comparison tool
- Extended capabilities of Schema Comparison wizard
- New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns
Other improvements
- New SQL document view layout - now you can see query text and retrieved data at the same time
- Generate DDL wizard was renamed into Generate Schema Script
About Devart
Devart (formerly known as Core Lab) is a leading company working in the database connectivity area. It offers well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. The company provides advanced data access solutions for the Microsoft .NET Framework - ADO.NET data providers for native connectivity to Oracle, MySQL, and PostgreSQL database servers. Devart is also a vendor of powerful database tools designed to automate and simplify database development process.
