472 results found
-
Implement the mouse 'snap-to' for dialogue default buttons
Please implement the mouse 'snap-to' for dialogue default buttons - saves a lot of time if enabled
1 vote -
0 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
----view220 votes -
Warn about the use of @ in Stored proc parameter names
I used @ in a SP parameter name and spent some time trying to figure out why my procedure didn't work.
Turned out you can't? use the @ character in the name.
In the SP builder it might be handy to restrict invalid characters in param names.
4 votes -
I need posibility to run SQL not SQL files only.
SQL code saved in file with "config" extension cannot be executed. Can you redefine this ? I need posibility to run SQL not SQL files only.
2 votesAdminDevart (_, Devart) respondedCould you please let us know why you need this?
-
Create table: Configure Setup with own defaults (fields, FKs...)
when creating a new table, many developers have default fields (triggers, indexes) they use: we need a setup based on a project where a new table is created based on a setup/config that was made before.
for example: every new table sould have 2 fields like:- db_created (datetime)
- db_changed (datetime)
and also 2 triggers
- trdbchanged ---> SET db_changed = NOW() ....
the first field dbforge creates, is based on the table name, would
be great, if we could change that regex, for example:if the table name is: "user" --> i always want the first field named based…
3 votes -
Backup all databases
A backup for all databases (or choosen) will be useful. These function should be startable from the windows task planer for a good backup strategy.
36 votes -
Folder/group feature for Database Explorer?
Would it be possible to add a group/folder feature to the connection explorer, so connections can be organized?
209 votesAdminDevart (_, Devart) respondedPlease note that you can assign one of the available document categories with colors to a connection as follows:
1. Right-click a connection in Database Explorer and select ‘Modify Connection…’ from the popup menu. The ‘Database Connection Properties’ dialog opens.
2. Switch to the ‘Connection’ tab.
3. In the ‘Document Category’ drop-down menu, select one of the available options or add a new one by clicking the three-dotted button. -
Colour Printing
It would be really handy to be able to print scripts in colour as it is displayed in the script editor.
3 votes -
Comma separated values when copying cell data
When you copy cell data, for example 5 ids, I would like to be able to copy them as comma separated data in order to use in IN statements.
For example, if you have 3 rows of results like the following:
id name
1 George
2 John
3 GregoryI wish to copy ids as comma separated values in order to use them in a Select statement like:
SELECT * FROM temp t where t.id in (1, 2,3)5 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.
19 votes -
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
- Don't see your idea?