Users should be able to work with jobs.
Support jobs scheduling through Oracle Scheduler125 votes
On Ctrl+Click on function/user type/proc/etc name should open new(or already opened) editor with cursor on that object.115 votes
Group multiple database connections into single tree node in Database Explorer. Eg.
[+] Environment 1
[-] Environment 2
[+] DB Connection 1
[+] DB Connection 2
[-] Environment 3
[+] DB Connection 3
[+] DB Connection 4108 votes
It looks like you support GIT in other product within the company, and it would be very helpful for Sudio for Oracle to do as well.58 votes
If you select Package to open the cursor is focused on the package . If you select Package Body to open the cursor is focused on the package body. Regardless when one is opened the other should always be open. Or an option to set it up that way55 votes
Add visual editor for Oracle tablespace.46 votes
Integrated SQL-PL\SQL Help would be helpful.42 votes
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>
Just like in dbForge Studio for MySQL to make it to ping a server in order to keep the connection alive. This will save your time on reconnecting to the server.28 votes
Every item in the object hierarchy should include Extract DDL option (=Generate Script As...), naming is not important. For containers, it would extract schema for all objects within that container. For example, if I do it on Indexes, it would get me Drop/Create/etc. script for all indexes currently defined on this table.19 votes
When the mouse cursor is over the identifier, show also comments in the hint along with the other information on the database object16 votes
select t.col1 ,
/* if I not put comma then next "t." not have columns in dropdown*/
from table1 t
if I insert t. between previously written columns
columns in dropdown not exist.
Make spellchecker disable by settings13 votes
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
Suppose for most tasks, I will only be using [CURRENTUSERSCHEMA_NAME] and [SYS]. Within each of them I do NOT need Packages, Procedures, Functions, User Types, Materialized Views/Logs, Synonyms, Clusters, Database Links and XML Schemas. dbForge should have a global user preference to hide unused options.11 votes
The program should automatically identify related tables along with relations when a user selects a master table
When working with Master-Detail Browser, the program should automatically identify related tables along with relations once a user selects a master table so then it's enough just to choose the relation from the dropdown list instead of performing additional actions as it's implemented in IBExpert.11 votes
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 ?
BTW this form does NOT seem to work in IE8 that we have at work. Won't accept the password...10 votes
It would be great to put the text with aligned by width (or by name in case the column name is longer than data) columns into the clipboard. This will result in a nice looking table in the text editor (when using a monospaced font).
Such a capability is used by testers when they find errors in data and copy blocks into the task's content (RedMine system etc.).9 votes
Comparing a Sequence with a different start with value is always displayed as equal in the comparison-results.
CREATE SEQUENCE EXAMPLESEQ START WITH 61 INCREMENT BY 1;
CREATE SEQUENCE EXAMPLESEQ 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
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
- Don't see your idea?