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

301 results found

  1. Print datareport directly from command line

    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)
  2. I am missing one feature from MySQL Workbench quite much - the "filter rows" feature that sit´s right abow the result grid. It let´s youe filter t he results quickly for a string, which I need maybe 100 times a day. This is much more efficient thant editing the query all the time (this can be quite long).

    4 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. I want to define the timezone for my current session within the connection parameters (Advanced).

    Today I fire the following SQL Script at first to the Server
    set session time_zone = "MET";

    For the character set you're already have such a feature!

    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)
  4. 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  ·  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)

    Could you please describe this in more detail and specify in what cases exactly this should be applicable?

  5. dbForge removes comments for the procedure parameters when I edit anything inside Parameter panel.

    Let’s say I have

    ...

    Code: Select all
    PROCEDURE host1355175te.spfcagain(
    IN p
    userid int /comment for the procedure parameter is here/, IN ppairid int, IN pdeb int, OUT o_res int)
    COMMENT 'Comment for the procedure is here'
    BEGIN

    ...

    “/comment for the procedure parameter is here/” will be removed if I, for instance, edit Comment via UI in Options panel or change parameter’s order.

    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)
  6. Add a setting by default, that once enabled - stores queries that affect metadata changes in a kind of transaction log locally on hard disk.

    Recenlty I've got a problem with hosting provider, who got DB dumps with only data in it, but it's lack of saving tables, procedures, views and UDFs. Its a fail.

    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)
  7. Hi,

    when opening a procedure and then Find the following should not happen:
    1. Look in: All open documents. Better: Current document
    2. If you search with 'All open documents' dbForge starts looking in the other open documents and not in the current document. It should first look in the current document.

    Ronald

    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  ·  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. In order to compare user lists, particularly for environment migration (DEV->QA->PROD), it would be helpful to allow multiple tabs of the Security Manager so that users lists can be quickly compared.

    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)
  9. LOAD DATA INFILE (Error Message "Fix")

    I am requesting that you add the DETAILS from the POPUP dialog to the OUTPUT window. So after you click OKAY, you still have access to the PROPER Details including DATA FILE ROW NUMBER!

    https://www.screencast.com/t/wAdjle8sHmal

    That is what I get once I clear the dialog. I get NO repeat of the "in row 1663857 of the data"

    It was in the POPUP message (Called Additional Information)

    https://www.screencast.com/t/DLfhMmAK5VZz

    It would be helpful.

    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)

    Please note that there is information on the error including the row number in the ‘Error List’ window that can be opened by selecting ‘View → Error List’ from the main menu (Ctrl+W, E).

  10. After you close a connection to database you can still execute queries on that database. It can be quite dangerous.

    I'd suggest a confirmation message if executing query on closed connection.

    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  ·  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. in the list of server connections would be nice if the color of the active connection (the little plug) was had more of a contrasting color between connected and closed.

    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)
  12. 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. A search bar across the top above column names after retreiving data (either by right clicking on a table and retreiving data, or after running a select query).

    The search bar would function as a WHERE statement clause to temporarly further refine the data.

    Example: data on a record needs to be quickly manually edited. With two clicks (one right on the table, on left on retreive data) I can retrive records from the table. Then typing in the search bar "id = 3728" (without the quotes) woulld then filter the results down to only those matching.

    Both SequalPro (Mac)…

    6 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. On the comparison result page, please provide an option to reorder the tables, so that the order of synchronization can be controlled.
    This would be useful if we don't want to disable foreign keys, but tables depend on each other, in a specific order, and data can be added to target also in a specific order

    6 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. In dbForge Fusion for MySQL, when you add a folder to the project in the Solution Explorer, right clicking on it does not bring up a menu. I added a folder named DataFiles to go along with Functions, Procedures, Tables and Views folders. When you right click on any of these last 4 folders you get a menu with the following choices:
    ... Add New File...
    ... Add Existing File...
    ... Add Folder
    ... Rename
    ... Delete
    ... Refresh
    ... Properties

    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)
  16. When you create a query window and run multiple queries, you get multiple tabs showing the data.

    If you then Ctrl-F8 to Execute Selection (either on new queries or existing) , you lose previous data tabs and they are replaced with the new one, by default it seems at least.

    Is it possible to stop previously run data tabs closing, either globally or by pinning individual tabs to stop them closing when you run new queries within that tab? Its extremely frustrating when trying to access multiple data sets, you have to create new query tabs and end up in…

    11 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)
  17. Allow you to pin data result tabs so that they don't close when you run a new window in the same query.

    Also if you re-run a query that matches an existing result set, only update that data tab, do not clear the others.

    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)
  18. Add option to play a sound when a execution completes. I often move to another program during processing and forget to check status

    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)
  19. During import of CSV data (and possibly other formats), one can use the 'Fill mapping' feature to automatically assign columns.
    This also works if the source columns are unnamed, however, the columns are filled in order starting from the first. There is no option to skip a specific column (e.g. identity column).

    Now, I have a large table with lots of columns. When importing, I wish to skip the first (ID) column and assign the source columns starting at the second target column, as the CSV file does not include an ID column.

    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  ·  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)
  20. It would be really useful to have functionality to backup database schema/data into separate files. This especially handy when it comes to source code control. I know some other desktop MySQL managers do have it for ages. It would be convenient to have such a feature in dbForge Studio so we can forget about using other MySQL desktop apps.

    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    This can be achieved in two steps using the ‘Structure’ and ‘Data’ options that are available on the ‘Backup content’ page of Database Backup Wizard that can be invoked by selecting ‘Backup and Restore → Backup Database…’ from the popup menu of a database in Database Explorer.

  • Don't see your idea?