473 results found
-
Data comparison or structure comparison properties dest dbname auto selected the same name as source
In the data comparison or structure comparison properties, when you select the destination connection so that the database name is automatically selected the same as in the source.
Ability to compare all the schemes (with select ability) and both the schemes and data at once. Thank you.1 vote -
Support reserved keywords and events in MySQL 8.0
dbForge Studio 2019 for MySQL 8.1.22
When sync data between MySQL 5.7.25 and MySQL 8.0.15 and table have field name in reserver keywords, got error like "check syntax ", rank,", fields and tables names must be enclosed in apostrophes.
MySQL 8.0 event like
CREATE
DEFINER = 'username'@'localhost'
EVENT odatabase.eventname
ON SCHEDULE EVERY '1' WEEK
...
in GUI shows as "every '7' (SEVEN) weeks", but DDL is right.1 vote -
export data from Database to another one by using drag and drop on SQL Builder
export data from Database to another one by using drag and drop on SQL Builder
3 votes -
Develop Oracle syntax support
I suggest you to develop Oracle syntax support in functions/procedures/sql editors for MariaDB with SQL_MODE=ORACLE switch has on.
3 votes -
Database level replace
There's a database find objects method, but no replace option.
3 votes -
Ability to define timezone for datedime fields
Currently dbforge shows datetime fields in its deafult formats. My system timezone is MSK (Moscow) and mysql global.timezone and session.timezone are set to SYSTEM. dbfogre shows it this way: 2018-11-29 08:13:45Z. I need to get something like this: 2018-11-29 11:13:45MSK
3 votes -
4 votes
-
hide comments
It would be nice when debugging large queries that have been pasted into the editor and everything but relevant parts are commented out to be able to hide those commented lines (a bit like code folding in other editors)
1 vote -
Get format from server
For datetime and decimal types dbForge Studio has its own definitions. You should add a setting that will get the format from server and preferably it should synchronize changes for example if I execute
SET lc_time_names = 'tr_TR';
it should change UI format accordingly.But as a former developer and DBA admin (both mssql) I expected to see result of my query formatted in server and session parameters. For example if I set language to US English in Sql Server for my session all the datetimes in my results shown in US format both in Management Studio and my .Net…
4 votes -
Ability to 'column select' like notepad++ and SSMS
Adding column select/typing like in notepad++ and SSMS.
ALT + left mouse button, and drag
1 vote -
EXPLAIN Partitions isn't working (but it used to in older versions)
Version: 8.0.80 (Professional)
Tried with MySQL 5.6 and 5.7Explain Partitions returns an error, but it works fine on the MySQL CLI.
In dbForge I ran:
EXPLAIN partitions SELECT * FROM log.log;And the error I got was:
Table 'log.partitions' doesn't exist3 votesAdminDevart (_, Devart) respondedHello,
This issue is going to be fixed in the next product build. Currently, as a workaround, you can run statement using F5 button.
-
Solution based database explorer
When working within a solution/project it would be nice to have only the databases listed in the database explorer that are actually needed by the solution.
3 votes -
A right-click WHERE option on tables from the Query Builder
By right clicking on a column of a table, the WHERE option would be available and allow the selection and completion of the WHERE statement on the selected column. Same could be done with Order By, Group By and Having.
Many thanks !
3 votes -
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.
-
Master password
Application now allows user to save connection information. It also allows saving password for saved connection which is very bad idea without encrypting the saved password. This means the database password is available for anyone having physical or virtual access to the hard-drive. Usual way to solve this problem is using master password (like password managers etc. do). Master password is easy to implement but very useful feature so you don't need to copy-paste the database passwords from separate password manager. This might not be suitable for all but I suppose nice feature for many.
3 votes -
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.
…1 voteAdminDevart (_, Devart) respondedCould 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 .
-
Data Editor - Option to show UPDATE/INSERT/DELETE statements before commit
MySQL Workbench allows users to review the update/delete/insert SQL before committing a change in the data editor. This can be useful if you would like to run the same edits on multiple connections or you would like to perform similar edits.
1 vote -
Group SQL Tabs by Connection
MySQL Workbench allows shows a tab per connection under which it displays the SQL tabs. This makes it more difficult to accidentally run a query on the wrong connection.
8 votes -
Fix Stored Procedure Editor to accept ALTER TABLE xxx RENAME TO yyy
As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.
Here is a simple procedure that will trigger the error:
DELIMITER $$
DROP PROCEDURE IF EXISTS sp_test$$
CREATE DEFINER=
root
@localhost
PROCEDUREsp_test
()
MODIFIES SQL DATA
BEGINALTER TABLE foo RENAME TO bar;
END
$$DELIMITER ;
Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error…
0 votesAdminDevart (_, Devart) respondedCould you please provide us the following information:
1. Server version.
2. Result of the following query:
SHOW CREATE PROCEDURE sp_test;You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
Ability to track temporary tables in debugging mode
I would like to be able to track the values in temporary tables via the watch window or have an ability to query them directly within that session. This is for complex reporting procedures that use temporary tables extensively.
13 votes
- Don't see your idea?