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

8 results found

  1. When submitting routines to SVN through 'Source Control', the SQL Security option is lost

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  2. Hello,
    When doing a data comparison and having an error, a message such as the following one is displayed:
    "Error (1,1): Duplicate entry 'WBAH2022-2' for key 'Old'"

    The problem is that, when the data comparison is against tables, it's not easy to find the table with the problem. It would be very useful to have, at least, the name of the table.

    Having also the value of the primary key would help further for this kind of error.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  3. allow the user to specify the header color for a table in a database diagram. ideally you would optionally be able to make it 'sticky' and affect the table in all diagrams

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  4. When comparing Stored Functions that return text values using Schema Comparison, it should display the correct character set and collation as reported by information_schema.routines.

    Currently, when comparing a MySQL 5.7 source host to a MySQL 8.0 replica of that source, Schema Comparison incorrectly reports the character set and collation of the RETURN value of Stored Functions that return text values on the MySQL 8.0 host. This leads to false positives in the reported list of schema differences.

    For example, actual RETURNS value:
    RETURNS VARCHAR(80) CHARSET utf8mb3 COLLATE utf8mb3generalci

    Reported RETURNS value (incorrect):
    RETURNS VARCHAR(80) CHARSET utf8mb4 COLLATE utf8mb4…

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  5. allow objects to be 'copied' between diagrams. I would like to be able to select a group of tables from one diagram and create a new diagram from those selected tables.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  6. SQL notebook that can be global or per database. This can be helpful for storing and retrieving reusable SQL queries without having to save and organize a bunch of .sql files in folders somewhere.
    This is especially useful for complex queries for specific DBs or global generic ones. Also for sharing with a team.
    Key word searching or tags would be nice as an option in it too

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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. In versions of MySQL prior to 8.0, integer values were specified with a "size", such as "INT(11)". In MySQL 8.0 and newer, the size property of integers is removed, resulting in the same value having the type "INT". This results in Schema Comparison across MySQL versions (5.7 vs 8.0) reporting false-positive differences for tables.

    The "ignore data types" option in Schema Comparison does not resolve the false positives, and is also probably too blunt, because column size does matter for text and binary data. Please add an option to specifically ignore differences in the "size" of integers.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  8. When comparing Views between MySQL 5.7 and 8.0, Schema Comparison detects "differences" to two conditions that are actually equivalent, resulting in false-positive change detection.

    1. Quoted text strings are prefixed with _UTF8 in MySQL 5.7 and _UTF8MB3 in MySQL 8.0. These are actually the same character set and represent no change. In fact, if MySQL 8.0 reported UTF8, it would be different, because in MySQL 8.0 the meaning of UTF8 is now UTF8MB4.
    2. In MySQL 8.0 Views, the schema prefix on table names (schema.table) is automatically removed when the schema of the specified Table matches the schema of the View. Therefore,…
    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  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)
  • Don't see your idea?