3.10.27 20-Oct-21
User-reported and internal bug fixes
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update
3.10.14 25-Feb-21
Improvements
- Connectivity support for Oracle 12c R2, Oracle 18c, Oracle 19c
3.9.13 12-Nov-19
- Visual Studio 2019 is supported
3.8.11 27-Dec-16
- Visual Studio 2017 is supported
3.7.20 03-Mar-16
- User reported issue with Data Editor and Viewer is fixed (T113659)
3.7.14 28-Jan-16
- User reported issue with debug in VS 2015 is fixed (T157971)
3.7.12 11-Sep-15
Visual Studio 2015 support
3.6.423 21-Aug-14
Oracle Database Connectivity
- Connection via Windows authentication is added
Database Explorer
- Ability to compile objects from object category node is added
- Ability to enable/disable triggers is added
- Ability to enable/disable indexes is added
- Icons for user types and triggers are updated
Schema Compare and Synchronization
- Ignore Schema Name During Comparison option is added
- Ignore Compression Differences option is added
- Ignore LOGGING/NOLOGGING Clause option is added
- Ignore Column Order in Indexes option is added
- Exclude Comments option is added
- Use SQL *Plus Commands option is added
Data Compare and Synchronization
- Include Print Comments option is added
- Use SQL *Plus Commands option is added
Data Editor and Viewer
- Ability to view results as a structured XML file is added
Object Editors
- Viewing script while editing columns, indexes etc. is possible now
Code Debugger
- Current variable value output in tooltip while debugging procedures and functions is added
Alias Refactoring
- Built-in Rename dialog box to rename aliases in your code
Other Features and Improvements
- Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN key combinations
- Windows connection coloring is added
- Switching between wizard window and primary window is possible now
3.5.353 16-Apr-14
Automatic suggestions cache refresh by specified time is added
Application updated with lots of bug fixes
3.5.274 05-Dec-13
-
InvalidOperationException while editing query results is fixed (T89648)
-
An exception while setting a constraint in the table editor is fixed (T91013, T91651)
-
NullReferenceException while selecting the 'In Bytes' checkbox in the column properties
is fixed (T88823, T89532)
-
IndexOutOfRangeException while connecting to Oracle 8.0.x is fixed (T88617)
-
ArgumentOutOfRangeException while creating a new folder inside the Snippet Manager
is fixed (T88686)
-
KeyNotFoundException while generating a schema script with all enabled options is
fixed (T88885)
-
NullReferenceException while opening the Security Manager is fixed (T89031, T92044)
-
Incorrect values for BLOB fields while generating the INSERT statement from the
Data Editor are fixed (R29341)
-
dbForge Fusion for SQL Server compatibility problems are fixed
3.5.220 24-Oct-13
The new version of dbForge Fusion for Oracle (formerly known as OraDeveloper Tools)
has a different name and includes a whole pack of new features and extended old
ones.
Integration
-
Integrates into Visual Studio 2012, Visual Studio 2013, and supports all IDE skins
-
One installation file to integrate the add-in into both Visual Studio 2010, 2012
and 2013: the required IDE can be selected during installation
-
Integrates into dotConnect for Oracle
Oracle Connectivity
-
Oracle 12c is supported
-
Working with Oracle on Amazon RDS is possible now
Improved database object editors
-
Editable column grid in the table editor now allows adding and editing columns without
opening the popup dialog
-
Full-text search in the column grid in the table editor is added
-
Schema changes can now be viewed before updating database
-
Editor layout was revised, and now it allows viewing designer and table SQL simultaneously
-
F7 shortcut can now be used to toggle all editor views
-
Heuristics is supported: data type of the new column is suggested basing on the
column name. For example, for CUSTOMER_ID column NUMBER data type will be suggested,
and for CHANGE_DATE column DATE data type will be suggested.
Optimized application performance for working with Oracle servers
-
Database Explorer works faster now
-
Database object editors work faster now
-
Metadata for code completion is described faster now
New code formatter
-
Multiple formatting profiles
-
Extended options for formatting different clauses
-
Preview window for viewing formatted code with support of code highlighting and
editing
-
Option quick search filter
-
Independent and precise adjustment for SQL-statements
Extended code completion capabilities
SQL intellisense functionality is improved to make coding easier. Extended code
completion, quick object information, code snippets will simplify your work.
-
Suggestion of JOIN statements is added
-
Extended Oracle grammar support is added
-
Context-specific suggestions are improved
-
Full support of suggestions and PL/SQL grammar with context consideration is added
-
Code Templates features is now renamed to Code Snippets and extended with the manager
window for adding and editing SQL templates.
Schema comparison tool
It is a comprehensive tool for database schema comparison and synchronization
that can be used both by application developers and database administrators (DBAs).
This tool can become a great assistant when you need to identify the impact of changes
made to your database schema, as it easily points out all differences and allows
generating customized Oracle schema synchronization script.
Data comparison tool
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. Following are the new
features:
-
The state-of-art diagram with zooming and keyboard support
-
Preview and printing of the diagram
-
Visual addition of sub-queries to any part of the main query
-
Query outline (Document Outline window)
-
Visual editing of sub-queries
-
Expression builder for creating complex conditions
-
Copy/Paste for tables on the diagram
-
Undo/Redo support
Greatly Enhanced Data Editor
Newly added features and a few totally redesigned ones provide even more freedom
when working with data:
-
Quick filtering feature is added
-
Foreign Key lookup editor is 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
-
Option for numbering records is added
-
Copying data to clipboard with header is added
-
Integration with charts, data reports, and pivot table component
Powerful Data Export and Import
With Data Export and Import tools, you can export data from tables or views of your
Oracle database, and after that you will be able to insert the exported data into
the table you need. 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 exporting 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
Every user can benefit from a modern way of generating reports. Less time and manual
work is required to gett 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 a 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 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
Quick generation of 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 CREATE, DROP, DROP and CREATE,
SELECT, INSERT, UPDATE, or DELETE scripts for tables. This option is available in
the context menu and called Generate Script As.
Reworked Query Profiler
Query Profiler tool was reworked for more convenient usage and extended with session
statistics:
-
Query plan is displayed in tree-list control in order to show execution step properties
-
Session statistics changes are captured to reflect query impact
-
Profiling history that can be saved for further analysis
-
Compare statistics results with differences highlight
-
Profiling results printing
Wizard for execution of large SQL scripts
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.
Import and Export Settings Wizard
Import and Export Settings Wizard allows you to export and import all your connections,
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.
Improvements
2.60.176 18-Aug-10
Temporary disabled navigation combo-boxes in SQL editor
The Visual Studio 2010 has number of bugs, and one of them causes IDE to crash when
navigating to a member via navigation combo-box at the top of the SQL editor. Microsoft
team reported these issues as fixed, so we will return the functionality back when
Service Pack for Visual Studio 2010 come.
2.60.175 21-Jun-10
User reported bugs fixes
-
T18029 Visual Studio crashes when show completion list
-
T17018 'Execute Current Statement' and 'Execute Selection' items disappeared from
a popup menu in SQL Editor
2.60.174 14-Jun-10
-
Fixed NullReferenceException on closing a table editor (T17018, T16790, T17793)
-
Fixed COMException while starting debugging in the trial version (T16634, T17792)
2.60.172 07-Jun-10
-
Microsoft Visual Studio 2010 supported
2.55.168 02-Mar-10
-
RemotingException on loading Visual Studio fixed (T10716)
-
ObjectDisposedException on opening Database Explorer fixed (T9840)
-
The problem with retrieving data from the table with BLOB fields fixed (T9349, T9356)
-
Sorting data of DATE fields in Data Editor fixed (T10680)
-
The problem on editing data of fields with Object Type data type fixed (49797)
-
Compilation of PACKAGE BODY is working now (T9933)
-
Fix of ArgumentOutOfRangeException on editing text in SQL document if it contains
regions and incomplete statements (T9290)
-
The settings of Quick filter are not cancelled on Paginal Mode changing now (50088)
-
Actions with files do not cause to encoding loss
-
Scale for columns with data type as TIMESTAMP retrieved without errors now (50114)
2.55.160 26-Oct-09
-
Error during creating columns of NUMBER type was fixed (45932)
-
NullReferenceException on an attempt to retrieve data twice from the same table
was fixed(T7552)
-
Error on painting Error List during execution of scripts' succession was fixed (T7825)
-
Error connected with length accounting of BYTE and CHAR columns was fixed (41723)
-
Error that occurs when performing the "View Xml Schema" operation was fixed (45521)
-
Now it is impossible to select fonts that do not support some styles in the text
editor (T7443)
2.55.148 20-May-09
-
The problem with accessing to a disposed object on closing application was fixed
(39129, 38580)
-
IndexOutOfRange exception on retrieving table metadata was fixed (38139)
-
Inserting NUMBER or VARCHAR values in Data Editor in Direct mode is working correctly
now (36418)
-
NullReferenceException on showing watermark on printing contents of Data Editor
was fixed (27349)
-
NotSupportedException on showing data of tables with RAW fields was fixed (27326)
-
Incorrect opening of the file in LOB Editor was fixed (27315)
-
ArgumentOutOfRangeException on navigating in Object View was fixed (36298)
-
Views duplication on refreshing in Database Explorer after renaming them (36290)
-
Incorrect work with DATA parametres was fixed (396339)
2.55.144 11-Feb-09
-
Problem with modification of numeric data in the Data Editor was fixed (36463)
2.55.141 13-Jan-09
-
NullReferenceException on show data in Data Editor was fixed (33100)
-
Bug with opening Tables list in the Database Explorer was fixed (35338)
-
Problem with case-sensitive file extension handling was fixed (35648)
-
Incorrect working with OracleCommand verbs was fixed (23632)
-
Problem on executing SQL Plus command "describe" in Sql document on Oracle server
version below 9i was fixed (36101)
2.55.135 10-Nov-08
-
Bug with editing NCLOB fields was fixed (33730)
-
The problem with character length fixed (27659)
-
NullReferenceException on application closing fixed (30549)
-
ArgumentException when editing content of CLOB column fixed (30552)
-
DuplicateNameException when query executing fixed (30551)
-
Bug with DateTime data editing fixed (26396)
2.55.123 15-Jul-08
-
The problem with character length fixed (27659)
-
NullReferenceException on application closing fixed (30549)
-
ArgumentException when editing content of CLOB column fixed (30552)
-
DuplicateNameException when query executing fixed (30551)
-
Bug with DateTime data editing fixed (26396)
2.55.121 25-Mar-08
-
InvalidOperationException when table opening fixed (26659, 26397)
-
IndexOutOfRangeException during script execution fixed (26398)
-
Problem with excel export fixed (26394)
-
Bug fixed with loading data for the trigger fixed (26190)
2.55.120 9-Jan-08
-
Bug fixed with default shortcut schema loading (25263)
-
Bug fixed with generic error in GDI+ (24902)
-
NullReferenceException when file saving fixed (25394)
2.55.119 21-Dec-07
-
Bug fixed with specified tables export via Conventional Path (24486)
-
Bug fixed with UI localization
-
Exception when executing stored procedure with out parameters is eliminated (24513)
-
The problem with OraDirect integration in OraDeveloper Tools for VS 2008 fixed (24413)
-
Problem with OraDirect OracleCommand interaction fixed (24451)
-
Bug fixed with the compilation of dependencies for views (24463)
-
Bug fixed with modal query builder suspension (24393)
2.55.117 26-Nov-07
-
Oracle 11g support added
-
Bug fixed with plan execution for queries containing WITH statement(24035)
-
Bug fixed with PLAN_TABLE determination in SYS schema (24037)
-
Bug fixed with generic error in GDI+ (24466)
-
Bug fixed with invalid .qry file opening (24499)
2.50.113 23-Oct-07
-
Bug fixed with ArgumentOutOfRangeException in QueryBuilder (23954)
-
Exception when inserting text to the stored procedure text editor is eliminated
(23904)
-
Bug fixed with package load failure
2.50.112 02-Oct-07
-
Microsoft Visual Studio 2008 support added
-
Bug fixed with using filter for Date column in the Data Editor (23782)
2.50.109 20-Sep-07
-
Bug fixed with the corruption of Visual Studio options during uninstall
-
Bug fixed with stack overflow when navigating to the object name
-
Bug fixed with viewing of the raw type columns in the Lob Editor
-
Bug fixed with Xml Schema unregistering
2.50.101 30-Aug-07
-
Advanced context-sensitive code completion
-
SQL*Plus command support
-
Customizable shortcuts
-
DDL generation extended with high number of options
-
Clusters and database links supported
-
Database object dependency supported
-
Database object search extended with full-text mode
-
User comments for tables, views and materialized views supported
-
Schema Export wizard for exporting to SQL script
-
Project wizard with schema import feature added
-
Session manager improved
-
Navigation history added to Database Explorer
-
Many other improvements
2.00.14 06-Dec-06
-
PL/SQL debugging support
-
Database project support
-
Advanced coding aids in SQL editor
-
Security Manager tool added
-
Session Manager tool added
-
Event Monitor tool added
-
Database object search extended
-
Clustered, partitioned and index-organized table supported in table editor
-
XML schema and table supported
-
Materialized view and materialized view log supported
-
Document outline window
-
Sequential fetch feature
-
Data printing supported
-
Card data view added
-
View data as text feature
-
SQL and PL/SQL code templates added
-
Pin/unpin document feature
-
Many other improvements
1.70.33 14-Apr-06
-
Full integration into Visual Studio using software packages that run as a part of
environment
-
Compatible with Microsoft Visual Studio 2005 and Microsoft Visual Studio .NET 2003
-
Since version 1.70 Microsoft Visual Studio .NET 2002 is no longer supported
-
Drag'n'drop from DbExplorer to DataSet designer supported (Visual Studio 2005 only)
1.50.16 01-Feb-06
-
Exception on retrieve data fixed
1.50.15 27-Jan-06
-
Help registration bug fixed
-
Execution timeout bug fixed
-
Bug with error navigation during execution of the selected fragment fixed
1.50.14 24-Jan-06
-
Database export/import
-
DDL generation wizard
-
Database object search
-
Script support
-
Data Export feature
-
Dynamic data viewing of the tables and views in DbExplorer
-
Paginal data access mode
-
LOB viewer/editor
-
Stop execution feature
-
Execution of the selected SQL fragment feature
-
Duplicate object feature
-
Data grid colors customizing
-
Many other improvements
1.0.4 16-Sep-05
-
Error on connection to empty schema fixed.
1.0.3 17-Aug-05
-
Bug with drag'n'drop from DbExplorer to Web Forms Designer fixed. (7911)
1.0.2 25-Jul-05
-
Bug in Database Connection Properties dialog with direct mode is fixed.
-
Bug with describing table storage options is fixed.
1.0.1 06-Jun-05
-
Visual Studio 2005 Beta 2 support added.
-
Data providers names changed in database options. (7098)
-
SQL editor speed increased.
-
Dropped tables on Oracle 10g are not shown in DbExplorer anymore. (7018)
-
New Object dialog now includes full list of schemas. (7025)
-
Bug with adding new stored procedure to DbExplorer fixed. (7026)
-
Bug with dragging stored procedures on Form Designer fixed. (7056)
1.0.0 31-May-05
-
First release of OraDeveloper Tools for Visual Studio .NET.
© 2004-2022 Devart. All Rights Reserved.