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>
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
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
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
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
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...7 votes
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
Source Control support like you have in the SQL Server Studio product6 votes
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
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
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
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
It would be nice it there is a shortcout to open direct a selected Table from a Script.
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
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
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
New feature: Hide columns in table diagrams with a specific names defined by the user. For example: "TimeStamp", "LastUser" , etc.
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
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
vi key-bindings in sql editor would be amazing!3 votes
- Don't see your idea?