303 results found
-
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 -
Retrieve Data select top x rows
Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).
I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).
2 votes -
Allow per column, per table grid display configuration
We work with tables that need to display the data in a format that is meaningful to us. Default display in grids doesn't cut it these days.
Allow us to add custom display formats for any field including binary. This could be done by maintaining a small embedded database per table and column. Then allowing a dialogue to select or enter new formats.An extension to the configuration dialogue for date time display could be a starting point.
Once done, this configuration can be applied to any column and any table.
Doing this would instantly cure all the feature requests…
1 vote -
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 -
Toggle USE <database> statement
Hello,
I'm currently looking into available tools to perform DDL and DML comparison from the command line for an automation project of database continuous delivery. So besides a tool running from the command line it also needs to be able to generate the necessary scripts.
After a day of playing around with both dbForge schema and data compare, everything is looking fine and they seem to be good candidates for this project.
Unfortunately I'm currently stuck with one challenge. As the comparison phase is only done once, in the beginning of the automation chain, the generated scripts need to be…3 votes -
select as default when i right-click on a table
the context-menu should on top always display - "select data" (not retrieve?? - no other product shows this option)
currently, if i right click on a table - on top is "new table" which is ok when i select "tables" but here it is senseless.
1 vote -
It would be more reasonable if wizard has also a direct sql optimizer
It would be more reasonable if wizard has also a direct sql optimizer
1 vote -
Colored background for editor
I know you added some colors to differentiate between dev, stage, prod etc., and it's a good start, but it needs to go further like Toad does. They allow you to make the whole sql editor background color to be changed.
9 votes -
Use SHOW ENGINE X STATUS
When an error occurs when you update a table you only get generic error messages that don't mean anything. Using the SHOW ENGINE INNODB STATUS in my case will give me a really nice description of what actually has happened.
It would be great if on errors dbForge queries the SHOW ENGINE INNODB STATUS and returns a more dev friendly error message.
3 votes -
Display field comments in the database diagrams
There are 3 options to display fields in the database diagram:
* Field names only
* Field name & type
* Field name & precise typePlease, add 1 more to display Field name, type and comment.
It will make the diagram more clear for a person who doesn't know the database structure well enough. As they won't have to click on every table to see what exactly those fields mean.
3 votes -
Execution of a single query to multiple databases
Execution of a single query to multiple databases
8 votes -
When adding revisions, allow searching by commit hash
A nice improvement to the process of adding revision(s) to a review would include the ability to search by commit hash.
In our agile process, a "story" that is ready for code review generally has the last commit hash (or a list of the commit hashes) documented somewhere on the card/case/whatever-you-call-it. Given this information, it would be really nice to simply copy that hash and be able to search for revision(s) when starting a new review.
7 votes -
when debugging stored procedures, pass data to the procedure by string instead of a table input
It seems that data passed to a procedure can only be done via table input instead of by string as would be carried out by callableStatement in java. Otherwise awesome work.
1 vote -
[Data Compare] Replace a column value with a static string
When synchronizing the database it would be nice to be able to replace a certain column with a string. For example, when you sync the user table to a test database, you dont want to get all the production email address, but would like to replace it with 'test@test.com' or something.
11 votes -
Convert a LINQ query to Stored Proc/View
A great feature would be a LINQ to SQL tool for SP/Views.
I write complex queries in LINQ with linqPad, grab the generated SQL and then create a SP/View from this code.
It's an error prone process with complex queries creating parameters
1 vote -
Todo/Task list for Database Project feature
To expand on the Project feature a Todo/Task list would be awesome as it would help me keep track of things I've done and haven't!!
2 votes -
Restore scrollbar position after refresh `object update`
Needs to Restore scrollbar position after refresh
object updatepressed.
Point: open data view on table with many rows and columns, then list it to some position for viewing certain data. Then this data changes by outside query and I need to view changes for that. After I pressupdate databutton, then data table position skipped to begining even the number of rows still same and only cell values had been changed.1 vote -
Add the ability set a global file->open language when opening SQL pages
Currently there is no way of setting the default language to read a SQL script.
Users must select 'File -> Open File...' in the main menu EACH time they open a file and tell the program which language the page is encoded in
Within my (local) Environment, my default language (set by Windows) is Western European, however I save all my scripts as UTF-8 (65001) by default as my deployment environment is on a UNIX server
it would be very much appreciated if I could save my default "Open As..." information somewhere in the IDE Options
I'm sure other developers…
3 votes -
Multirow update in data viewer
In the data viewer, I can update a single row, however, I often want to update all returned rows. It would be nice to right click on the column and set all rows to the same thing. As is, I have to recraft the query to be an update -- not hard, just annoying (unless I cant, in which case, the exporting of a list of pks into a update is more painful).
Love the software otherwise.
3 votes
AdminDevart
(_, Devart)
responded
This can be achieved with the functionality implemented in the new version by right-clicking in the data grid and selecting ‘Generate Script As → UPDATE’ from the popup menu.
-
Pivot Table Generate (DDL/Scheme) to export SQL.
Example:
http://www.codeproject.com/Articles/363339/Cross-Tabulation-Pivot-
Tables-with-MySQL1 vote
- Don't see your idea?