- or
473 results found
-
Provide a new option to perform page breaks in output documentation
Provide a new option to perform page breaks in documentation when generating documentaion (e.g. at database table level). This would allow the documentation to be more readable for users. (SQL Documentor)
1 vote
AdminDevart
(_, Devart)
responded
Could you please provide us screenshots of the actual and expected results?
You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
Do not display Object Does Not Exist error when object exists
Scenario
DB user has SELECT privileges on mysql.proc.
DB user has ALL PRIVILEGES on schemaA, and NO PRIVILEGES on schemaB.
DB user is running dbForge for MySQL 8.0.40
A Stored Procedure (spA) in schemaA calls a Stored Function in schema A (fnA).
A Stored Procedure (spB) in schemaB calls the Stored Function in schema A (fnA).Therefore, in the Database Explorer tree view, schemaA is listed, schemaB is not.
Action
The user expands the list of Stored Functions in schema A, expands fn_A, and then expands the "Used By" list.
Result
dbForge pops up an error message stating: Object "schemaB.spB" does not exist.
Neither schemaA.spA nor schemaB.spB are listed under "Used By".Expected Result
No error message
schemaA.spA and schemaB.spB listed under Used By
schemaA.spA is editable
schemaB.spB is read-onlyAnalysis
Because schemaB is not listed in the Database Explorer, dbForge seems to be unable to list its child objects under the Used By section. When this error happens, it also causes the Used By section to not list ANY objects, even those in schemaA.
The existence of schemaB is revealed by the query to mysql.proc, so that should allow the Used By section to display schemaB.spB, even if the user cannot edit spB. This is desirable, because it informs the developer that something potentially needs to be refactored if changes are made to fn_A.
Scenario
DB user has SELECT privileges on mysql.proc.
DB user has ALL PRIVILEGES on schemaA, and NO PRIVILEGES on schemaB.
DB user is running dbForge for MySQL 8.0.40
A Stored Procedure (spA) in schemaA calls a Stored Function in schema A (fnA).
A Stored Procedure (spB) in schemaB calls the Stored Function in schema A (fnA).Therefore, in the Database Explorer tree view, schemaA is listed, schemaB is not.
Action
The user expands the list of Stored Functions in schema A, expands fn_A, and then expands the "Used By" list.
…1 voteAdminDevart
(_, Devart)
responded
Could you please provide us the result of the following query:
SHOW GRANTS FOR ’DB_user_name’@’host_name’You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
Make a feature where it doesn't crash every hour
Software crashes very frequently when it's just idle.
1 voteAdminDevart
(_, Devart)
responded
>Software crashes very frequently when it’s just idle.
Could you provide us with more details on this one? What is the edition and a version of the very Studio? In addition, it would be nice and helpful to have a short video of the issue.
-
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 -
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 -
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 -
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 -
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 -
Be able to switch the 'confirm' off for renaming stuff in the database explorer
Be able to switch the 'confirm' off for renaming stuff in the database explorer - it takes too much time
1 vote -
Close to system tray
Instead minimizes in task bar use system tray during preventing close. This will save space and more logical because all documents are closed.
1 vote -
An option to Always use default "Fonts and Colors" for source code.
I use a very busy color theme in Visual Studio, finding it helps me visuallize the code better.
However, when comparing two files with my "dev" theme its much too visually noisy.
I would like an option to disable the coloring detected by Code Compare when launched from Visual Studio.
Just a simple checkbox to "Always use defautl colors" for source code would suffice.
1 vote -
Password protection Editor
For every user can use it. It would be a bad thing, after what that time editor of the machine itself was blocked.
1 vote -
Improve network performance. I store script on a network share. For some reason dbForge takes forever to load and save to the share.
I store scripts on a network share. For some reason dbForge takes forever to load and save to the share. Other programs do not have this problem.
1 vote -
Add "Optimize for empty tables" option in Data Comprison wizard
Use case: Moving data from production environment into empty test environment.
If source or target table is empty then there is no need to compare rows. In the frontend it looks like every row is processed in a loop, takes half a minute to process ~30000 records, and a lot more time to process a million records.
I suggest to perform a record count on the target table. If target table is empty, just suggest to copy over all rows in the source. If target table is not empty, then check source table. If source table is empty, then suggest to drop all rows in the target.
This could also be an option in the compare dialog ("Optimize for empty tables").
Use case: Moving data from production environment into empty test environment.
If source or target table is empty then there is no need to compare rows. In the frontend it looks like every row is processed in a loop, takes half a minute to process ~30000 records, and a lot more time to process a million records.
I suggest to perform a record count on the target table. If target table is empty, just suggest to copy over all rows in the source. If target table is not empty, then check source table. If source table is empty, then suggest…
1 vote -
Select font size in query builder
When designing a query with a lot of tables, the font size gets too small to read. You should be able to change the font to make it readable.
1 vote -
Allow export on master detail browser of displayed data.
While viewing a set of data in the master-detail browser, it would be nice to be able to export the data that is shown on the screen. The export could be done for each master-detail tab separately or it would be nice to be allowed to export data from all currently displayed tabs; however, this would have to be separate files or Excel sheets for each tab.
If nothing else, allow copy on the data rows so they can be manually copied and pasted into Excel or other application.
1 vote -
Add option to get one ALTER statement for each db change
Currently I have "nested" statements like the following and if one column add fails the rest of the query additional fails!
ALTER TABLE cmsgewaehltemodule
CHANGE COLUMN parentid parentid INT(10) NOT NULL DEFAULT 0 AFTER id,
CHANGE COLUMN seitenid seitenid INT(10) NOT NULL DEFAULT 0 AFTER parenteintragid,
CHANGE COLUMN systemmodus systemmodus ENUM('live','staging') NOT NULL DEFAULT 'live';1 vote -
Add option to keep AS on same line as CREATE or ALTER statements
Is it possible to have the AS stay on the same line as CREATE or ALTER ddl statements?
For example I have
CREATE VIEW vSTuff as SELECT * From tbl which formats to
CREATE VIEW vStuff
as SELECT *
FROM tblI want
CREATE VIEW vStuff as
SELECT *
FROM tbl1 vote -
Ability to import several tabs from single Excel file at once
add a feature to import excel tables with several Regions because when you import the first region (or TAB) the action finishes and you have to begin again open the same file and perform the same action. I'm importing a 300 tables with 262000 records each one and is very difficult to open each file 5 times!!
1 vote -
auto-refresh option for queries
Many times while I am coding on left monitor (perhaps a setup screen, or something that adds to a queue) I watch plsql developer in my right monitor refreshing a query every 2 seconds and if the new record appears then I know that it worked correctly otherwise I need to dig deeper into the code. With dbFordge I would constantly have to click the refresh button and if there were any parameters I'd have to see the parameter entry screen on each refresh. I use this feature regularly when tracking down bugs. It is a real convenience.
1 vote
- Don't see your idea?