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

71 results found

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

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Bugs  ·  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. 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…

    14 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  ·  Bugs  ·  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. When choosing to edit a record from a select, an alert always appears that shows us the following:

    "Unique key is missing"

    This in previous versions only appeared when you did not indicate the primary key. Now it always appears even if it is a select * from anytable;

    9 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  ·  Bugs  ·  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. When I editing storage procedure and I add START TRANSACTION READ ONLY;
    it is marked as error ';' expected

    8 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  ·  Bugs  ·  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. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

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

  6. 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".

    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  ·  Bugs  ·  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. 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)

    6 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  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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.

  8. 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.

    6 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  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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.

  9. Be able to disable GroupDatabasePrivileges query from executing in Schema Compare and actually NOT RUN the query as its slow one som systems. In schema compare I have ignore privileges ticked, but the query still runs

    6 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  ·  Bugs  ·  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. With new DBForge update (2020), keyboard shortcut to show/hide additional document views is gone. Please add this feature back as it was extremely convenient to show/hide data results when writing long procedures.

    5 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  ·  Bugs  ·  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. 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.

    5 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  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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.

  12. See: https://i.imgur.com/FvTda6n.png

    Sometime in version 9, 'datetime' fields in tables and queries format to the American standard, even though the formatting options show an example of International formatting, this is not applied

    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  ·  Bugs  ·  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. 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  ·  Bugs  ·  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. 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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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.

  15. 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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

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

  16. 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 SQLLatin1GeneralCP1CI_AS NOT NULL

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

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

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

    3 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  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

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

    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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

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

  18. 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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Hello,

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

  19. 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

    We're glad you're here

    Please sign in to leave feedback

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4
  • Don't see your idea?