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

134 results found

  1. 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 →
  2. Export table data or custom query data in Json format with the possibility of grouping by selected keys.

    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 →
  3. Currently the duplicate object is only capable of copying tables and other objects on the same host. There does not seem to be any reason why it could not work across hosts. Thsi would be handy to easily migrate objects from a development server to production.

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

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

  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. Automatic generation of database diagram schema and FK relations

    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 →

    Please note that you can drag’n’drop a database from Database Explorer onto a Database Diagram document that can be created by selecting ‘File → New → Database Diagram’ from the popup menu. Relations between tables will be displayed on the diagram. The database changes made on the diagram will be applied straight to the corresponding database.

    Please refer to the ‘Designing Databases with Database Designer’ and the following articles in our blog:

    http://blog.devart.com/how-to-create-mysql-database-in-one-shot.html

    http://blog.devart.com/getting-started-with-database-designer.html

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

  • Don't see your idea?