July 9th, 2010, 09:37 AM
More Tools to Work with MySQL Databases Provided by dbForge Studio!
Devart today releases dbForge Studio for MySQL, v4.50 - cutting-edge administration tool and development environment for professional working with MySQL databases.
With dbForge Studio, Devart continues its initiative to produce efficient database experiences for all the people in MySQL world.
New features in dbForge Studio for MySQL, v4.50 include:
- More freedom for backing up schemas
Schema Export wizard was totally redesigned to Database Backup to enable users to back up schemas in automatic mode using Windows task scheduler, save backup options for future use, view automatically complied log file. Besides, old backup files are automatically removed 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.
-- 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
- Data comparison and synchronization of any databases
Diverse testing and close interaction with database developers, admins and casual users resulted in thoughtful redesign and enhancement of Data Comparison tool. Now it compares and synchronizes database of any length with significant performance improvement. To customize comparison and synchronization, the users can use new options, change synchronization direction in one click, and quickly filter tables in comparison results. An additional benefit is generating accurate comparison reports in HTML and Excel formats.
- Advanced query building
Now Query Builder, a powerful tool for visual query creating, is tailored for creating complex conditions with several clicks. The new power is based on optimized performance of the Selection tab in the expression editor, visual addition of subqueries to any part of the main query, new Wrap to Subquery option to wrap tables into a subquery, optimized navigation in the editor, particularly between subqueries and other features.
-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 of Database Explorer and called ‘Generate Script As’.
- Improved schema comparison
-- Extended capabilities of Schema Comparison wizard
--New comparison options to ignore some table options, DEFINER and SQL SECURITY expressions, default values for columns
Price and Availability
The fully-functional 30-day trial version of dbForge Studio for MySQL 4.50 is available for download at http://www.devart.com/dbforge/mysql/.../download.html. The license price starts at $49.95.
For more information about dbForge Studio for MySQL, visit the product's web site – www.devart.com/dbforge/mysql/studio/.
Devart is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users.
We specialize in providing comprehensive development and management tools as well as native connectivity solutions for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.
For additional information about Devart, visit www.devart.com/company/.
Tags for this Thread
Click Here to Expand Forum to Full Width
This a Codeguru.com survey!