dbForge Studio for Oracle

dbForge Studio for Oracle is a powerful Oracle database development environment that provides you versatile data editing tools for managing in-database and external data. It allows you to synchronize data between different Oracle servers and automate schema change management process during development.

http://www.devart.com/dbforge/oracle/studio/

dbForge Studio for Oracle

Categories

JUMP TO ANOTHER FORUM

  1. it would be a great feature to have the possibility to pass values in "where" filter as parameters while running comparisons from the command line:

    datacompare.com /datacompare /compfile:"D:\mycompdoc.dcomp" /param:<par1>,<val1>[;<par2>,<val2>;...]

    and in mycompdoc.dcomp we have

    ...
    <Object SourceName="MyTable" TargetName="MyTable" SourceType="Table"
    TargetType="Table"> <SourceFilter>MyCol in (0,@par1,@par2)</SourceFilter>
    </Object>
    ...

    42 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  2. In dbForge for SQL Server we have direct support for Surround SCM source code management system.
    Would be great if we can see this in dbForge for Oracle too.

    12 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  3. It would be nice to be able to filter schemas (as one can with database objects) when 'Show All Objects' is selected on the database connection.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  4. Currently when comparing the contents of databases which contain singleton tables (no primary key single record) it is very time consuming to setup the compare. It would be very helpful if an option existed to change the default behavior for tables with no primary key. For most of my use cases I need to spend 10-20 minutes selecting every non-lob column as a key for these tables. A checkbox in the options screen could exist called something like "Automatically Map All Non-Lob Columns when No Primary Key Exists"

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  5. Comparing a Sequence with a different start with value is always displayed as equal in the comparison-results.

    Production:
    CREATE SEQUENCE EXAMPLESEQ START WITH 61 INCREMENT BY 1;
    Test:
    CREATE SEQUENCE EXAMPLE
    SEQ START WITH 41 INCREMENT BY 1;

    After moving the data for a table which uses the sequence from production to test the Test-Sequence-nextval will set wrong values for new rows, if the start with is not corrected.

    An Option to compare and synchronize the "start with" of the sequence would be fine!

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  6. Hi.

    I really enjoy the Studio for Oracle; unfortunately I cannot use it the latest project, as it uses LDAP type connections to OracleDB.

    Could you implement this way of connecting to Oracle DBs?

    Thank you, regards.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  7. Everytime I save a script (.sql) I have to select the correct encoding. For me it's West-European ISO/28591 but you default to UTF-8/65001. It's very annoying to do it every time and sometimes forgetting which lead to funny characters in the script.

    It was also asked a long time ago : http://forums.devart.com/viewtopic.php?f=22&t=24439

    Can you add this to the users's preferences ?
    Thank you

    BTW this form does NOT seem to work in IE8 that we have at work. Won't accept the password...

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  8. 6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  9. Ability to navigate to search for and navigate to an object definition via keyboard navigation and at pace.

    Something similar to Datagrip 's"Navigate to" (Ctrl+N) or Resharper search everywhere (Ctrl+T)

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  10. Source Control support like you have in the SQL Server Studio product

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  11. When creating a where clause in query builder have an option that shows the possible values for a field (select one for logical checks, checkboxes for in and not in selections). This was one of the nice features in TOAD.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  12. There are often times when performing navigation with the Go To Definition (F12) command in the package. It would be great if there was a possibility to have the history of such navigations and to navigate back in the navigations chain.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  13. When I use dbForge to interactively alter tables, the execution hangs the system such that nothing can be done within dbForge while the change occurs. If I copy the sql code to a sql window and execute the code myself then it doesn't hang the system.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  14. Export current result set as insert statement to file and to clipboard (how is it in toad). Quick preview of the selected object (like F4 in Toad).

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  15. It would be nice it there is a shortcout to open direct a selected Table from a Script.

    For example:

    Create table xy as select from t_test;

    So i can go with the cursor to ttest and with a shortcut the table ttest opens directly (Data View)

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  16. Data editor allows customization of the order and column width, set sorting and filtering records, also set how the text is highlighted (HTML, XML, …).
    After a restart of the application, this setting is lost.
    I mean the possibility of persistent individual customization for each table or view.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add to Database Explorer the ability to view the list of the private procedures/functions in package body. Otherwise, there is no possibility to navigate to the functions that are not specified in the package declaration.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  18. New feature: Hide some columns in all table diagrams with a specific names defined by the user. For example: "TIMESTAMP", "LASTUSER" , etc. In some cases all tables owns some of theese fields that are not important in the diagrams and wastes space.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support for UNION operator in Query Builder

    It's not always convenient to have many Views created in the database, when UNION can be used to join these in a single view.

    Query builder does not support UNION at this time and it would be a nice addition.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  20. vi key-bindings in sql editor would be amazing!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?