dbForge Studio for MySQL improves Query Builder

dbForge Studio for MySQL is a tool designed to automate and simplify work with MySQL. It provides an easy way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways. dbForge Studio for MySQL offers full support for MySQL and includes advanced features like quick code navigation, automatic SQL syntax checking and customizable SQL formatting.

Updates in V6.0

Database Refactoring

• Rename objects in a database and automatically update links to these objects.

Query Builder

• Visually build INSERT, UPDATE and DELETE statements.
• Convert SELECT queries into INSERT statements.
• Execute separate sub-queries to check correctness without leaving the diagram interface.
• Query type is now indicated on the diagram surface.

SQL Statements Export

• Export data to INSERT, UPDATE and MERGE statements.
• Export query results as well as data directly from tables.
• Generate INSERT statements from the data grid.

Improved Database Object Editors

• Full-text search in columns.
• Schema changes can now be viewed before updating the database.
• View the designer and SQL table simultaneously.

Data Comparison Tool

• New data comparison reports now contain table data (not just a summary).
• Comparison of custom query results (along with tables and views).
• Full-text search in comparison results.

About Devart

Devart is a leading company working in the database connectivity area. They offer well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. They provide advanced data access solutions for 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 processes.