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. 5 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Disable foreign keys when deleting or truncating table

      When deleting or truncating a table I would like to have the option to disable foreign key checks for this operation. This could be a simple check box which is unchecked by default.
      If foreign keys are present, I either have to drop the database and recreate the whole schema or delete one-by-one figuring out the correct order or I have to write an SQL script with a lot of drop table statements and surrounding them with the foreign key checks setting.
      This is cumbersome, especially for development purposes when I have to clear test data very often or deploy…

      5 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
      • 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
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • Ability to import nested xml tags

          Your XML import only can deal with a single dimension of data. There is no way of dealing with the [Link] second hierarchy. Properly creating a schema and/or entities is very important now with web services and there are not many programs that can do it.

          5 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • execute selection

            Execute selection should execute all sql code if nothing is selected (the same as it is in Microsoft management studio).

            So if we click on a shortcat for "Sql -> Execute selection" and have no code selected dbForge should do "Sql -> Execute"

            5 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
            • 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
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                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.

              • Clustrix (ClustrixDB)

                Hi there, Clustrix uses mySQL protocol, so many third party db mangers work. There are some subtle differences, but nothing that others like Heidi, DbVisualiser or dbSchema couldn't handle. I'd like to try dbForge on my Clustrix project but connection says 'unknown variable: max_sort_length'.

                5 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                • Comma separated values when copying cell data

                  When you copy cell data, for example 5 ids, I would like to be able to copy them as comma separated data in order to use in IN statements.

                  For example, if you have 3 rows of results like the following:
                  id name
                  1 George
                  2 John
                  3 Gregory

                  I wish to copy ids as comma separated values in order to use them in a Select statement like:
                  SELECT * FROM temp t where t.id in (1, 2,3)

                  5 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                  • Include row count in SQL profile results page. Saves switching to data view to see # records retrieved.

                    Include row count in SQL profile results page. Saves switching to data view to see # records retrieved.

                    5 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • data comparisons, add abilty to view by row stacking

                      While viewing records in data comparisons, add abilty to view in column side-by-side (as currently available) -OR- by row stacking

                      5 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                      • Execution of a single query to multiple databases

                        Execution of a single query to multiple databases

                        5 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                        • SQL History: log in plain mode without parameter

                          I know that in SQL LOG dbforge could store ALL query sent to DB. It would be great if dbforge stored them in plain form with parameter already substituted (not with :p1, :p2 .. and so on)

                          5 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                          • drag and drop column names into query

                            Multi-select column Names (works).
                            Drag and drop as a COMMA List in the SQL Editor (does not work)

                            Even better, if the SQL Text area is empty or being dropped after a ; with no open SQL statement, include "Select " + $fields + " from " + $table with it!

                            4 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                            • Generate cleaner SQL

                              It would be really nice if dbForgeStudio generated cleaner SQL code. Currently, the code generated by dbForge is very confusing and differs too much from the code generated by hand. There is no option to turn some settings off.

                              This is a problem if we need to maintain SQL scripts that are manually edited later. Everytime we need to export a script, we need to manually format the code and remove all the unecessary stuff.

                              Some of the issues are:

                              1) Every identifier is escaped even if it is plain english text. View generation gets really confusing by escaping every…

                              4 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                              • Conditional breakpoint

                                Hi, there is a suggestion for improvements :
                                It could be usefull to have possibility for conditional breakpoint in Stored Procedure debuging. For example, in a procedure, i put a breakpoint, but i want the process to stop only if some variable has a specific value.
                                And by the way, it could be also usefull to see the value of a use variable. For exemple, if a define a variable v_var, when the mouse cursor is over the variable, i can see an info about this variable, but if i define another like @v_var (with the @ prefix), this doesn't…

                                4 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                • Set toolbar fixed

                                  fix the toolbar so that it can not be accidentally moved during normal working.

                                  The fixation can be disabled/enabled in the toolbar configuration.

                                  4 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Warn about the use of @ in Stored proc parameter names

                                    I used @ in a SP parameter name and spent some time trying to figure out why my procedure didn't work.

                                    Turned out you can't? use the @ character in the name.

                                    In the SP builder it might be handy to restrict invalid characters in param names.

                                    4 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 4 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

                                        Could you please clarify what exactly you are experiencing issues with and provide us a screenshot of any possible error?

                                        Please also specify what version of dbForge you are using.

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

                                      • 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
                                          I agree to the terms of service
                                          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
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base