dbForge Studio for Oracle V4.0
Released: Sep 20, 2018
Updates in V4.0
Features
- Enterprise Edition - Along with all features of the Professional edition, the new dbForge Studio for Oracle Enterprise edition includes the following exclusive features.
- Data Generator - The Data Generator feature allows you to generate millions of records of meaningful test data. A rich collection of data generators and advanced customization options will make your test data look like real-world data. In addition, the tool allows creating your own unique data generators.
- Documenter - Document and present Oracle schemas. The schema structure is presented as a neat navigation tree. Each item of the tree allows displaying properties of each schema object as a skinned HTML list with the ability to set up color palettes and fonts. The tuned variant of database documentation can be exported to HTML, PDF, and MARKDOWN.
- Data Import/Export
- Support for Google Sheets - Now you can easily migrate table data between your Oracle tables and Google Spreadsheets. All you need to do is to specify an URL/ID of your Google Spreadsheets table, and our handy Data Export Wizard and Data Import Wizard will do the rest of the work for you.
- Support for JSON Data - The Data Import and Data Export functionality support JSON, an open-standard format that uses human-readable text to transmit data objects consisting of attribute-value pairs.
- Preview of Generated Update Script in the Wizard - When importing data, you can specify what you would like to do with the generated Update script, – opened it in the internal editor, save it to a file, or execute it immediately against a database.
- Detection of Column Types when Importing Data from Excel Format - When you import data from the Excel files, dbForge Studio for Oracle analyzes column data and automatically assigns data types to them.
- SQL Documents
- The CTRL+W shortcut for closing the current tab.
- Opening new tabs next to current one.
- The CTRL+N shortcut for the inheritance of server and database of the current SQL window by a new one.
- Display of the connection color in the status bar.
- Each document creates its own connection.
- The Close All Unmodified Tabs command.
- The Format Document (CTRL+K+D) command in the shortcut menu of the SQL document.
- Highlight of the matching columns and data in the INSERT statement.
- Closing code completion connection to Oracle Server when it is not being used.
- Query navigation. To navigate between keywords within the query, you can press Ctrl+F12 or use the Jump between Syntax Pairs option from the shortcut menu.
- Improved query text parsing.
- Greatly redesigned Query execution history. With the new Execution History document, you can easily locate the required executed query, view text and re-execute it.
- Data Viewer
- Data Viewer has been enhanced with a display of data type and size.
- Schema Compare and Data Compare
- Improved Comparison Reports - The Generate Comparison Report dialog box now allows creating reports in the XML and XML for Excel file formats along with the HTML and Excel file formats.
- Schema Comparison
- New schema comparison options
- Associate column names having similar name options.
- Ignore case in objects names.
- Ignore spaces in objects names.
- Disable dependency analysis.
- Ignore collations.
- Ignore datatypes in column.
- Ignore Table DML Trigger.
- Ignore INSTEAD OF Triggers.
- Ignore firing order for triggers.
- Ignore check constraints.
- Ignore foreign keys actions ON UPDATE and ON DELETE.
- Ignore indexes.
- Ignore index names.
- Ignore primary keys.
- Ignore uniques.
- Ignore triggers present only in Target.
- Ignore indexes present only in Target.
- Ignore Dependent Objects In Others Schemas.
- Ignore double quotes in PL/SQL blocks.
- Ignore external table location information.
- Ignore parallel.
- Ignore supplemental log.
- Ignores flashback archive.
- Ignore START WITH in materialized views.
- Ignore START WITH in sequences.
- Ignore character length semantics.
- Ignore ILM Policies.
- Ignore MinValue in sequences.
- New schema synchronization options
- Use DROP and CREATE instead of ALTER for tables.
- Use DROP and CREATE instead of ALTER for views, procedures, functions, triggers, packages, Java Sources.
- Support for new objects and properties:
- ROWDEPENDENCIES.
- XMLTYPE with XMLSCHEMA.
- External tables.
- Multiple Indexes on the same set of columns.
- Partial indexes for partitioned tables.
- In-memory column store.
- Advanced index compression with partitioned indexes.
- Attribute clustering.
- ILM policies.
- Indexing JSON data and function-based indexes.
- Temporal validity.
- Constraint name of view supported in read-only subquery restriction.
- Materialized view log: FOR REFRESH clause.
- Automatic list partitioning.
- Column-level collation and case-insensitive database.
- Full-text search (JSON search indexes).
- Real-Time Materialized Views.
- Collation for clustered columns.
- Data comparison
- New data comparison options
- Specifying Regular Expression for:
- Include tables or views by mask.
- Exclude tables or views by mask.
- Ignore columns by mask.
- Ignore spaces in middle of varchar.
- Always exclude newly added objects.
- Ignore datatype for virtual columns.
- Tolerance interval.
- Exclusion and inclusion of columns from/into comparison
- The Column Mapping dialog box now includes the Compare and Sync checkboxes for each column pair. The option allows you to easily exclude/include column pair form/into comparison and synchronization.
- New data synchronization options
- Check for concurrency updates.
- Synchronize current values of sequences.
- Additional Scripts
- Data Synchronization Wizard includes a new tab, Additional Scripts, that allows typing or selecting a script to execute bere and/or after data synchronization.
- Automatic selection of comparison key for objects without equal unique indexes
- The Data Comparison tab of the Options dialog box includes the Comparison key option allowing to select a strategy for tables, views and custom queries without equal unique indexes.
- Other Improvements
- Digital signature for the installation file.
- Trial product activation.
- Greatly improved visual style of the tool.
- FIPS compliance.
- Support for PowerShell.
- Command line execution file wizard.
- Redesigned Generate Script As.
- Improved support for high DPI and 4K resolution.