Devart presents the new state-of-the-art version of a powerful Oracle database development tool – dbForge Studio for Oracle (formerly known as OraDeveloper Studio). Now it looks differently, and includes a whole pack of new features and extended old ones.
Devart is glad to release new completely redesigned version of the tool for Oracle development – dbForge Studio for Oracle, v 3.0. This product is formerly known as OraDeveloper Studio, but the new version has a different name, looks differently, and includes a whole pack of new features and extended old ones.
Product Editions
To make the product affordable for all categories of users, Devart team divided dbForge Studio for Oracle, v 3.0 into Express, Standard, and Professional editions:
Express gives you the basic FREE Oracle database tool
Standard is good for everyday Oracle development tasks
Professional includes extra tools to advance your Oracle development to a new level
Major New Features
Schema Comparison Tool
Being first released as a separate tool, dbForge Schema Compare for Oracle was integrated into dbForge Studio to provide even greater schema change management capabilities. It is a comprehensive tool for database schema comparison and synchronization that can be used both by application developers and database administrators (DBAs).
Data Comparison Tool
Being first released as a separate tool, dbForge Data Compare for Oracle was integrated into dbForge Studio to provide smooth integration with the rest of functionality. It is a powerful, fast, and easy-to-use tool for Oracle table data comparison and synchronization. It helps you quickly compare data in tables, find the differences at a glance, and generate a script to effortlessly synchronize data.
New Query Builder
Query Builder was completely re-designed to meet user needs. Now it allows you to build any complex queries visually. You can create sub-queries, add tables, create joins, or edit conditions with several clicks of the mouse, and big number of significant new features were added to redesigned Query Builder.
Greatly Enhanced Data Editor
Over 50 new features and usability improvements were made to Data Editor to provide maximum freedom when working with data. Here are some of them:
Quick filtering feature and Foreign Key lookup editor were added
Server-side sorting and filtering is implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
Few indications are added to inform user about Data Editor’s state
Editing of tables in join statements is enabled now
Options for numbering records and Copying data to clipboard with header are added
Integration with charts, data reports, and pivot table component
Powerful Data Export and Import
Data Export and Data Import provide the following features:
Easy-to use Data Export Wizard for exporting data to HTML, MS Excel, RTF, XML, ODBC, Text, MS Access, PDF, CSV, and DBF formats.
Highly customizable Data Import Wizard for importing data from CVS, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML formats.
Ability to export data from several tables at once
Possibility to export and import data from command line
Master-Detail browser
Explore and analyze master-detail data in a convenient browser with the following features:
Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation.
The document allows saving and loading data and diagram for future use
Sorting and filtering data in the Data view
Ability to analyze self-referencing tables
Data Reports
Less time and manual work is required now to get required data from a database, analyze, and print it as a smart, clear, and stylish report tuned for each particular case.
Pivot Table
Users can convert large amounts of data into compact and informative summaries – pivot tables. They can rearrange any obscure data by a simple drag of the mouse to get the layout that is best for understanding data relations and dependencies.
Redesigned Schema Export Wizard
Schema Export wizard has been totally redesigned to provide more freedom for exporting schemas. It features the following:
Capability to save export options for future use
Support of command line interface
Automatic archiving of schema backup scripts
Writing a report about export process into a log file
Automatic removing of old backup files based on date or quantity
Object Viewer – a simple way to view object’s details
Object Viewer provides an easy way for analyzing objects and their structure right from Database Explorer. It offers:
Three views to display properties, DDL (text), and data of the selected object
Inner navigation through object hierarchy
History with previously viewed objects
Extended information about each object in the Properties view
Minor New Features
Quick generation of template SQL scripts for database objects to save your time while working with database objects.
Query Profiler tool was reworked for more convenient usage and extended with session statistics.
The new version provides a special Execute Script Wizard to enable quick and convenient execution of large SQL scripts without waiting for their opening in the editor. It takes only to select a script and enjoy the executed result.
Code Templates features is now renamed to Code Snippets and extended with the manager window for adding and editing SQL templates.
Import and Export Settings Wizard allows you to export and import all your settings, layout, toolbars, keyboard shortcuts. Wizard also allows you to reset settings to their default values. You may export, import, and reset settings completely or partially.
Complete information about all new and extended functionality of dbForge Studio for Oracle is available on the Product web page .
Price and Availability
Consumers can give the updated dbForge Studio for Oracle a test drive by downloading the free Express edition or the 30-day trial Professional edition at the product download page. dbForge Studio license price starts at $149.95.
For more information about Database Tools for Oracle, visit the product pages at http://www.devart.com/dbforge/oracle/ .
About Devart
Devart is a widely recognized provider of database connectivity solutions and tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird and SQLite.
Since 1998, Devart has been focused on the development of native database data access solutions, development and database tools for a wide range of databases and development technologies. Now, Devart solutions provide the fastest data access available on the market and the broadest database support to many thousands of industry professionals.
For additional information about Devart, visit www.devart.com/company/
# # #
