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

471 results found

  1. 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)
    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)
  2. With a right click, I can set the date and time to now, it would be nice to also have the possibility to set the value to "UTC now". This is important when the database is used across multiple time zones.

    9 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)
  3. right-click on cell -> Set value to -> custom value requested by input,

    actually I can set to 0 or null, but in my case y need value "1" or another value.

    I Actually re-paste values from same column to the rows needed, it's more easy for me set value to all column if I do a good search query before.

    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)
  4. Import from Onlyoffice with Nextcloud same as Google Sheets method

    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. can we have option to change font size, in table edit and toolbar many more required have change font size. because it is very difficult in big size monitor and specially have developer which high eye number issue. it is very difficult to read.

    when we are doing long time work, eye have pain, headache issue also.

    Thank you

    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)
  6. I'm not the DBA but a DB developer. I use PROJECTS to manage scripts and SQL tools by project and support ticket.

    I want to be able to define the various FIlter Setting within a project as well.

    Meaning, when I load a PROJECT, not only do I get access to my various SQL scripts for that project, but it also loads FILTER settings as well. We have a few thousand tables, and it's various tedious to keep redefined the filters when I switch projects.

    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)
  7. 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)
    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. Give an option to run SET sqlquoteshow_create=OFF; before a schema compare. So that the schema generated via MySql does not add the quotes to everything.

    6 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)
  9. 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)
    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)
  10. I have about 100 database connections - these appear to be presented in creation order, so I have to remember when I created something in order to find it

    This view should at least have a sort option... Others have suggested search, which would also be a great help

    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)
  11. On a table with system versioning, from context menu I select:
    Generate script as > CREATE > To new SQL window.
    And the output does not include SYSTEM VERSIONING data at all.
    When I run SHOW CREATE TABLE tablename - I get correct information.

    The same with "Edit table"
    (In general it would be nice to set, if "Generate script" uses dbForge engine, or from database "SHOW CREATE TABLE", because output sometimes is drastically different)

    2 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  ·  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)
  12. Implement the Database Diagram functionality that will be able reconnect to the cloned DB after work database is moved.
    Sometimes DB server for developers can be changed

    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. With new DBForge update (2020), keyboard shortcut to show/hide additional document views is gone. Please add this feature back as it was extremely convenient to show/hide data results when writing long procedures.

    5 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  ·  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. 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)
  15. Showing total rows next to record count example. "Record 1 of 302+ of 25000" or something similar, always knowing the total rows in a query or filter is very important

    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)
  16. Allow Skip Idénticas, remove or unmap. If one knows the databases are offline, idéntica tables will Stay the same and dont need to be recompared. Do better at managing Idénticas.

    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)
  17. When a new connection is created, it gets the name of the database.ip.add.re.ss, but when you have 100+ connections, it takes a long time to find the one that you need to work with, since typically the database names are the same, at least in my business. I need that the name be ip.ad.re.ss.database, and the IPs be sorted by IP, not alphabetically, si it would be faster to locate a connection.

    2 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)
  18. Be able to disable GroupDatabasePrivileges query from executing in Schema Compare and actually NOT RUN the query as its slow one som systems. In schema compare I have ignore privileges ticked, but the query still runs

    6 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  ·  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)
  19. See: https://i.imgur.com/FvTda6n.png

    Sometime in version 9, 'datetime' fields in tables and queries format to the American standard, even though the formatting options show an example of International formatting, this is not applied

    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  ·  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)
  20. In Properties section you can only view the tables properties, but if a additional view/option can be give to list the column names and type it will help alot for now one has to open the table each time to view these instead of a quick click on table and see iets columns.
    Also if those fields (name and type) can be selected for copy it will help alot
    as I use it alot in Workbench when developing.

    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)
  • Don't see your idea?