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. 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 →
          • 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
              I agree to the terms of service
              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
                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 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.

              • 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
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                • MySQL data to JSON

                  Export table data or custom query data in Json format with the possibility of grouping by selected keys.

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

                                            This can be workarounded by using the MySQL command “SOURCE”. For example, in the new SQL file, you can type the following:

                                            SOURCE .\sqlfile1.sql;
                                            SOURCE .\sqlfile2.sql;

                                            SOURCE .\sqlfileN.sql;

                                            Here, instead of the local path .\ you can specify it explicitly as follows:

                                            d:\folder\sqlfile.sql

                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base