305 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 -
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 -
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 -
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 Compare All Schemas in a Connection
Rather than 1 schema at a time, allow to compare schema/data on a per connection basis, with an include/exclude schema list. For those of use with multiple schema's to compare this would be great!
4 votes -
Better error description when concurrency exception occurs
I opened a table and focused some data row. Then I created a new sql and did a few queries, one of them deleted a row in the table I've previously opened. But I didn't notice it. Then I returned to the opened table and edited the focused row (the one that was already deleted actually) and I got very generic error message, something like "An error has occurred during update operation". I spent a minute to understand that this is a concurrency exception because I've deleted a row I wanted to edit.
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 -
Naming Convention
It would be great, if I can set a naming convention.
Foreign Keys, Primary Keys, Table and Column name4 votes -
Validation of variables in procedures
Additional validation when saving a procedure to check that all variables used exist either as parameters or variables would be very handy.
4 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 -
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 -
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 -
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 -
Data Import
import from odbc source: ability to import a whole odbc database at once , with the option to create new mysql database
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 -
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 -
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 -
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?