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

  7. 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 →
  8. 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 →
  9. 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 →
  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. 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 →
  12. 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 →
  13. 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 →
  14. 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.

  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. Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).

    I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).

    2 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 →
  17. 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…

  18. 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 →
  19. 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 →
  20. Having the ability to compare formatted versions of stored procedures would allow to ignore stored procedures that are identical even if they are not formatted exactly the same.

    The performance cost would be marginal compared to the usefulness of sorting out equivalent stored procedures.

    When comparing code, what it does is what is important.

    1 vote
    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 →
  • Don't see your idea?