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

243 results found

  1. We have multiple companies in our database, different db names, same schema. Can I reuse a model with a different db name?
    Reason is to troubleshoot data issues with your viewers...

    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  ·  Admin →
  2. 1) The floppy disk icon displayed on the toolbar button does not actually reflect the sense of the Save Table operation. When working with database editors, you expect the Apply Changes button on the table's pane or the column changes in the table are applied automatically.
    2) Turning off filtering is not really obvious as I couldn't find how to do it but to reopen the table. It's preferably to have the filter button to be able to turn it on/off and not to reset it when it's turned off.

    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 →
  3. Command line interface to run reports from windows or external applications.

    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  ·  Features  ·  Admin →
  4. When comparing this one with SSMS, there is a lack of EVENT management tool like SQL Server Agent. It is one great thing that MySQL has made the EVENT object free unlike MS with their express version.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)

    You can modify or create events using Event Editor as follows:

    1. Expand a connection in Database Explorer.
    2. Expand a database.
    3. Right-click the ‘Events’ node and select ‘New Event’ or expand the ‘Events’ node, right-click an event, and select ‘Edit Event’.

  5. There is Magento database (~250 tables). After updation to 5.0.76 when I tryed open any table in thid db for editing application freeze for 0.5 minutes. Before (5.0.67) it will ok.

    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 →
  6. Sometimes it´s necessary to move data between databases / tables. For the common use the backup facilities are good, but when it comes to selected Data (last change > ...) it fails.
    Wouldn´t it be nice to export data from a query or a view? And of course to be able to import it into some other database or table?
    Some kind of rudimentary replication.
    Might be handy for updating price / article / ... Lists and sales / jobs done ... between outlets of an enterprise?

    3 votes
    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 →
  7. My preferred method of joining tables is that the old table is equal to a field on the new table, this way the progression is older to newer in both declaration, and joining.

    Do you think it would be possible to offer an option to reverse the suggested ON clause to be older table/view to newer?

    Example:

    Instead of:

    Employee e
    INNER JOIN JobTitles t
    ON t.JobTitleId = e.JobTitleId

    You have:
    Employee e
    INNER JOIN JobTitles t
    ON e.JobTitleId = t.JobTitleId

    Thanks

    John

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  8. When editing table structure using the GUI tool, there seems to be no way to see the generated ALTER TABLE statement.

    (I still use MySQL Workbench to start the "alter table" wizard, copy the generated sql to migration scripts and cancel the wizard.)

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  9. Prevent editing of data in a sql query, if no primary key. Now it is allowed, and updates all data on the condition of the query, not the exact line.

    3 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  ·  Admin →
  10. 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 →
  11. add datatype in table\columns view
    like ms sql

    example
    table1
    +-columns
    |-column1 (int)
    |-column2 (varchar(20))

    13 votes
    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  ·  Features  ·  Admin →
  12. Sorry, I am total ignorant on this, but I to publish a major (5.000-10.000 items) searchable online database (the data is presently in MS Excel). Can your software do the thing for me (I am ready to learn, of course ;-)

    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  ·  Questions  ·  Admin →
  13. In SQLyog, there's a simple "copy entire database to another server", which allows to copy objects to another server in just a click.

    5 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  ·  Admin →
  14. In the query editor please make “Execute Current Statement” work when the caret is after the trailing semicolon! It is very awkward to have to type a semicolon, then have to press left, only to execute the statement.

    If there is no other statement on the line, there is absolutely no ambiguity as to what statement should be executed.

    Both MySQL workbench and Oracle SQL developer can do this, and there never was any confusion.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  15. I get a message "connection lost to mysql" always, so I need to click twice. The reconnection should be automatic. If there is a way to do this now, please let me know.

    2 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  ·  Features  ·  Admin →
  16. The LOB editor does not allow to save normal size pictures. It seams like a cutting of file while inserting (CRL+V) into it.

    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 →
  17. Add the ability to filter tables, views, fileds, etc. in Database Explorer.

    43 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  ·  Features  ·  Admin →
  18. When dragging two tables to the visual builder and attempting create a join between the two tables, the application hangs and an AppHangB1 error is received.

    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 →
  19. Now if i try to execute query if connection was lost (because of timeout, for example) annoying popup "Lost connection to MySQL server during query" appears. I need to close it and restart query.

    Very annoying on servers with small timeout.

    Suggestion: make at least one connection retry, before show this popup. Maybe make behaviour configurable.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Features  ·  Admin →

    Actually, this feature is already implemented. If you have the latest version of the product and it still doesn’t work, please contact technical support for help.

  20. On rightclick in editor - add to menu new features - comment and uncomment selected lines (like in Visual Foxpro IDE)

    0 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  ·  Features  ·  Admin →

    There is such a feature in dbForge Studio for MySQL. It can be accessed either from the ‘Standard’ toolbar or from the top menu by selecting ‘Edit→Advanced→Comment\Uncomment Selection’.

  • Don't see your idea?