Skip to content
← Customer Feedback for Devart

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

(thinking…)

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.

74 results found

  1. Routine code gets whipped out when a parameter added

    If you editing a code of a routine (procedure or a function) but has not compiled it yet and then you add a parameter, the code of the routine gets refreshed and you loose all the code code you wrote before latest compilation. There was no such an issue in older versions of dbForge for MySQL (tested on 10.1.24)

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  2. Source control lost SQL SECURITY options

    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)
    Close
    Close
    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)
    Close
    Close

  3. Fix Schema Comparison issue for Stored Functions that return text values

    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)
    Close
    Close
    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)
    Close
    Close

  4. copy and paste

    copy anda paste from view data and excel not work

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  5. bug in table edition with graphic table editor

    the table designer has a BUG. A table column can have as a default value an internal server variable, in my case @@bindaddress. The correct way to add it (@@bindaddress), and it works. But when the table editor reverses a table definition, it misinterprets these defaults and saves it back wrong.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  6. Allow variable identifiers to be user defined to accommodate multiple environments.

    We are unable to define delimiters for variables. This causes query code from dbForge to fail when copied to a java based production environment.

    Currently the dbForge variable delimiters are not compatible with many environments.

    Provide means for users to define variable delimiters like DbVisualizer does.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  7. "Modify via SQL" always Refresh automatically before opening Editor

    When we work in Stored Procedures we already overwrote accidentially code as we were working in different windows and worked on an old version of the code

    It is annoying to always need to refresh first to make sure that no old copy of the code is edited.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  8. Erro no atalho

    Erro no atalho , como copiar e colar... ctrl+q para filtrar... f5 para execultar

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  9. Compare data bases lists table as different, thought they are the identical

    When comparing databases, we constantly get the tables with no differences. And final script doesn't have any alter statements.

    Ex.: the table
    CREATE TABLE SecurityContextXSiteGroup (
    SecurityContextId INT NOT NULL,
    SiteGroupId INT NOT NULL
    )
    ENGINE = INNODB,
    CHARACTER SET utf8mb4,
    COLLATE utf8mb40900ai_ci;

    ALTER TABLE SecurityContextXSiteGroup
    ADD UNIQUE INDEX SecurityContextXSiteGroup_UN(SecurityContextId, SiteGroupId);

    ALTER TABLE SecurityContextXSiteGroup
    ADD CONSTRAINT SecurityContextXSiteGourp_FK FOREIGN KEY (SecurityContextId)
    REFERENCES SecurityContext(SecurityContextId) ON DELETE CASCADE ON UPDATE CASCADE;

    ALTER TABLE SecurityContextXSiteGroup
    ADD CONSTRAINT SecurityContextXSiteGourpFK1 FOREIGN KEY (SiteGroupId)
    REFERENCES SiteGroup(SiteGroupId) ON DELETE CASCADE ON UPDATE CASCADE;

    The other table ("differs"):
    CREATE TABLE SecurityContextXSiteGroup (
    SecurityContextId INT NOT…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  10. Facilitate MariaDB 10.11

    The current version of DB fORGE STUDIO supports up to MariaDB 10.6 which is limited in respect of JSON functionality. With respect to querying you cannot join a regular table on a JSON path or use methods like JSON_TABLE(). Such efforts result in an error.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  11. There is a problem using "groups" word as name for table or part of a stored procedure

    There is a problem using "groups" as a name for a table or using that word as part of a stored procedure.

    I have a table named like this and when trying to make a backup I always get the same error message: Unexpected symbol 'groups'

    If I try to compare 2 schemas it also fails.

    In my case I use dbForge Studio for MySQL Professional Edition v9.1.21

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  12. Profiling for queries with CTEs

    When running the query profiler on a query that contains CTEs, the results are not accurate and the Explain Plan section does not appear in the profiler tree.

    To profile queries with CTEs I have to re-write them as subqueries which is a waste of time and makes it more difficult to read.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  13. update grid alert

    When choosing to edit a record from a select, an alert always appears that shows us the following:

    "Unique key is missing"

    This in previous versions only appeared when you did not indicate the primary key. Now it always appears even if it is a select * from anytable;

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  14. Selected cell of Data-Compare goes blank

    Awesome product btw - (just) one annoying bug:
    This relates to the top part of the data compare section; any selected cell to pick a related view turns white and doesn't show the number anymore - just the checkbox. Same for the source or target object name.
    (Moving away to see the number again resets the list view; looking at the tag bubble of the list requires searching the columns since the position is always shifting based on the length of all numbers. Not so much fun on large data sets)
    Thanks for your fantastic work,
    Regards,
    Martin.

    (customer since…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  15. убрать дурацкое модальное окно "невозможно распарсить код" во время редактирования SQL

    убрать дурацкое модальное окно "невозможно распарсить код" во время редактирования SQL

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  16. modify your Database Design Diagram options to include the ability to manually force a one to one relationship. Currently not able to do so.

    See above

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  17. Character set 'perlogicalinterfacedtoview' is not supported

    Comparing two databases I encounter this error.
    I have selected "Detect mysql charset" as I am advised by the error message.
    However I keep receiving this error.
    Is there a way to manually add some encodings?
    I have updated the application to the latest update.
    DB forge Studio for Mysql Pro.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  18. Add support for "Stored Aggregate Functions"

    The ability to create stored aggregate functions was added in MariaDB 10.3.3. but dbForge do not read they.

    https://mariadb.com/kb/en/stored-aggregate-functions/

    I see the functions in the tree, but when I try to open they I get an error like "Unable to parse source text", and when I try to backup a database that contains Stored Aggregate Function it fails.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close

  19. Export to MS Excel 2007

    Currently, exporting to MS Excel 2007 more than 1048576 rows, dbForge doesn't slipt to a new Sheet the remaining rows.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  20. You have a bug, this stored procedure has legal text, you can compile it, but it cannot be edited by the tool.

    You can compile this stored procedure but you cannot edit with your tool, it says that the code is wrong, but it is not.
    CREATE DEFINER = 'root'@'%'
    PROCEDURE simulation.comparebill()
    BEGIN
    with mybill AS(
    with billing AS(select c.day AS day,c.code AS code,cast(c.seconds as double) / 60.00 AS Mins,
    case when r.code is null then 0.005 when c.jurisdiction = 'Inter' THEN
    r.inter when c.jurisdiction = 'Intra' then r.intra else greatest(r.intra,r.inter) end AS rate,
    ifnull(r.description,'Missing Destinations at $0.005') AS description
    from (cdr c INNER join ratedeck r on(c.code = r.code))) select billing.day AS day,billing.description AS description,
    round(sum(billing.Mins),2) AS Minutes,
    round(sum(billing.Mins * billing.rate),2)…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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)
    Close
    Close
← Previous 1 3 4
  • Don't see your idea?