238 results found
-
13 votes
-
add data type in table\columns
add datatype in table\columns view
like ms sqlexample
table1
+-columns
|-column1 (int)
|-column2 (varchar(20))13 votes -
CURRENT_TIMESTAMP checkbox for a new column TIMESTAMP as default value
It will very usefull to make this option in new version.
13 votes -
Show number of object in the database explorer (tree) panel
There is the "Explorer" panel on the left (by default) where available database are shown. If you expand a database node you see Tables, Procedures, Functions and other nodes.
It would be good if number of objects were shown in the parentheses near the node name, for example:
MyDatabase
+Tables (50)
+Procedures (200)
+Functions (100)Personally, I need to see if an object (or objects) has been added to the database. For example I execute 3 create procedure statements, and then I want to check that number of procedures has been increased by 3.
12 votes -
Spatial index support
I noticed that HeidiSql support create spatial indexs, but until now dbforge doesnt support that.
12 votes -
Support Code Completion in trigger / event
When you edit or add trigger / procedure / event / etc edittor you dont have functinality such as in regular sql script(field list). Please add.
11 votes -
Show ALTER statement when editing object in Object Editor
When editing table structure using the GUI tool, there seems to be no way to see the generated ALTER TABLE statement.
(I still use MySQL Workbench to start the "alter table" wizard, copy the generated sql to migration scripts and cancel the wizard.)
10 votesHello,
> Show ALTER statement when editing object in Object Editor
We would like to let you know that we have released dbForge Studio Beta for MySQL, v6.0 where the requested functionality is implemented: http://www.devart.com/dbforge/mysql/studio/download.html
Best regards,
Devart Team
http://www.devart.com -
Automatically determine build order based on dependencies
It would be nice to have an option to automatically sort the objects in the build order based on known dependencies (e.g. foreign keys).
When adding a number of new tables to a database that already has a large number of tables, managing this manually becomes especially tedious.
10 votes -
Master-detail data browser
Allows to view data from 2 or more tables connected with one-to-many relationship (physical or logical).
We plan to implement separate document with two views: Diagram and Data.
Diagram view allows to build master-detail relationships visually (akin to Query Builder).
Data view shows multiple result data sets.10 votesWill be included in the next release
-
Export Connection List (add to export of evn options)
not everybody knows howto work with the registry, so please make it possible to export the connection list and all its options to a file - very important for making backups... it would be the best to save the connection liste parallel into a file, each time something changes, that would be the best for automated backup script...
10 votesHello,
> Export Connection List (add to export of evn options)
We would like to let you know that we have released dbForge Studio Beta for MySQL, v6.0 where the requested functionality is implemented: http://www.devart.com/dbforge/mysql/studio/download.html
Best regards,
Devart Team
http://www.devart.com -
Support compund statements in MariaDB
In MariaDB (as of 10.1.1), compound statements are allowed outside of stored procedures - see https://mariadb.com/kb/en/library/using-compound-statements-outside-of-stored-programs/.
9 votes -
Attention Color highlight, for database. for Be patient, with Public and Develop databases..
Allow user to choose color for DB, which will shown in editor as background or something. And don't be worry about working with Test DB and Production DB.
9 votesThe feature is available in dbForge Studio for MySQL, v6.2.
-
Json Data Type support for mysql 5.7
Json Data Type support for mysql 5.7
8 votes -
Option to Ignore COMMENTS and CHARACTER SET / COLLATE in SCHEMA COMPARE
Add an option to ignore COMMENTS and CHARACTER SET / COLLATE in the Schema Compare Tool.
8 votes -
mariadb
I have two mysql server. MariaDB 10.2 and Mysql 5.5.23
When i make structure comparation i have such differences with default null fields:
In MariaDB 10.2:
guiname VARCHAR(200) DEFAULT 'NULL',
description VARCHAR(2000) DEFAULT 'NULL',
In Mysql:
guiname VARCHAR(200) DEFAULT NULL,
description VARCHAR(2000) DEFAULT NULL,And after sync these differences are remained
7 votes -
Function "greatest" causes error in project build
When building a project, any SQL query that contains the "greatest" function is flagged with the error:
The name 'greatest' does not exist in the current context
(Using dbForge Studio for MySQL version 5.0.97.)
7 votesThis issue is fixed in the new version 6.0 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/studio/download.html
-
7 votes
-
7 votes
You need to first remove all the key combinations starting with (Ctrl+W,…) from all other commands in the ‘Environment → Keyboard’ section of the ‘Options’ window that can be opened by selecting ‘Tools → Options…’ from the main menu, and then define the (Ctrl+W) combination for this command which is ‘File.Close’.
-
Multiple Screens and Displays
Add multiple monitor support please!
6 votes -
SQL history for more than one day
A helpful feature is a SQL history backto more weeks or moth
6 votes
- Don't see your idea?