190 results found

1. LDAP connection type for Oracle

   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 Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Include/script related objects when creating a script for a table

   When creating a script for a table, make possible to include/script related objects. For example, table has a trigger, which depends on sequence. You already have this stated in Depends On, why not include CREATE TABLE, CREATE SEQUENCE and CREATE TRIGGER when doing CREATE TABLE

   8 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. "Navigate to" - navigate to an object definition quickly and by keyboard only

   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)

   8 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Update data in data editor using rowid

   When I select a table with some column of table and I edit it in grid, Dbforge using another columns to update data, It's seriously bug if these columns not relate what I want update.

   SqlNavigator and more other tool using rowid to update data in grid, can you using that idea to fix this bug.

   Thank you !

   7 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. highlight block if then else end; for; case and other to easy find it part as highlighting parentheses

   If 1=1 then
   if 1=2
   then end
   if 1-1=1
   then
   begin

   end
   else
   else
   if 1=3 then else
   end if;
   end if;

   To easy find errors in similar code. I think code this error is not format automatically.

   7 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. set Fetch Size for Oracle Connection

   To speed up the download of medium to large datasets (no, Paginal Mode doesnt help here)

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminDevart (_, Devart) responded

   Could you please explain this in details?

7. Feature: Split Editor Window Horizontally

   dbForge Studio for Oracle should provide users with the ability to split the editor window horizontally. This feature should be equivalent to that provided by tools such as Microsoft's Visual Studio. This feature will be specially helpful while working with large Oracle Package Bodies or Stored Procedures.

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Ability to execute single stored procedure or function from package
   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Generate comparison report in csv format

   It is easier to open a light-weight comparison result export for large amount of data

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Source Control support like you have in the SQL Server Studio product

    Source Control support like you have in the SQL Server Studio product

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. Ability to open all objects (tables, packages, views' bodies, etc.) in read-only mode

    Also, in case of need, ability to select an item from the drop-down list in order to modify the object. Just as it's implemented in Data Editor (very useful function).

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. The windows are opened and closed on the same hot keys

    The windows are opened and closed on the same hot keys

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. Hide connection name in object explorer optionaly

    the ability to hide the connection name in object explorer

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. Add panel with procedures/functions list into package body/declaration

    Add a panel with a procedures/functions list into a package body/declaration.

    On double-click, navigate to a procedure/function.

    The panel should be minimizable.

    A similar feature is implemented in ZendStudio. Excepting, the structure of PHP or JS file is displayed as a tree. This is very convenient as the title is always at hand.

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. command line build

    Agile's methodlogy now requires Continuous Integration, which leads to a need for these DatabaseProjects to be built on a headless machine, like a build machine.

    Neither Studio nor Fusion seems to support compiling DatabaseProjects from the command-line. Whether it's a TFS agent or something like Jenkins, there is no opportunity for a UI-based tool to perform a task like this.

    I suggest one of two paths:
    a) Create a separate command-line executable that will compile these projects
    b) Translate the DatabaseProject schema to MSBUILD schema (and/or schema of others' choosing, like ANT) so that it can be processed natively by the build environment

    Since Fusion is specifically a Visual Studio plugin, it seems fair to demand that the custom database projects that come with it be in Visual Studio's MSBUILD language.

    Without some way to invoke DatabsaeProjects builds automatically, this product is dead in the water under Agile and CI.

    Agile's methodlogy now requires Continuous Integration, which leads to a need for these DatabaseProjects to be built on a headless machine, like a build machine.

    Neither Studio nor Fusion seems to support compiling DatabaseProjects from the command-line. Whether it's a TFS agent or something like Jenkins, there is no opportunity for a UI-based tool to perform a task like this.

    I suggest one of two paths:
    a) Create a separate command-line executable that will compile these projects
    b) Translate the DatabaseProject schema to MSBUILD schema (and/or schema of others' choosing, like ANT) so that it can be processed natively by… more

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. Allow changing case of keywords, table names, and column names and modifying template for resulting script

    When exporting data to SQL format (INSERT, UPDATE, MERGE):

    1. Allow changing the case of keywords, table names, and column names.

    2. Allow modifying the template for the resulting script.

    The template should be applied to every exported row and should have the text containing keys instead of which the values from exported rows are inserted. In the examples below the keys have the format :ColumnName

    Let's assume, we're exporting data to the MERGE format.
    The "testtable" contains:

    col1 col2 col3 col4
    r1c1 r1c2 r1c3 r1c4
    r2c1 r2c2 r2c3 r2c4
    r3c1 r3c2 r3c3 r3c4

    The system generates the following template:

    MERGE INTO "testtable" USING DUAL ON (COL1 = :COL1)
    WHEN MATCHED THEN UPDATE SET COL2 = :COL2, COL3 = :COL3, COL4 = :COL4
    WHEN NOT MATCHED THEN INSERT (COL1 , COL2 , COL3, COL4) VALUES
    (:COL1, :COL2 , :COL3, :COL4);

    It's hardly readable and may not correspond to corporate policies for formatting scripts.

    A user should be able to change it to:

    -- ':col1' - is ===:col2===
    prompt <:col1>
    merge into "testtable" using dual on (col1 = :col1)
    ..when matched then
    ....update set
    ......col2 = :col2, col3 = :col3, col4 = :col4
    ..when not matched then
    ....insert (col1 , col2 , col3, col4)
    ....values (:col1, :col2, :col3, :col4);

    or even (into several target tables):

    -- ':col1' - inserting a row into the main table
    merge into "myTable1" using dual on (col1 = :col1)
    ..when matched then
    ....update set col2 = :col2
    ..when not matched then
    ....insert (col1 , col2)
    ....values (:col1, :col2);

    -- myTable11 ':col1', ':col2' - inserting a row into the subordinate table "myTable11"
    merge into "myTable1_1" using dual on (col1 = :col1 and col2 = :col2)
    ..when matched then
    ....update set col3 = :col3
    ..when not matched then
    ....insert (col1 , col2 , col3)
    ....values (:col1, :col2, :col3);

    -- myTable12 ':col1' - inserting a row into the subordinate table "myTable12"
    merge into "myTable1_2" using dual on (col1 = :col1)
    ..when matched then
    ....update set col3 = :col3, col4 = :col4
    ..when not matched then
    ....insert (col1 , col2 , col3, col4)
    ....values (:col1, :col2, :col3, :col4);

    What does it need for?
    To ease maintaining production DBs.
    For instance, a dictionary was changed and needs to be updated.
    Filling a test DB with data and exporting to the script - it will be a patch.
    Applying the patch to the production DB.

    When exporting data to SQL format (INSERT, UPDATE, MERGE):

    1. Allow changing the case of keywords, table names, and column names.

    2. Allow modifying the template for the resulting script.

    The template should be applied to every exported row and should have the text containing keys instead of which the values from exported rows are inserted. In the examples below the keys have the format :ColumnName

    Let's assume, we're exporting data to the MERGE format.
    The "testtable" contains:

    col1 col2 col3 col4
    r1c1 r1c2 r1c3 r1c4
    r2c1 r2c2 r2c3 r2c4
    r3c1 r3c2 r3c3 r3c4

    The system generates the following template:

    MERGE INTO… more

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Display Null values as empty cells instead of "(null)"

    This is especially important if you are copying query results into Excel. You would normally want the absence of values to appear as blanks, rather than appear to be a value called "(null)".

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. Show notification when generating schema script for several schemas with 'Prefix object names with a schema name' option being unchecked

    would be nice to confirm when you multiselect and do "Generate Schema Script".

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. SDO_GEOMETRY Compare : EQUAL or Not

    It will be very powerfull to compare two fields of type SDO_GEOMETRY without using Locator/Spatial module and syntax, too heavy.

    dbForge Studio for Oracle will just compare if the two Geometry is Equal or Not.

    For the code, i see two way :
    - compare the 4 or 5 five array of the Geometry Objcet
    or
    convert SDO_GEOMETRY in String and compare it

    We don't need to see difference between geomatry just identify if geometry change between two tables (local/remote).

    thanks for your vote

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Bookmarks for DB objects

    When solving a specified task, you need to work with some group of DB objects such as tables, packages, etc.

    I would prefer to have the ability to collect them all together in one node of the tree in Database Explorer.

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close