303 results found
-
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…
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 -
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 -
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 -
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 -
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 -
Naming Convention
It would be great, if I can set a naming convention.
Foreign Keys, Primary Keys, Table and Column name4 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 -
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 -
Ability to syncronize just one object via right click with another database
Sometimes is useful to sync just one object. It may be done via right click, choosing to sync data also in case the object is a table.
4 votes -
Hide sleeping connections in Session Manager
Add an option to hide connections in the "Sleep" state in Session Manager (like MySQL Workbench does).
In many cases an application holds an open connection to the server but is idle. Or the app keeps a pool of open connections, but only a few of them are being used.
Being able to hide connections in the "Sleep" state lets you see only the connections that are actively doing something right now, which is usually what you are interested in.
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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
- Don't see your idea?