301 results found
-
Display in output window when query started
If it is not possible to display how long current set of queries is being executing (in a status bar next to word "Executing..." - I don't see quite honest why it is not possible), how about to show start time in an output window saying when query was sent to execution. Right now it shows only AFTER query has returned a result which is some what becomes irrelevant.
I come from MS SQL and it is handy to know how long any query is executing without profiling it.
6 votes -
Recognising parameters in 'design SQL' mode
When editing a stored procedure, the 'design SQL' mode is very useful to visualise and modify the design of the statement - except when the stored procedure contains a parameter. 'Design SQL' does not recognise the parameter for what it is and instead tries to interpret as a reserved SQL word and kicks out an 'unknown identifier' error. Would be great if the 'design SQL' editor would recognise the parameters and not kick out the error.
1 vote -
check fields exists
Deep sysntax check of stored procedures/functions.
1. Check all variables defined (error, blocks save)
2. Check all defined variables used in code (notice, not blocks save)
3. Check fields exists in tables
4. Etc. Check list can be extended in future.3 votes -
Smart explain integration
Advices to use indexes in queries
2 votes -
Option to rename constraints (PK, FK, indexes, etc) when renaming tables
dbForge Studio creates foreign keys and other constraints using the table name as a prefix. When we rename tables, the foreign keys remain using the old names, which most of the times we forget to change.
It would be great if when renaming a table, there was an option or a question like "Do you want to rename all constraints too?".
This would basically drop any constraint and recreate them using the new names.
This shouldn't be mandatory, but it would be a great feature for early stages of database design, where you tend to rename and move things around…
11 votes -
Generate cleaner SQL
It would be really nice if dbForgeStudio generated cleaner SQL code. Currently, the code generated by dbForge is very confusing and differs too much from the code generated by hand. There is no option to turn some settings off.
This is a problem if we need to maintain SQL scripts that are manually edited later. Everytime we need to export a script, we need to manually format the code and remove all the unecessary stuff.
Some of the issues are:
1) Every identifier is escaped even if it is plain english text. View generation gets really confusing by escaping every…
4 votes -
Add alternative ways to open table and ability to open many instances of same table
Please add a switch key (SHIFT, CTRL or ALT) to the left mouse click behavior to open a table in design, text or data view with a single click.
Also please give the ability to open many istance of the same table in data view to be able to apply different conditions in the Filter Editor for the same table.0 votes -
Filter Editor with selectable conditions
It would be wonderful if you could activate or deactivate each condition in the Filter Editor like in the Navicat "Filter Wizard".
PS: about the "Filter Editor" interface, I don't understand why there is no button in the toolbar to open it...3 votes -
Ability to turn off automatic syntax check
Add a button in the menu to turn off automatic syntax check and a button allowing to perform a one-time syntax check.
3 votes -
Show up non-declared variables (i.e. @xyz) in autocomplete suggestions
A user variable (AKA:session variable) not showing in the autocomplete list. Variables defined using the DECLARE syntax show up fine but those created using the "SET @" method do not.
BEGIN
DECLARE v1 INT; SET @v2 = 1; SELECT 1 FROM users AS u WHEREEND
0 votes -
Option for default table detail layout (Split/Combined)
Add option for layout in which the table details are shown by default (Split or Combined). Now, it always defaults to Split.
13 votes -
Ability to indent table name in FROM clause but have JOINS on same level as FROM
I like for format my SQL like this...
----SELECT
--------1
----FROM
--------apple AS a
----INNER JOIN
--------banana AS b
------------ON a.FruitID = b.FruitID
----LEFT OUTER JOIN
--------lemon AS l
------------ON l.FruitID = l.FruitID
----WHERE
...But the closest I can get it to do automatically is this....
----SELECT
--------1
----FROM
----apple AS a
----INNER JOIN
--------banana AS b
------------ON a.FruitID = b.FruitID
----LEFT OUTER JOIN
--------lemon AS l
------------ON l.FruitID = l.FruitID
----WHEREHow can I get the table name in the FROM clause to indent one level further?
1 vote -
Add formatting options for REPLACE statement
Add formatting options for REPLACE statement
3 votes -
I suggest you to add dividing line
I suggest you to add dividing line to connection browser. It's will be useful to divide projects on groups, if i have many similar projects.
1 vote -
Usability: Highlight important Tables
PLEASE SUPPORT ME:
7 votes
AdminDevart
(_, Devart)
responded
You could use the ‘Database Project’ functionality as described below:
1. Select ‘File → New → Blank Project’ from the main menu.
2. Drag’n’drop the connection from Database Explorer onto Project Explorer (select ‘View → Project Explorer’ from the main menu).
3. Drag’n’drop the specified tables from Database Explorer onto Project Explorer.
4. Save the project by selecting ‘File → Save NewProject As…’ from the main menu.Now, whenever you open the project, you will have your favourite tables in a convenient place.
Please also see the ‘Managing Database Projects’ node in the product’s Help documentation.
-
Please integrate backup scheduler within DbForge
Please integrate backup scheduler within DbForge
13 votes -
Can I export the "source" of a report as php-script
To design a report with the studio and exporting it as a php-script for easy include or link.
best,
Philipp1 vote -
Naming Convention
It would be great, if I can set a naming convention.
Foreign Keys, Primary Keys, Table and Column name4 votes -
Data comparison: mark data not matched if destination doesn't exist or is empty
When performing data comparison, test destination for existence and number of rows before comparing. If destination table doesn't exist or is empty, all data in the source can be marked as not matched, saving the time of the actual compare operation.
1 vote -
Positioning of cursor while editing
Hello,
when the editor recognizes a command it automatically adjusts the lines.
Problem ist that the cursor does not follow!
Example: You are in line 2 of your SQL command and the editor adjusts the format to 4 lines. You continue to type, but not at the end in line 4 but somewhere in the middle in line 2 of the command.Ronald
1 vote
- Don't see your idea?