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/

I suggest you...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. When you remove a button from a toolbar, that it stay removed.

    When you remove a button from a toolbar, that it stay removed after you close dbForge and open it again.
    I tryed to remove the execute entire script (F5) and only let the Execute current statement(F8) but I need to do it each time I open dbForge.

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    This issue will be fixed in the next version 7.4. We will notify you once it’s available for downloading.

  3. Table does not get renamed from initial caps to lowercase

    If you rename a table and change it from initial caps to lowercase, it doesn't get renamed. For example, you can't rename it from "Calls" to "calls".

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  4. Show refactoring changes in open tabs.

    There are numerous cases where renaming an object, like a table, or field does not update the source of an open stored procedure.

    Also, the auto-complete options in the editor are not updated when a new table or field is added, even if its added through the same connection and DBForge instance. Often I am presented with auto-complete suggestions that are completely invalid.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Please note that you can use the ‘Automatically refresh suggestions cache every xxx minutes’ option available in the ‘General’ branch of the ‘Options’ window that can be opened by selecting ‘Tools → Options…’ from the main menu.

  5. Refactoring does NOT take care of procudures and views

    This is a big problem for me.
    I renamed one table using the refactoring function.
    But all views and procedures which used this table were not automatically changed as I expected.
    Now I can't even open the views or procedures to manually edit them. All I get is: "unable to parse source text" which derives (so I think) from the now no more existing tables.
    I was able to edit the views with the help of phpMyAdmin. But I can't edit the procedure.
    This is a big issue for me.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Could you please describe the steps to reproduce the issue in details?

    Please also provide us the CREATE definitions of the objects.

    Additionally, please specify the version of dbForge.

  6. Process left in memory after program closes.

    Each new run left another instance. Eat memory, lock updates. All 7.x versions, last 7.0.52.0 too.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  7. Much improved syntax error and debugging experience in the template editor when using Entity Developer.

    Currently, when you are working with your own templates or ones you have modified, it is very easy to have a few syntax errors during your edits. It is my experience that the line error information is either not correct or entirely not working most of the time. Clicking on an error is useless since it does not actually take me to the error (sporadic and inaccurate). After minor template changes I made, I have often spent hours trying to figure out the error messages I get when I run, only to find some stupid one character mistake in the…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Could you please clarify what functionality you are referring to and provide us a concrete example of this? Screenshots would be also of help.

    You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom.

  8. how to change the color of "Select Marker"?

    when I want to choose the other colors to change the color of "Select Marker" in the menu of "Options --> Text Editor --> Font&Colors", the the border color of the "Select Marker" is the same as before, There is no change in the editor?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    We will fix this issue in one of the next product builds and will notify you once it’s available for downloading.

  9. Issue with Data Editor not respecting Edit mode set in settings after first edit.

    1. Options > Data Editor > General > Open Data Editor in read only mode
    2. Execute a SELECT statement. Data Editor shows up in Read Only Mode. Good.
    3. Flip Data Editor to Edit current table. Do one edit. Apply.
    4. (Optional: Flip Data Editor back to Read Only Mode)
    5. Execute a SELECT statement on ANY table. Data Editor shows up in Edit Mode on the current table. Disregarding both its last set state or System Setting

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    We will fix this issue in one of the next product builds and will notify you once it’s available for downloading.

  10. DB Forge Fusion conflicts with normal database projects

    When db forge fusion for MySQL is installed it makes it very difficult to work with Microsoft database projects.
    We need the ability to turn off DB forge fusion within visual studio.
    Or give the ability to switch back and forth.

    Right now it seems the only way to switch between them is to uninstall and reinstall. (complete not going to work)

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Could you please describe this in more detail? Please also let us know what’s the version and edition of your Visual Studio, dbForge Fusion and Windows operating system. Additionally, please let us know if your Windows x32 or x64.

  11. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Could you please provide us a concrete example of this?

    You can send a reply straight to our support system at supportATdevartDOTcom

  12. Combine ALTER Statements

    When making multiple modifications to a table, the generated SQL script contains multiple ALTER statements. For example, If I were to add 3 new columns to a table, the resulting script would be something like...

    ALTER TABLE table ADD COLUMN newcolumn1 INT;
    ALTER TABLE table ADD COLUMN newcolumn2 INT;
    ALTER TABLE table ADD COLUMN newcolumn3 INT;

    ... when these could actually be combined into a single ALTER statement like...

    ALTER TABLE table
    ADD COLUMN newcolumn1 INT,
    ADD COLUMN newcolumn2 INT,
    ADD COLUMN newcolumn3 INT;

    The 3 separate ALTER statements essentially take 3 times longer to run than the single combined…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  13. Fix JSON view colors for dark themes

    Using the JSON view in dark themes is annoying as there is no way to configure foreground colors for numeric data types so they are displayed as black on black

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  14. При простое в работе (примерно через час) отключается таблица

    При простое в работе (примерно через час) отключается таблица.
    и постом при возобновление использования минимум ВСЕГДА ДВА раза пишет , одну и туже ошибку( Lost connection to MySQL server during query (......:3306) Table:....... ) если нажать обновить .

    а иногда вообще даже кнопка обновить исчезает и пишет что 0 записей хотя они есть. приходится переподключаться, исправьте пожалуйста, этот баг

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Вы можете попробовать увеличить значение в поле ‘Тайм-аут соединения’ на вкладке ‘Дополнительные’ окна ‘Свойства соединения базы данных’ (щёлкните правой кнопкой мыши на соединении в Проводнике и выберите ‘Изменить соединение…’ в контекстном меню). Значение, равное нулю, означает бесконечность.

  15. GROUP_CONCAT

    Don't show GROUP_CONCAT in queries.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Could you please describe this in more detail and provide us the actual and expected results?

  16. EXPLAIN Partitions isn't working (but it used to in older versions)

    Version: 8.0.80 (Professional)
    Tried with MySQL 5.6 and 5.7

    Explain Partitions returns an error, but it works fine on the MySQL CLI.

    In dbForge I ran:
    EXPLAIN partitions SELECT * FROM log.log;

    And the error I got was:
    Table 'log.partitions' doesn't exist

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    This issue is going to be fixed in the next product build. Currently, as a workaround, you can run statement using F5 button.

  17. Fixing database in git repo

    When view contains some unicode notation for fields aka N' it shows difference over and over even after fixing.

    When field contined some collation it shows difference over and over.
    [ModelNumber] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

    Pls fix it asap. I have dozen of objects showing that they have difference however they don't

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  18. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  19. Floating Windows - why is this disabled for DB object tabs?

    I'm not sure if this is a bug or if I'm just "holding it wrong" but there doesn't appear to be a way to get object editing tabs to float. Windows like the Object Viewer do (though this is disappointingly without independent minimising controls) but if I'm editing a table or a sproc then the "Float" option is disabled.

    Is there a reason for this?

    Ideally I think it would greatly help the product if it were possible to float windows and group floated windows into one floating tab group and if each floating object can be minimised/maximised independently of…

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  20. When editing the build order, the changes should actually be saved to the xxx.mydev file.

    when adding a new table to a project, it is added to the bottom of the build order list. If I edit the list thru the project properties > build order tab, the order changes are not persisted. I have had to edit the xxx.mydev file manually (outside of visual studio) to get the build to create the .sql file with the table listed in the right order based on foreign key dependencies.

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

dbForge Studio for MySQL

Feedback and Knowledge Base