Skip to content

dbForge Studio for MySQL

dbForge Studio for MySQL is a universal set of MySQL GUI tools for database management, administration and development. It enables to create and execute queries, develop and debug MySQL routines, and automate MySQL database object management in the convenient environment.

http://www.devart.com/dbforge/mysql/studio/

dbForge Studio for MySQL

Categories

JUMP TO ANOTHER FORUM

299 results found

  1. 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 Gregory

    I 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
    1 comment  ·  Features  ·  Admin →
    How important is this to you?
  2. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  3. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  4. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  5. While viewing records in data comparisons, add abilty to view in column side-by-side (as currently available) -OR- by row stacking

    5 votes
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  6. 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 eg

    mystupidclient_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
    1 comment  ·  Features  ·  Admin →
    How important is this to you?
  7. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  8. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  9. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  10. 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;database3

    4 votes
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  11. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  12. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  13. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  14. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  15. Print datareport directly from command line

    4 votes
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  16. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  17. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  18. 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
    planned  ·  1 comment  ·  Features  ·  Admin →
    How important is this to you?
  19. 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
    0 comments  ·  Features  ·  Admin →
    How important is this to you?
  20. 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
    1 comment  ·  Features  ·  Admin →
    How important is this to you?
  • Don't see your idea?