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

59 results found

  1. 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…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  2. when adding a new table to a project, it is added to the bottom of the build order list. If I edit the list thru the project properties > build order tab, the order changes are not persisted. I have had to edit the xxx.mydev file manually (outside of visual studio) to get the build to create the .sql file with the table listed in the right order based on foreign key dependencies.

    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  ·  Bugs  ·  Admin →
  3. The autofilter on columns (in data views) allows you to select { value, blanks, nonblanks } -- except for DateTime columns. Those columns allow only a date selection or "All" -- we could really use an option for "All nonblank" like on other value columns.

    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 →
  4. CREATE DEFINER = 'camskpn'@'%'
    PROCEDURE cams_kpn.proctest(operation int, PID int, CID int, DID int, UID int, ct varchar(50), CLID int)
    BEGIN

    /*

    operations - Properties

    1 = Contract Select - PID ProjectID
    2 = Doc List - CID ContractID
    3 = Linked Documents - DID DocID
    4 = Ball in Court - DID DocID

    5 = Change Issues - DID DocID
    6 = Change Sources - DID DocID

    7 = Change Items - DID DocID
    8 = Filters - UID UserID
    9 = DocumentDetail - DID DocID
    10 = DocTypes
    11 = Stati
    12 = Change Categories
    13 = Approval Type…

    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 →
  5. v 6.3.341

    Open a SQL editor window, write a SELECT query - list the FROM tables, start to build SELECT clause.
    Don't save Query - leave open in editor. Open a Table being referenced in query, and add a new field. Switch back to SQL editor. The new field doesn't appear in the Intellisense drop down (or whatever you call the drop down box - MS call it Intellisence) as you type.
    I was doing this in the SELECT clause. I had also given the tables aliases in the FROM clause, if that make any difference.

    Many thanks.

    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 →
  6. sice today's release, time fields appear "1.12:45:00" instead of "12:45:00"

    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 →
  7. When checking for updates(Help | Check for Updates...), encode the Devart authentication login field. This way email addresses containing a plus(+) will not fail.

    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 →
  8. In your emailed advertisement the unsubscribe link does not work as a link. Suggestion: repair 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…)
    0 comments  ·  Bugs  ·  Admin →
  9. 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 →
  10. Under newest version (6.2.280) database explorer doesn't update, even after manually refreshing.

    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 →
  11. When exporting data to Excel you can specify a header and a footer to be add. But in the result they are not added

    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 →

    These parameters will be visible when you send the Excel document to print. You can check this on the preview stage.

  12. 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 →

    You can specify this in the ‘Column Separator’ section on the ‘Options’ page of the Data Export wizard.

  13. dbForge Studio for MySQL hungs if connection via SSH opened and not used long time. I am working with connection via SSH, then minimize or deactivate studio window for a while, then restore. Opening any database object will hung the studio.
    Sorry, I bad speak English.

    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 →
  14. The sha2 function is not highlighted in red in a SQL document.

    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 →
  15. When the number of displays (screens) connected to my laptop changes, DBforge often ends up an 'orphan' window that gets drawn in the non display area. IE where the user cannot see it or click on it.
    I can minimize dbforge to the task bar, but when it restores, it shoots off the screen beyond the active desktop.

    My other running applications handle this gracefully, and redraw their window positions in the active desktop area. This leads me to think the issue is with dbforge studio.

    This happens several times per day as I leave my desk to work (disconnecting…

    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 →
  16. When using Ctrl+Space to complete a user-defined variable name, the name in the select list is shown in the case intended by the user. On insert, the characters are all set to lower case. Since the case of a variable name was explicitly set by the user, the case should be retained when inserted, whether the insert was automatic or manually typed.

    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 →
  17. table contains datetime columns
    current data include year 0001 and 1899 along with more current dates.
    when double click table, get crash popup and the "year out of range" message.

    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 →
  18. Using identical configuration and credentials, v9.2.34 (and previous versions) connects to my AWS Aurora MySQL instance over SSL. However, the v9.2.105 update does NOT connect. It returns a dialog stating "SSL connection error (2026): The server hello message uses a protocol that was not recognized."

    I tried many configurations, but none worked. Uninstalled and downgraded, worked on first try. Updated to latest and repeated test, same failure.

    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 →
  19. 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 →
  20. The prefix "tmpdevart" is long. If the stored procedure being instrumented already has a long name, another 11 characters is a lot. Perhaps something shorter could be used just as easily and it would prevent errors about procedure name lengths being too long and failed debug compiles.

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