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

240 results found

  1. Failure of any single change doesn't effect other settings (Project Path!)

    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  ·  Bugs  ·  Admin →
  2. 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 →
  3. 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 →
  4. 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’.

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

  8. excuse my english, is google translator

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  9. Preservation of the history of executed queries and open pages with the ability to view them from the menu, and re-open or execute

    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  ·  Questions  ·  Admin →

    Please note that you can view queries sent by dbForge Studio for MySQL as follows:

    1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Environment → Output’ branch.
    3. Select the ‘Log application errors’ and ‘Write queries sent by the program to the SQL Log’ options. To open SQL Log, select ‘View → Output’ from the main menu and switch to the ‘SQL Log’ tab in the ‘Output’ tool window.
    4. Unselect the ‘Delete application log after closing’ option.
    5. Click ‘OK’.

    The log file is saved in the directory with the application executable file (by default ‘programfiles\Devart\dbForge Studio for MySQL\’).

    Also, you can vote for the following suggestion:
    http://devart.uservoice.com/forums/225134-devart-general/suggestions/2455334-restore-tabs-windows-with-scripts-after-dbforge

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

  11. If OUT Parameter is INT or BIGINT
    and if result is NULL for OUT Parameter
    dbForge for MySQL returns 0 instead of NULL
    Please add this feature in your coming release.

    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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. In the query editor please make “Execute Current Statement” work when the caret is after the trailing semicolon! It is very awkward to have to type a semicolon, then have to press left, only to execute the statement.

    If there is no other statement on the line, there is absolutely no ambiguity as to what statement should be executed.

    Both MySQL workbench and Oracle SQL developer can do this, and there never was any confusion.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  16. Prevent editing of data in a sql query, if no primary key. Now it is allowed, and updates all data on the condition of the query, not the exact line.

    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  ·  Admin →
  17. 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 →
  18. Not open some of the procedures, don't know what it is, but with a short name opening all the time, and long not open > ~ 40 characters (can cause). The error message "Cannot parse the source code"

    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  ·  Bugs  ·  Admin →
  19. Command line interface to run reports from windows or external applications.

    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 →
  20. In latest version of dbForge while importing Excel 2007 file columns formatted as a date cannot be properly recognized as dates (they are recognized by dbForge as serial numbers) and due to this cannot be properly imported to the corresponding table fields. In older versions such bug hasn't had a place.
    Import date fields from Excel 2003 works fine in 6.3.330 version.

    BR

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