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. Ability to syncronize just one object via right click with another database

    Sometimes is useful to sync just one object. It may be done via right click, choosing to sync data also in case the object is a table.

    4 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 →
    • Ability to Compare All Schemas in a Connection

      Rather than 1 schema at a time, allow to compare schema/data on a per *connection* basis, with an include/exclude schema list. For those of use with multiple schema's to compare this would be great!

      4 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 →
      • Add the ability to connect through a proxy server

        Add the ability to connect through a proxy server

        4 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 →
        • Get format from server

          For datetime and decimal types dbForge Studio has its own definitions. You should add a setting that will get the format from server and preferably it should synchronize changes for example if I execute `SET lc_time_names = 'tr_TR';` it should change UI format accordingly.

          But as a former developer and DBA admin (both mssql) I expected to see result of my query formatted in server and session parameters. For example if I set language to US English in Sql Server for my session all the datetimes in my results shown in US format both in Management Studio and my .Net…

          4 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 →
          • 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
            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 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.

            • return "Generate Schema Script" Feature

              Please, return "Generate Schema Script" Feature

              4 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 →
              • set aliases for tables once and use in all sql scripts from then on

                I would love to be able to right click on a table and set an alias for that table that would then be used in the alias for scripts from then on rather than having to edit them each time
                for eg

                my_stupid_client_table

                i could set an alias of stupidClient to it

                so when I typed

                select from my_stupid_client_table

                autocomplete would use the alias for the table i previously specified to give

                select from my_stupid_client_table stupidClient

                ideally we could autocomplete on the specified aliases with a seperate hotkey, tab vs ctrl->space perhaps where one autocompleted as it does now and…

                4 votes
                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  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                • Remember backup/restore directory on a per-connection basis

                  Currently, the target directory for backups and restores is remembered between sessions as a global setting, affecting the whole application.

                  We store in separate directories for each connection or each database. It would reduce mouse clicks if Studio remembered the target directory of backup and restore operations on a per-connection or per-database basis.

                  4 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 →
                  • Parent tabs for separate database instance

                    Hello, I love your software and I am using it, so for many years using and my developing experiences, how about if I handle on multiple database per project and I opened very much database's table, so I recommend software have a parent's tab for each database inside it's child tab. Its very efficient to work and easier to sort them, I will continue using your software is my core tools, so I hope this feature will be integrated soon.

                    Regard!

                    4 votes
                    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  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                    • Data Import

                      import from odbc source: ability to import a whole odbc database at once , with the option to create new mysql database

                      4 votes
                      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  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                      • Better error description when concurrency exception occurs

                        I opened a table and focused some data row. Then I created a new sql and did a few queries, one of them deleted a row in the table I've previously opened. But I didn't notice it. Then I returned to the opened table and edited the focused row (the one that was already deleted actually) and I got very generic error message, something like "An error has occurred during update operation". I spent a minute to understand that this is a concurrency exception because I've deleted a row I wanted to edit.

                        4 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  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                        • DB Health Analyzer

                          Implement MySQL server health monitoring tool that can visualize server workload, memory consumption, IO operations, etc.

                          4 votes
                          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 →
                          • Triple click anywhere on the line in the SQL editor should select the line.

                            To select a line you have to go to the gutter and click or do key strokes. Most editors allow a Triple-Click that expands to the entire line.

                            Double Click Selects the Word, Triple click selects the line

                            4 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 →
                            • 4 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 →
                              • Quick jump to corresponding BEGIN <-> END

                                In bigger procedures with a lot of nasted BEGIN-ENDs it would be very useful to have a shortcut key or right mouse button option to jump to BEGIN/END corresponding to the one on which you currently have cursor.

                                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 →
                                • Show amount of records for compared Source and Target tables

                                  On the Mapping page of the New Data Comparison wizard, show the number of the records containing in Source and Target tables.

                                  Sometimes it appears to be the only criteria to exclude quite large tables from synchronization.

                                  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 →
                                  • Solution based database explorer

                                    When working within a solution/project it would be nice to have only the databases listed in the database explorer that are actually needed by the solution.

                                    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 →
                                    • Option "Ignore errors" while synchronizing process.

                                      Now the synchronization aborts when an error occurs. Adding an option which overrules this behaviour and the synchronization process for a table continues.

                                      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 →

                                        Could you please provide us a screenshot of the synchronization you are referring to?

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

                                      • Column highlight in insert statement

                                        Tables with many columns (+20) becomes complex when you need to make insert. You need to make sure that the value is pointing to the correct column.

                                        It will be a great feature to have the highlighted column matched with the value in the insert statements.

                                        Like this:

                                        INSERT INTO dbo.MyTable
                                        (
                                        Id,
                                        Name,
                                        LastName,
                                        Age)
                                        values
                                        (1,
                                        'john',
                                        'Henrik',
                                        22)

                                        When clicking on the value John the Name column should be marked/highlighted. This means that the John value will be added to the Name column. And vice versa.

                                        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 →
                                        • Ability to turn off automatic syntax check

                                          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
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base