dbForge Studio for Oracle 4.0

La nuova edizione Enterprise include il Generatore di dati e l'Analizzatore.
Settembre 21, 2018
Nuova versione

Funzionalità

  • 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.
dbForge Studio for Oracle 4.0
Data Generator

dbForge Studio for Oracle

Ambiente di sviluppo per lavorare con i database Oracle.

Richiedi preventivo Acquista ora

dbForge Studio for Oracle è disponibile anche in:

Hai una domanda?

Chatta live con i nostri specialisti di gestione delle licenze di Devart ora.