78 results found
-
Open a Table (Data View) direct in the Script with a shorcut
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 -
Ability to generate reusable schema synchronization script
Sometimes you need to update a database with the synchronization script generated when comparing two schemas. However, this script will not always be executed against the schema used for generating this script (the developer has run the comparison between the earlier and present schema, generated the script and sent it out to the administrators of the customer, for example). Locally, the earlier schema has been manually modified and, as a result, the updating script executed only partially and the rest produced errors. After some changes, there appears a need to execute it again, whereas the first part of the changes…
0 votes -
Suffix the file name of a generated report with Date and Time
When generating a report, the default report file name is always the same as the Comparison Name, and each generation by default overwrites the previous report. Suffixing the default file name with Date and Time would be more userfriendly and avoid the accidental loss of reports.
1 vote -
Retain report generator storage location in dcomp file
When generating a report, the entered report storage location is not retained and needs to be entered every time.
1 vote -
Set default encoding in user's preferences
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 youBTW this form does NOT seem to work in IE8 that we have at work. Won't accept the password...
10 votes -
Support for UNION operator in Query Builder
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 -
Itemize IO according to each step in plan of Query Profiler
The main reason the tool was considered by my company was its SQL profiling feature. My company is currently looking for a tool to assist with SQL query performance and tuning. The SQL Profiling feature only captures IO metrics at the query level. It does not itemize the IO according to each step in the plan.
0 votes -
Schema Compare Sequence with different start with
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 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 -
Automate creation of triggers with sequence for autoincrement
Automate creation of triggers with sequence for autoincrement like in Toad.
Example:
CREATE OR REPLACE TRIGGER STATUSTRG
BEFORE INSERT
ON TDR.STATUS
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
-- For Toad: Highlight column ID
:new.ID := TDR.STATUSSEQ.nextval;
END STATUS_TRG;
/0 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 -
6 votes
-
Reverse navigation after performing Go To Definition with F12
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 -
sort document outline - makes finding procedures names easier
sort document outline - makes finding procedures names easier
1 vote -
Ability to view list of private procedures/functions in package body from Database Explorer
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 -
Ability to manage database connections pool
Could you add a property on the Database Connection Properties(Advanced Tab) to handle the connections number of the database pool in order to limit the number of connections.
Thanks.1 vote -
Make dbForge not to hang when editing table with GUI
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 -
highlight selection matching in editor
when a piece of code or text is selected in editor, matching expression should be highlighted.
Ie I double click on my variable (str_name for instance), the variable is highlighted everywhere it appears in the file ...1 vote -
Comparison and Snapshot
Some RDBMS distinguish between schema owner and data user. The data users schema is using synonyms to the schema owners schema.
While the data user has an higher limit of sessions the schema owner has a limit of 1 session only.
Here comes my feature idea - it would be good to ensure, that at least taking a snapshot is working with 1 connection only. Currently taking a snapshot and comparing schemas require more than 1 sessions.
But both of those functions (snapshot, schema comparison) are core functionality for schema maintenance and customer support.Thanks
1 vote
- Don't see your idea?