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

131 results found

  1. Be able to see results of recent queries in data view

    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 →
  2. For columns included in foreign key constraint Data Editor will allow to view and pick master records from popup editor.

    4 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 →
  3. Data Editor with allow to edit result set of a SELECT statement containing JOIN clause.
    Data Editor toolbar will contain a combo-box that allows to chose table to edit. This table columns are highlighted and all other columns are grayed.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Features  ·  Admin →
  4. Allows to get correct filtering results when only a portion of data is fetched from server (e.g. when paginal mode is on)

    4 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 →
  5. Add the ability to connect through a proxy server

    4 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 →
  6. 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.

  7. add possibility to ctrl+F to find text in LOB 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…)
    0 comments  ·  Features  ·  Admin →
  8. It would be nice if the schema comparison included security. Security manager is great but if you are maintaining multiple databases, having to manually keep permissions in sync is a pain.

    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 →
  9. 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’.

  10. I would like to be able to generate either a single image (jpeg, png, gif) containing the whole schema, or page images. This would be really useful when publishing schema on a website for review.

    The perfect solution would be where dbForge Studio for MySQL could arrange for a mime type for their dbd file, and develop browser plugins to view the dbd (like the adobe pdf reader can read pdf's), which would allow pan and zoom to make reviewing larger schema easier.

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

  12. Navigation through Tabs (switching) by Ctrl-PgUp, Ctrl-PgDown as moder IDE do.

    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 →
  13. Instead of "allow NULL" call it "NOT NULL" in the table design general view (in line with SQL and most other tools).

    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 →
  14. Just like in MySql Workbench, the "new relation" tool in the diagram view should:
    - create foreign keys automatically (manual creation is error prune and just a lot more work)
    - it should create the respective indexes automatically

    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. Add '<-- Update' (source/left) during schema compare.
    Currently options are:
    '--> Update' (target/right)
    ' X Drop' (target/right)
    ' - None'

    If 'Source/Left' options AND 'Target/right' options are selected by the user, generate 2 separate scripts - one for each Schema

    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 →
  16. We are some DBAs on the company and we to share the projects folder, is there any way to export/import them? or better, to use a shared resource to use it? Normally we use SVN, so keep the project folder on a SVN working copy should be the best option.

    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 →
  17. 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 →
  18. 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 →
  19. In bigger procedures with a lot of nasted BEGIN-ENDs it would be very useful to have a shortcut key or right mouse button option to jump to BEGIN/END corresponding to the one on which you currently have cursor.

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

  • Don't see your idea?