dbForge Studio for MySQL
-
Code Refactoring
auto-change of source code containing a procedure, function, view, or table name if renamed or moved to another schema.
101 votes -
Export resultset as SQL
Exporting resultset not as CSV and so on, but as SQL insert statements, for example, just how phpMyAdmin can
90 votes -
Integration with Version Control System
Need integration with version control systems (Bazaar, SVN, GIT). Store and retrieve objects (SP, Func, etc.) and DB schema at all. Diff, history, etc.
Just like in Eclipse, but (file) == (SP, Func and other DB schema objects)72 votes -
Visual query builder to work with update / insert / delete queries
like in M$ Access
67 votes -
Flat table editor without popup for each column
With preview of maded changes (ALTER TABLE code);
With copy/paste for columnsAs HeidiSQL: http://www.heidisql.com/screenshots.php?which=table_editor
50 votes -
Copy or Move via Drag & Drop
Copy or Move via Drag & Drop of any item to another schema & across connections
30 votes -
Colors for datatypes
Displaying fields of different types in different colors, as example int* - blue, char* - green etc, in data editor and table editor. Maybe in compare tool.
As HeidiSQL: http://www.heidisql.com/screenshots.php?which=grideditors
26 votes -
Add SQL 'Scripts' folder to connection/object type list
Add 'Scripts' folder location tab to 'connection' setup dialog and you would get this:
<connection>
......Tables
......Views
......Procedures
......Functions
......Triggers
......Events
......UDFs
......Scripts
......SQL_ScriptsPerhaps even consider ability to enable a auto-maintained 'sql_scripts' table to any schema for unified storage. Browse to SQL_Scripts, right-click to Edit/Run, just like file system level scripts.
20 votes -
Ability to disregard white space in schema comparisons
Ability to disregard white space in schema comparisons
20 votes -
17 votes
-
Import data from multiple files at once
Data Import improvement
17 votes -
internal sample data generator
will be useful for rapid filling of data and study the performance, before it becomes a problem.
14 votes -
add data type in table\columns
add datatype in table\columns view
like ms sqlexample
table1
+-columns
|-column1 (int)
|-column2 (varchar(20))13 votes -
Use UML or ISO notation for diagrams.
I believe these are more intuitive than the available notations.
12 votes -
Setting to enable working with a database in implicit transactions
In the database menu we can start, commit and rollback transactions. But sometimes I forget to start a transaction, work with a database and then I want to rollback my changes, but I can't.
Would be nice if we had an option to start implicit transactions when working with a database.
Of course there are statements that cause an implicit commit, but users should be aware about them.
So, one of the use cases can be like this:
I open a new SQL window, write a few queries and execute them. And then I see links (buttons) to commit or… more
12 votes -
We need possibility to draw more
We need possibility to draw free any colored lines vith arrows from any diagram point to any other diagram point - small visio line drawing as sample. Without any column linking - only any line drawing.
11 votes -
9 votes
-
Ability to group objects by prefix in Database Explorer
For instance, several tables (views, procedures, functions, etc.) have
identical prefix. So, it would be convenient to have these objects separated
into the following, let's say, two groups:
1.
Tables
--prefix1
---- table1
---- table2
......
--prefix2
----table1
---- table2
Views
--prefix1
----view1
---- view2
......
--prefix2
----view1
----view2
2.
prefix1
--Tables
----table1
----table2
......
--Views
----view1
----view2
......
prefix2
--Tables
----table1
----table2
......
--Views
----view1
----view28 votes -
7 votes
-
Show ALTER statement when editing object in Object Editor
When editing table structure using the GUI tool, there seems to be no way to see the generated ALTER TABLE statement.
(I still use MySQL Workbench to start the "alter table" wizard, copy the generated sql to migration scripts and cancel the wizard.)
6 votes
