301 results found
-
Support backtrace on exception in debug mode
When I run a sequence of stored procedure calls and somewhere in there an error occurs, the debugging session just ends. If the error could have happened at multiple places then it would be very helpful to have a back trace of the last line to successfully execute or the one that failed to execute.
3 votes -
Ability to manage host and db privileges on security screen
The security screen allows management of global privileges (across all databases on a server), or object-level privileges (within a given database). What's missing is the portion in between - specifiying which databases or hosts a users' privileges apply to (impacts mysql db and hosts tables). As it stands, if I want to grant a user privileges that are database specific or host specific, I must create the grant/revoke statements to target the db and hosts tables directly.
1 vote -
message about deleting indexes
when deleting many indexes every time before delete i need to press yes on confirm message, its slow down work with tables. if i have 10-15 fk in table and i need to delete 7 fk, than i will press Yes 7-n times on confirm message. Give please option to delete without confirm.
7 votes -
execute stored procedure from Data tab
If you are in the "Text" tab of a stored procedure, there is a keyboard shortcut available to execute the stored proc (F5). This results in moving you to the Data tab.
If you want to re-run the same store procedure, you must use your mouse to click the Text tab then F5 again. It would be nice if from the Data tab you could F5 or other shortcut key saving the mouse clicks.
1 vote -
Checking variable names in file at Execute Script time
In my company Database Developers write Stored Procedures in files and then Execute Script in MySQL Databse using dbForege and then testing and debugging . If we do not declare vvariable1 and use them in as
IF vVariable1 > 0 THEN
OR
CALL procname1(v_Variable1dbForge does not check variables in above cases. I appreciate if you add this feature in your coming release, this will help to make a good MySQL IDE for Stored Procedures.
3 votes -
Allow parameter values to be saved between sessions
Every time the app is relaunched values for parameters (like :userKey) have to be re-entered.
1 vote -
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
65 votes -
Better error description when concurrency exception occurs
I opened a table and focused some data row. Then I created a new sql and did a few queries, one of them deleted a row in the table I've previously opened. But I didn't notice it. Then I returned to the opened table and edited the focused row (the one that was already deleted actually) and I got very generic error message, something like "An error has occurred during update operation". I spent a minute to understand that this is a concurrency exception because I've deleted a row I wanted to edit.
4 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…
34 votes -
Add Schema Selector to Connection - Like 'Owner' in Find Object
Rather than a ALL or ONE schema display within a connection, add a 'schemas to display' option like what is used for "Find Object->Owner" dropdown. If it's checked, it's displayed. Leave the 'display all' button through!
1 vote -
Ability to Compare All Schemas in a Connection
Rather than 1 schema at a time, allow to compare schema/data on a per connection basis, with an include/exclude schema list. For those of use with multiple schema's to compare this would be great!
4 votes -
Stacking of 'when' statements in 'Order By', 'Group By' statements
The 2..99 'WHEN's should lineup
<code>
.....ORDER BY
..........CASE WHEN intSortField = 0 THEN ContractDashZone
....................WHEN intSortField = 1 THEN ContractNameAndContractCode
END;
</code>3 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 'sqlscripts' table to any schema for unified storage. Browse to SQLScripts, right-click to Edit/Run, just like file system level scripts.
44 votes -
Data copy via right-click
right-click table / view for source, then right-click table / view for destination!
Should be across connections or within same schema!
3 votes -
Add JDBC connection support
Add ability to use JDBC connections (like dbVisualizer) for access to other DB's (I personally need it for as400 / iSeries / System i data). Initial release could just support data viewing, import.
9 votes -
data comparisons, add abilty to view by row stacking
While viewing records in data comparisons, add abilty to view in column side-by-side (as currently available) -OR- by row stacking
5 votes -
Copy or Move via Drag & Drop
Copy or Move via Drag & Drop of any item to another schema & across connections
77 votes -
table change -> view update (with preview)
When making a table change, validate all source objects / views (in case of column name change). Provide list of objects that this update affects and allow double-click to edit or view update (with preview) Beyond Compare style!
0 votes -
compare objects via right-clicks
compare source objects, table def & data via right-clicks (See Beyond Compare@ScooterSoftware.com)
0 votes -
explorer interface
- click on conection name expant tree node & conect 2 DB
- after close connection same action will only expand tre node, but not connect 2 DB - it wrong 4 several DB developers.
MUST:
click on node [+/-] expand|collapce it, but click on connection name is ALWAYS make real connection 2 DB when expanded.2 votes
- Don't see your idea?