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

301 results found

  1. So that if a saved SQL query is being edited, it may be reset to what is currently saved on disk.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. Please add a switch key (SHIFT, CTRL or ALT) to the left mouse click behavior to open a table in design, text or data view with a single click.
    Also please give the ability to open many istance of the same table in data view to be able to apply different conditions in the Filter Editor for the same table.

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. It would be wonderful if you could activate or deactivate each condition in the Filter Editor like in the Navicat "Filter Wizard".
    PS: about the "Filter Editor" interface, I don't understand why there is no button in the toolbar to open it...

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. fix the toolbar so that it can not be accidentally moved during normal working.

    The fixation can be disabled/enabled in the toolbar configuration.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. feature to anylize query, and to determine whether optimization of the indices are needed

    39 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. dbForge Studio creates foreign keys and other constraints using the table name as a prefix. When we rename tables, the foreign keys remain using the old names, which most of the times we forget to change.

    It would be great if when renaming a table, there was an option or a question like "Do you want to rename all constraints too?".

    This would basically drop any constraint and recreate them using the new names.

    This shouldn't be mandatory, but it would be a great feature for early stages of database design, where you tend to rename and move things around…

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. I want "Edit Parametes"-Window not modal, but as a dockable window, because I often modify params, and I want to see SQL-Code AND Params at a look

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. I like for format my SQL like this...

    ----SELECT
    --------1
    ----FROM
    --------apple AS a
    ----INNER JOIN
    --------banana AS b
    ------------ON a.FruitID = b.FruitID
    ----LEFT OUTER JOIN
    --------lemon AS l
    ------------ON l.FruitID = l.FruitID
    ----WHERE
    ...

    But the closest I can get it to do automatically is this....

    ----SELECT
    --------1
    ----FROM
    ----apple AS a
    ----INNER JOIN
    --------banana AS b
    ------------ON a.FruitID = b.FruitID
    ----LEFT OUTER JOIN
    --------lemon AS l
    ------------ON l.FruitID = l.FruitID
    ----WHERE

    How can I get the table name in the FROM clause to indent one level further?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. A user variable (AKA:session variable) not showing in the autocomplete list. Variables defined using the DECLARE syntax show up fine but those created using the "SET @" method do not.

    BEGIN

         DECLARE v1 INT;
    
         SET @v2 = 1;
    
         SELECT
                  1
         FROM
                  users AS u
         WHERE
    

    END

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Additional validation when saving a procedure to check that all variables used exist either as parameters or variables would be very handy.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. When defining the parameters for a Stored Procedure using the UI. Could the TAB key navitgate through the columns in the list "Name", "Type" and "Direction"? It would make it much quicker to add these if the hands can stay on the keyboard.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. Add formatting options for REPLACE statement

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Add a button in the menu to turn off automatic syntax check and a button allowing to perform a one-time syntax check.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. I suggest you to add dividing line to connection browser. It's will be useful to divide projects on groups, if i have many similar projects.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Reading full description of the view from the file where it is defined by using SELECT LOAD_FILE(CONCAT(IFNULL(@@GLOBAL.datadir, CONCAT(@@GLOBAL.basedir, 'data/')), 'db/<view>.frm')) command.

    More info at: http://forums.devart.com/viewtopic.php?f=23&t=27305

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Add option for layout in which the table details are shown by default (Split or Combined). Now, it always defaults to Split.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. It is a bit annoying when you have lots of connections in the Database Explorer and can not find a specific one. An option to sort connections by their name and the ability to search connections via name and/or host would be nice and helpful.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. For many cases, one can design a Pivot Table accompanied with a Chart/Graph BUT THERE is NO way one can use the CHART anywhere else apart from JUST seeing it there yet sometimes the concerned person needs to export and use the chart for further reporting needs...

    Love to have a functionality that provides for Saving Chart as png, jpg, jpeg, etc ... or even pdf

    Thanks
    Stephen

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?