Skip to content

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

220 results found

  1. Support system versioned table syntax and settings toggle for tables/columns in mariadb 10.3+
    For example
    SELECT * FROM mytable FOR SYSTEM_TIME ALL
    is not detected as valid syntax, nor is it suggested for code completion
    Also need to be able to turn on/off system versioning per column/table in edit table dialog.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. We would store the connection information in comment, there is no problem when we first create the table in SQL script, but once we want to modify and generate the script from dbForge Studio, comment field get trimmed and stored information is missing

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  3. copy databaes not works when we try copy from ndbd to innodb cluster.
    if exist options skip engine it will be works

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  4. On 4 K monitors displayed letters appear very small, difficult to read and another slightly bigger problem is, that some notifications and input boxes overlap and hide themselves a bit, f.ex. in IMPORT DATA function.
    I currently help myself with changes in screen resolution.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. all my apps have a dark mode.. it hurts my eyes to use yours

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. In MariaDB (as of 10.1.1), compound statements are allowed outside of stored procedures - see https://mariadb.com/kb/en/library/using-compound-statements-outside-of-stored-programs/.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Mysql database copy from innodb to ndbcluster is not possible becuase when we copy we can't chose without engine set. In result on cluster each database use same engine as source (not clustered)

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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)
  8. i upgraded to mysql 5.7 because i want to profit from the virual field feature. dbforge studio for mysql does not yet implement an editor for formulas in virtual fields.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. In the present solution, you can't copy databases from MySQL ndbcluster - cluster to standalone MySQL.

    not work from cluster to normal server because when we copy
    we cant unselect engine type (on normal server not exist ndbcluster engine )

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. When I insert new record to table using table editor, ( id int(11) UNSIGNED NOT NULL AUTO_INCREMENT ) new field doesn't give the proper ID number. Seems like the editor can't find next free ID on auto increment field

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  11. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. I dont need data types in column headings, it disturbs me.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. The databse charset set to "utf8mb4" and the collation set to "utf8mb4generalci". The table set as same as database, this field same as database. But when run query statement, all the chinese character was unreadable, the comment of field does too. For the comment of field, the correct string should be "地区Id", when I edit the table, he character look such as "鍦板尯Id". The other mysql studio works fine, such as MySql Workbench, Navicat.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  14. After a few hours open, either maximized or minimized, it gets frozen, I cannot click in any button. It is like if an invisible modal button is blocking the input. This is the latest version 7.3.131. please let me know how can I help you find the issue

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
  15. 17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  7 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. Few people still use email clientes in their laptops these days. I frequently see errors in dbForge Studio, I frequently find errors on the new 7.3 version, but I cannot send them.

    It's 2018, please create an API to receive these errors without requiring email clients.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Save opened windows before close the application

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    This can be achieved with the Database Project feature. You can add the necessary documents in the project, save it and select ‘Load Last Opened Project’ under ‘Environment Settings’ in the ‘Environment → General’ branch of the ‘Options’ window. So, next time you open dbForge, your documents will be opened automatically.

    Also, by default, the documents auto save feature is turned. Despite the fact that the documents may have not been saved yet, next time you start dbForge, all tabs will be restored. You can specify the file types to restore in the ‘Restorable file types’ section of the ‘Environment → Documents → Restore’ branch in the ‘Options’ widow. The restorable files with corresponding paths are specified in the *.xml file that is located in the following folder:
    SystemDrive\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\

  18. Add a setting to give a custom alias or nickname to the query result tab that appears when executing multiple queries within the same SQL script.

    For example running 'F5' on the following queries:

    SELECT * from addresses a;
    SELECT * from buildings b;

    Will return two query result tabs named like so:

    TABS: [addresses];[buildings]

    (It seems dbForge names each resulting tab based on the primary name of the first table within each of the select statements)

    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  9 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Set the Data editing Mode (RO o. RW o. Ask) per Categories.

    Sample:
    Live = RO
    Defelopment = RW

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Please note that there is a feature allowing to change a connection’s color:

    1. Right-click a connection in Database Explorer and select ‘Modify Connection…’ from the popup menu. The ‘Database Connection Properties’ dialog opens.
    2. In the ‘Document Category’ drop-down menu, select the appropriate item or add a new one by clicking the three dots button against the drop-down menu.

  20. When backing up a database or creating CREATE script from a table, the auto_increment attribute is not set on a column which is not defined as a primary key.

    eg.

    CREATE TABLE wpquestionsformelement (
    elementid int(11) NOT NULL AUTO
    INCREMENT,
    formid int(11) NOT NULL,
    elementorder int(11) NOT NULL,
    element
    typecode varchar(50) NOT NULL,
    element
    params varchar(3000) DEFAULT NULL,
    questionid int(11) DEFAULT NULL,
    attachmentid int(11) DEFAULT NULL,
    mandatory bit(1) NOT NULL DEFAULT b'0',
    deletedflag tinyint(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (formid, element
    order),
    INDEX idxwpquestionsformelementelementid (elementid)
    )
    ENGINE =

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  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)
← Previous 1 3 4 5 10 11
  • Don't see your idea?