190 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 -
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…5 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 -
Create option in dbForge for Oracle object file extensions, then make add Fusion to VS File Extension dialog.
Fusion doesn't play well with SSDT in the same solution. Fusion grabs all .sql file associations. Double click on a .sql file in Sql Server Database Project and Fusion prompts you for a connection to Oracle. The only way to get the file loaded into SSDT Designer is to right click the file. This could all be solved if DevArt tokenized the file extension and allowed the user to choose: .plsql.
1 vote
AdminDevart
(_, Devart)
responded
When installing dbForge Fusion, it becomes the default editor for opening *.sql files and you are asked to select a connection in the dbForge Fusion’s dialog. Though, you can change the default editor in the ‘Open With’ dialog of Visual Studio. For this, please perform the following:
1. Select ‘File → Open File…’ from the main menu of Visual Studio. The ‘Open File’ dialog opens.
2. Select a *.sql file and click the down-arrow against the ‘Open’ button.
3. Select ‘Open With…’.
4. Select an editor and click ‘Set as Default’.
5. Click ‘OK’. -
sort document outline - makes finding procedures names easier
sort document outline - makes finding procedures names easier
1 vote -
Do not open stored procedure definition upon execution
Whenever I execute a procedure it opens automatically in an editor, is it possible to disable this or simply stop opening, if I really did want it opened it is simple enough..
0 votes -
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 -
fetch data is take too long time.
when i use VPN to get data. it take too long time.
1 voteAdminDevart
(_, Devart)
responded
Could you please provide us the concrete time interval the data fetch takes?
Please also provide us the full name and vendor of the product compared to which the data fetch of dbForge takes longer?
-
Adding ability automatical creating RelatedTables.mdet around the chosen table
Adding ability automatical creating RelatedTables.mdet around the chosen table with preliminary specifying of the quantity levels referential tables.
1 vote -
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
- Don't see your idea?