Skip to content
← Customer Feedback for Devart

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

(thinking…)

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.

75 results found

  1. When we alter a table and we do a EDIT on the same table after, the changes are not visible.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  2. Be able to disable GroupDatabasePrivileges query from executing in Schema Compare and actually NOT RUN the query

    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)
    Close
    Close
    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)
    Close
    Close

  3. International date formatting not working

    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)
    Close
    Close
    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)
    Close
    Close

  4. database name

    DATABASE: test
    DATABASE: Test
    DATABASE: tEsT

    dbForge identify the same database and can't find tables because the database differs to others as identified with the same name

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    AdminDevart (_, Devart) responded

    Could you please describe it in more detail?

    Also, you may need to change or remove a database name in the ‘Database’ field of the Database Connection Properties dialog box (right-click the connection in Database Explorer and select ‘Modify Connection…’ from the popup menu).

  5. Find Invalide Objects

    == English ==
    The "Find Invalid Objects" wizard lists the following objects in the new version "dbForge Studio for MySQL 9.0.338":

    • Temporary tables are listed in Views as not being found
      In Vden Views, the temporary tables are e.g. created with the following command:
      WITH RECURSIVE TMP as Select .... from ...) Select ... from TMP

    • crdebug.ENTERMODULE2 is not found. It is searched in the respective database; but not in the cr_debug database.

    • crdebug.ENTERHANDLER is not found. It is searched in the respective database; but not in the cr_debug database.

    • No further objects from the cr…

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  6. Optimize sequence for constraint alterations

    When you alter several constraints, drops come before adds.

    Where the changes are simple, it should be safe to group them in order to minimize the time that the constraint is not in effect. I have some huge tables. If I alter three constraints to switch from UPDATE to RESTRICT, for example, the third constraint is inactive until the table is literally copied three times.

    There's another post about grouping the alter commands together, and this would make a big improvement where each change causes a table copy.

    In the case I just ran into, however, the generated script was…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  7. Start transaction read only

    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)
    Close
    Close
    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)
    Close
    Close

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

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  9. Commandline Issues

    Whem importing from Access Database tables with a space in the name do not work at all. Also I just updated to the latest version hoping it would be fixed and now when the console prints out how many records have been imported, it prints on a new line instead of same line.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    AdminDevart (_, Devart) responded

    > Whem importing from Access Database tables with a space in the name do not work at all.

    Could you please send us the imported file and let us know if you are importing into a new table or existing one?

    > Also I just updated to the latest version hoping it would be fixed and now when the console prints out how many records have been imported, it prints on a new line instead of same line.

    Could you please provide us a screenshot of this?

  10. Please save the current setting "Current Document" on the Find Dialog

    Please save the current setting "Current Document" on the Find Dialog. It defaults to 'All Open Documents' which is very dangerous

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  12. Support reserved keywords and events in MySQL 8.0

    dbForge Studio 2019 for MySQL 8.1.22
    When sync data between MySQL 5.7.25 and MySQL 8.0.15 and table have field name in reserver keywords, got error like "check syntax ", rank,", fields and tables names must be enclosed in apostrophes.
    MySQL 8.0 event like
    CREATE
    DEFINER = 'username'@'localhost'
    EVENT odatabase.eventname
    ON SCHEDULE EVERY '1' WEEK
    ...
    in GUI shows as "every '7' (SEVEN) weeks", but DDL is right.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  13. Fix start of comment detection at beginning of line

    When editing SQL code in dbForge for MySQL 7.3.137, there is a case where it fails to detect the "start of comment" delimiter, and incorrectly intreprets the remaining text on the line as SQL code. This breaks the syntax highlighter, auto-complete, and ability to save stored procedures, functions, etc.

    Specifically, when using a double-dash "--" to start a comment in MySQL, it normally requires whitespace after the double-dash to be interpreted as a start of comment delimiter. However, when the double dash is at the beginning of a line, it does not require whitespace.

    See: https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html

    Example:

    -- This is…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  14. Search text in trigger statement

    The text search in trigger statements doesn't work using the "Find box" with "Look in -> Current Document".

    Can you please solve this problem?

    Thank you very much for your great work!

    Francesco

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  15. When a list of data is displayed, the column type does not display correctly

    http://prntscr.com/hkty9q

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

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

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

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

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    AdminDevart (_, Devart) responded

    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.

  18. scroll 'wheels' do not work

    Whether used on my laptop with a touchpad or my desktop with a mouse, dbForge Studio doesn't support scrolling in any window by any means other than clicking or dragging the scroll bar. It will initially scroll for perhaps a second and then it stops.

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

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

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    AdminDevart (_, Devart) responded

    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.

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
    AdminDevart (_, Devart) responded

    Hello,

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

2 4
  • Don't see your idea?