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. Fix Stored Procedure Editor to accept ALTER TABLE xxx RENAME TO yyy

    As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.

    Here is a simple procedure that will trigger the error:

    DELIMITER $$

    DROP PROCEDURE IF EXISTS sp_test$$

    CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test`()
    MODIFIES SQL DATA
    BEGIN

    ALTER TABLE foo RENAME TO bar;

    END
    $$

    DELIMITER ;

    Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error message "Unable to parse…

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

      Could you please provide us the following information:
      1. Server version.
      2. Result of the following query:
      SHOW CREATE PROCEDURE sp_test;

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

    • high dpi font zoom

      in high resolution/dpi, like 2k or 4k under 30" screen, the control and tree font is too small and could not found setting to adjust.

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
      • Do not display Object Does Not Exist error when object exists

        Scenario
        -----------
        DB user has SELECT privileges on mysql.proc.
        DB user has ALL PRIVILEGES on schema_A, and NO PRIVILEGES on schema_B.
        DB user is running dbForge for MySQL 8.0.40
        A Stored Procedure (sp_A) in schema_A calls a Stored Function in schema A (fn_A).
        A Stored Procedure (sp_B) in schema_B calls the Stored Function in schema A (fn_A).

        Therefore, in the Database Explorer tree view, schema_A is listed, schema_B is not.

        Action
        -----------
        The user expands the list of Stored Functions in schema A, expands fn_A, and then expands the "Used By" list.

        Result
        -----------
        dbForge pops up an error message…

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • Data Editor - Option to show UPDATE/INSERT/DELETE statements before commit

          MySQL Workbench allows users to review the update/delete/insert SQL before committing a change in the data editor. This can be useful if you would like to run the same edits on multiple connections or you would like to perform similar edits.

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Group SQL Tabs by Connection

            MySQL Workbench allows shows a tab per connection under which it displays the SQL tabs. This makes it more difficult to accidentally run a query on the wrong connection.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
            • Ability to stop checking for updates

              Add a button or checkbox to the Update Now, Ask Later screen to have it stop asking you to update. We do not update a product unless there is a benefit to us. I am sure some others will feel the same.

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →

                This can be setup as follows:
                1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
                2. Navigate to the ‘Environment → General’ section.
                3. Unselect the ‘Check updates on startup once a week’ option.

              • При простое в работе (примерно через час) отключается таблица

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

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

                3 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

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

                • Update Devexpress

                  Update to the latest version of Devexpress. There has been alot of improvement since version 13. Version 18.1 is out currently

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Support Mariadb 10.3 or at least allow connecting to unknown future versions with just a warning.

                    I would much rather take the risk that something won't work quite right than be relegated to not even being able to try. Most things should work no matter what.

                    3 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                    • Data comparsion bug

                      In Data comparsion I see in "Only in Source" 29 rows. Problem is all rows are exists in the target Database! I have last (7.4.201) version of dbForge. Column "Different Records" ist will make data wrong too.

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                      • Ability to track temporary tables in debugging mode

                        I would like to be able to track the values in temporary tables via the watch window or have an ability to query them directly within that session. This is for complex reporting procedures that use temporary tables extensively.

                        3 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                        • Crashed automatically

                          During a long time runing and I havn't do any operation, the dbForge Studio for MySQL will crashed by itsell.

                          I see the windows event log like below, any solution?

                          Faulting application name: dbforgemysql.exe, version: 7.3.137.0, time stamp: 0x5a5750d3
                          Faulting module name: ucrtbase.dll, version: 10.0.15063.674, time stamp: 0x8ac9f9d4
                          Exception code: 0xc0000409
                          Fault offset: 0x000000000007350e
                          Faulting process id: 0x26fc
                          Faulting application start time: 0x01d398c7e6228539
                          Faulting application path: C:\Program Files\Devart\dbForge Studio Express for MySQL\dbforgemysql.exe
                          Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
                          Report Id: dc61c8e8-1ed4-44d0-8ac0-57011fb3f67a
                          Faulting package full name:
                          Faulting package-relative application ID:

                          2 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                            Could you please turn on dump generating as described below and send it to us for investigation?

                            1. Start Regedit.exe
                            2. Create a registry key:
                            “HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Windows Error Reporting\LocalDumps\dbforgemysql.exe”
                            3. Add the following values into it:
                            “DumpFolder”=“С:\\DbForgeDumpFolder”
                            “DumpType”=dword:00000002
                            “CustomDumpFlags”=dword:00001124
                            4. After the application crashes, send us the content of the folder “DbForgeDumpFolder”.

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

                          • Provide a new option to perform page breaks in output documentation

                            Provide a new option to perform page breaks in documentation when generating documentaion (e.g. at database table level). This would allow the documentation to be more readable for users. (SQL Documentor)

                            1 vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →

                              Could you please provide us screenshots of the actual and expected results?

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

                            • 1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • memsql support

                                Предполагается ли поддержка memsql? https://www.memsql.com/product/

                                База реализует протокол MySQL. к ней можно подключиться любым MySQL клиентом, но не DbForge. Выдает ошибку https://i.imgur.com/vDP8fI0.png

                                Вероятно связано с особенностями DbForge при подключении к MySQL.
                                Поддержка memsql практически ничего не стоит, так как используется MySQL протокол, зато можете написать, что DbForge очень крутой и поддерживает еще и эту memsql

                                С уважением, Сергей

                                1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Questions  ·  Flag idea as inappropriate…  ·  Admin →
                                • Be able to close connection from the stored procedure editor

                                  Not sure if it needs to be classified as a bug or a new features BUT!!!!
                                  I noticed today after our Aurora AWS Cluster failed over that I was not able to recompile a stored procedure I was altering.
                                  From a query window you can close the connection and an execute will open it again.
                                  But you can't close the connection from the editor!!
                                  And it's the same with Table Editor.
                                  I know you can close it from the DB Explore but it's inconsistent with the SQL Editor UI. You should have the same buttons.

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      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.

                                    • rent program for 10$ monthly

                                      plz make dbForge Studio for MySQL able to rent for 10$ monthly with full features. thanks

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Find and replace 'Look in' value setting

                                        It would be nice to be able to set the find and replace 'look in' value to a default. I personally don't like having it search all documents by default since all the other editors I use don't do this.

                                        3 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • read invalid view

                                          Cannot Edit Views if Column No Longer Exists. This was already asked before, but it still doesn't work. We still get "... references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them". This pops up all the time on complex projects and it's a pain to recover from with SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS when you guys could just try this automatically whenever the error occurs.

                                          3 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 18 19
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base