299 results found
-
Comma separated values when copying cell data
When you copy cell data, for example 5 ids, I would like to be able to copy them as comma separated data in order to use in IN statements.
For example, if you have 3 rows of results like the following:
id name
1 George
2 John
3 GregoryI wish to copy ids as comma separated values in order to use them in a Select statement like:
SELECT * FROM temp t where t.id in (1, 2,3)5 votes -
Duplicate Current Code line
This is a proposed SQL Document shortcut key. When working in Text view, there is a shortcut using Ctrl + L:
Delete current code line and copy it to clipboard
I propose a similar shorcut using Crtl + D:
Duplicate current code line
This will make a copy of the current line right below it. This is especially useful when creating new queries based on the current one that may only require slight modification to the parameters.
5 votes -
SQL History: log in plain mode without parameter
I know that in SQL LOG dbforge could store ALL query sent to DB. It would be great if dbforge stored them in plain form with parameter already substituted (not with :p1, :p2 .. and so on)
5 votes -
SDE Full Document Recovery Options - when dbForge app crashes
This is marketed as an enterprise-grade dev tool. After years of use I was astounded to discover dbForge doesn't have decent full document recovery when the app crashes. The app doesn't crash much so it is a shock when it does, and then takes your unsaved SQL development code with it.
Every editor should be auto recoverable upon reload - SQL editor, Query editor, Stored Proc editor. All open windows in dbForge should be offered for recovery upon relaunch.
5 votes -
data comparisons, add abilty to view by row stacking
While viewing records in data comparisons, add abilty to view in column side-by-side (as currently available) -OR- by row stacking
5 votes -
set aliases for tables once and use in all sql scripts from then on
I would love to be able to right click on a table and set an alias for that table that would then be used in the alias for scripts from then on rather than having to edit them each time
for egmystupidclient_table
i could set an alias of stupidClient to it
so when I typed
select from mystupidclient_table
autocomplete would use the alias for the table i previously specified to give
select from mystupidclient_table stupidClient
ideally we could autocomplete on the specified aliases with a seperate hotkey, tab vs ctrl->space perhaps where one…
4 votes -
drag and drop column names into query
Multi-select column Names (works).
Drag and drop as a COMMA List in the SQL Editor (does not work)Even better, if the SQL Text area is empty or being dropped after a ; with no open SQL statement, include "Select " + $fields + " from " + $table with it!
4 votes -
algorithm option for view
Specify the algorithm for creating a view and check if the view be created with this algorithm. E.g. the Merge algorithm don't work if you use a group by clause.
4 votes -
Remember backup/restore directory on a per-connection basis
Currently, the target directory for backups and restores is remembered between sessions as a global setting, affecting the whole application.
We store in separate directories for each connection or each database. It would reduce mouse clicks if Studio remembered the target directory of backup and restore operations on a per-connection or per-database basis.
4 votes -
multi default database
It's great if I can choose many database as default at start. Currently it just support one default database
May be it will be like this: database1;database2;database34 votes -
add UI for sorting and searching for connections in the database explorer
I have about 100 database connections - these appear to be presented in creation order, so I have to remember when I created something in order to find it
This view should at least have a sort option... Others have suggested search, which would also be a great help
4 votes -
AWS IAM Authentication
AWS RDS databases support IAM authentication. This makes managing user credentials across our dozens of deployed databases much easier to manage. It would be great if you client was able to use IAM credentials. Should be able to use the default profile if not specified or specify a profile to use. Refreshing credentials after the 15 minute expiration would be a great feature to support as well.
4 votes -
Get format from server
For datetime and decimal types dbForge Studio has its own definitions. You should add a setting that will get the format from server and preferably it should synchronize changes for example if I execute
SET lc_time_names = 'tr_TR';
it should change UI format accordingly.But as a former developer and DBA admin (both mssql) I expected to see result of my query formatted in server and session parameters. For example if I set language to US English in Sql Server for my session all the datetimes in my results shown in US format both in Management Studio and my .Net…
4 votes -
Warn about the use of @ in Stored proc parameter names
I used @ in a SP parameter name and spent some time trying to figure out why my procedure didn't work.
Turned out you can't? use the @ character in the name.
In the SP builder it might be handy to restrict invalid characters in param names.
4 votes -
we need ability to print datareport from command line
Print datareport directly from command line
4 votes -
tin the list of server connections would be nice if the color of the active connection |(the little plug) was nore contrasting between
in the list of server connections would be nice if the color of the active connection (the little plug) was had more of a contrasting color between connected and closed.
4 votes -
Conditional breakpoint
Hi, there is a suggestion for improvements :
It could be usefull to have possibility for conditional breakpoint in Stored Procedure debuging. For example, in a procedure, i put a breakpoint, but i want the process to stop only if some variable has a specific value.
And by the way, it could be also usefull to see the value of a use variable. For exemple, if a define a variable vvar, when the mouse cursor is over the variable, i can see an info about this variable, but if i define another like @vvar (with the @ prefix),…4 votes -
Add an option to set default data formats used when 'Copy Data As'
Currently the data format for some field types like date, datetime, time, etc, has a default formatting which is not modifiable when using 'Copy Data As' feature, it changes to a format that isn't working for me now, so it will be nice to set default formats by the user
4 votes -
I would like the ability to copy the values from the Parameters grid in dbMonitor.
I would like the ability to copy the values from the Parameters grid in dbMonitor. We use a lot of GUIDs for values, and it would be so much easier to be able to copy the values from dbMonitor that were used as parameters, or that were returned from stored procedures.
4 votes -
filter rows
I am missing one feature from MySQL Workbench quite much - the "filter rows" feature that sit´s right abow the result grid. It let´s youe filter t he results quickly for a string, which I need maybe 100 times a day. This is much more efficient thant editing the query all the time (this can be quite long).
4 votes
- Don't see your idea?