471 results found
-
3 votes
-
read invalid view
Cannot Edit Views if Column No Longer Exists. This was already asked before, but it still doesn't work. We still get "... references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them". This pops up all the time on complex projects and it's a pain to recover from with SELECT VIEWDEFINITION FROM INFORMATIONSCHEMA.VIEWS when you guys could just try this automatically whenever the error occurs.
3 votes -
Find and replace 'Look in' value setting
It would be nice to be able to set the find and replace 'look in' value to a default. I personally don't like having it search all documents by default since all the other editors I use don't do this.
3 votes -
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 -
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 -
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 -
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 -
Database level replace
There's a database find objects method, but no replace option.
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 -
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 -
Enable tab scrolling with scrollwheel and tab naming scheme
Please make it possible to scroll tabs with the scroll wheel. Scrolling them with the tiny arrows on the right is very tedious and switching and scrolling tabs is obviously needed all the time.
This might be a small thing but it would make working with dbForge much faster and smoother for me.Also it would be nice to be able to config the scheme the tabs are named by and name max length. Since the current naming scheme is databasename.tablename names can get long quickly and the tab bar fills up with just 5-6 tables opened.
3 votes -
Save Filter selections and add an option below Filter... in Context menu, showing list of saved Filter groups
I work in certain areas of my DB at any time, I may be working on a feature of an application, and need the tables, procedures etc filtered on certain criteria.
If I could save this set of filters with a name, then be able to reselect this later would be amazing, it would save a lot of repetitive filtering, scrolling etc. This is such an easy thing to implement and would provide a mush used feature.3 votes -
Fix JSON view colors for dark themes
Using the JSON view in dark themes is annoying as there is no way to configure foreground colors for numeric data types so they are displayed as black on black
3 votes -
Show Client connections in GUI view like workbench.
Show Client connections in GUI view like workbench. with ability to kill, hide sleeping connections, filter by users, etc
3 votes -
Prompt when editing multiple rows
When editing a data result in the grid view and the edit is affecting multiple rows, no warning / question is given. This is a very helpful feature in SQLyog when editing relative complex data results with multiple joins, and stops me from switching.
3 votes -
Data Generator: Generate Data for multiple databases at the same time
We have servers with many databases (>100). Right now I have to create a project for each of them, and run the data generation individually.
It would be great if there was a way to create a project in dbForge Data Generator for MySQL that covers multiple databases instead of one.
3 votes -
[Data Generator] Note per Data Generation file
When I create a Data Generation file, I of course adapt it in some ways. Sometimes this is just disabling one field or similar. It would be nice if one could write down some notes on the top level of the file, so what you see when you click the database name. That would enable me to e.g. write "disabled foo.bar because of circular dependency".
3 votes -
Show only Key Columns in the Database Diagram
When we drag and drop to create an ERD, all the Columns of the Table are showing and the entire Table is shown. If there 50 Column then we have to manually size the table height on the screen.
Is there an option to always show only the Key Columns when the table is dragged and dropped on to the Database Design Page?
Some of the unwanted columns on the screen are highlighted for reference.
Only Key Columns like the Primary, Unique, Foreign Keys should be shown on this screen.3 votes -
Data generation for existing rows
I regularly work with privacy sensitive data. When copying a production database to a an acceptance or development environment, it would be really useful to be able to use the Data Generation to overwrite the existing names with generated names.
3 votes -
Add support for "Stored Aggregate Functions"
The ability to create stored aggregate functions was added in MariaDB 10.3.3. but dbForge do not read they.
https://mariadb.com/kb/en/stored-aggregate-functions/
I see the functions in the tree, but when I try to open they I get an error like "Unable to parse source text", and when I try to backup a database that contains Stored Aggregate Function it fails.
3 votes
- Don't see your idea?