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

134 results found

  1. It's a common way to store Unix time data within INT fields.
    So it's not very convinient to operate with it on data tab.

    Suggestion to add «Show as date/time» option to column settings menu in data tab.

    Some like shown here: https://yadi.sk/i/NVBQYEEuc4FiP

    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 →

    The grid is intended for viewing data, but not for casting. We can recommend you to use a selection from this table turning the column UNIX date time into the FROM_UNIXTIME function.

  2. dbForge v6.2.280 won't work with timestamp(3) - can't see milliseconds

    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 →

    Please perform the following:

    1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Data Editor → Formatting’ branch.
    3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
    4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
    5. Click ‘OK’.

  3. Export data and sheme in one file!!!

    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 →

    This can be achieved as follows:

    1. Right-click a database in Database Explorer and select ‘Backup and Restore → Backup Database…’ from the popup menu. Database Backup Wizard opens.
    2. Move on to the ‘Backup content’ page of the wizard and select the ‘Structure’ and ‘Data’ options.
    3. Complete the wizard.

  4. Set the Data editing Mode (RO o. RW o. Ask) per Categories.

    Sample:
    Live = RO
    Defelopment = RW

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    Please note that there is a feature allowing to change a connection’s color:

    1. Right-click a connection in Database Explorer and select ‘Modify Connection…’ from the popup menu. The ‘Database Connection Properties’ dialog opens.
    2. In the ‘Document Category’ drop-down menu, select the appropriate item or add a new one by clicking the three dots button against the drop-down menu.

  5. Add a parameter in the command line interface in order to generate all the objects in separate files when performing a DB backup.

    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  ·  Features  ·  Admin →
  6. When editing a stored procedure, function, or trigger, statements that contain an escaped carriage return (\r) or newline (\n) are not displayed correctly in the editor. That is, they are incorrectly displayed as an actual carriage return or newline. To replicate, create a stored procedure with the line: IF LOCATE('\r', field) > 0 THEN ...

    Save the the procedure and then open it again in the editor.

    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. Save opened windows before close the application

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    This can be achieved with the Database Project feature. You can add the necessary documents in the project, save it and select ‘Load Last Opened Project’ under ‘Environment Settings’ in the ‘Environment → General’ branch of the ‘Options’ window. So, next time you open dbForge, your documents will be opened automatically.

    Also, by default, the documents auto save feature is turned. Despite the fact that the documents may have not been saved yet, next time you start dbForge, all tabs will be restored. You can specify the file types to restore in the ‘Restorable file types’ section of the ‘Environment → Documents → Restore’ branch in the ‘Options’ widow. The restorable files with corresponding paths are specified in the *.xml file that is located in the following folder:
    SystemDrive\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\

  8. 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  ·  Features  ·  Admin →
  9. 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…)
    completed  ·  2 comments  ·  Features  ·  Admin →
  10. 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 →
  11. Today 4K resolution are widely adopted and mixed with 1080p
    In windows, we can use font scaling according to the screen
    that feature isn't used in dbforge studio, when we move the software from one screen to another, the layout should be adapted according to the settings

    moreover, the size of the font isn't used everywhere (the database explorer, the properties, or even the modify table feature doesn't use it) and the icons size should be increased if seen on a 4K display

    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  ·  2 comments  ·  Features  ·  Admin →
  12. I would much rather take the risk that something won't work quite right than be relegated to not even being able to try. Most things should work no matter what.

    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 →
  13. Automatic generation of fake data in tables in new data gnration.

    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 →

    This feature is present in dbForge Studio for MySQL and can be accessed by selecting ‘Tools → New Data Generation…’ from the main menu.

  14. I dont need data types in column headings, it disturbs me.

    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 →
  15. I'd like that when I right click a table, choose Export Data then To SQL, I'd be given the opportunity to simply copy generated SQL to clipboard, instead of having to save it into a file (or, also, to open generated SQL in a new editor, without saving to a file).

    It would be nice to have the same in data view: I'd select a few rows, choose Export Data, choose a great new option "To SQL", and then could export to a file, clipboard or editor.

    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 →
  16. 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 →
  17. For example...

    WHERE
    ----X = 1
    ----AND Y = 2
    ----AND (Z = 3 OR Z = 4)

    Currently the OR will drop to a new line...

    WHERE
    ----X = 1
    ----AND Y = 2
    ----AND (Z = 3
    ----OR Z = 4)

    which is hard to read

    2 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 →
  18. When you change or create a table you need to manually refresh for code completion to pick-up the new changes.

    Would be nice for use lazy people if it refreshed with changes :)

    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 →
  19. Would love to see more smart and automated tools to migrate databases. Currently you must do a back up and restore. How about extending some of the tools to allow you to simple select source, destination, change some options, and move an entire database.

    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 →

    There are the Copy Database, Data Compare, Schema Compare and Script Folder features supported in the command line interface.

    Also, Exit Codes were added in the command line interface.

  20. Hi, I use your schema and data synchronisation features but with the data one I rarely (never) want to compare every table and some of the ones I don't need are quite large so I use the mapping features to de-select those I'm not interested in. Trouble is I have to do this every time as there's no way to save the connection and mapping details into a file for repeat use (if you've used Red Gate's Data Compare for SQL Server then you'll know what I mean).

    Any chance you can add this functionality in, please?

    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 →

    Please note that dbForge performs mapping identically to Red Gate.

    Once automapping is performed and the user specified objects are excluded from the mapping, you can perform comparison and then save it. When you open the save comparison, the previously saved user specified mapping gets restored. Such a behavior is also identical to the Red Gate’s one.

    If you perform automapping, exclude specific objects from the mapping, perform comparison, save, then close the document, make changes in Source and Target by removing the pair of the mapped tables and then adding the pair of new tables, then open the saved project, the saved mapping gets restored where possible. That is, the removed pair of the tables is excluded from the mapping. For the rest, the mapping is restored and the new pair of tables is mapped automatically. Such a behavior is also identical to the Red Gate’s one.

    Additionally, starting…

  • Don't see your idea?