132 results found
-
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’.
-
MySQL data to JSON
Export table data or custom query data in Json format with the possibility of grouping by selected keys.
4 votes -
Integration with Version Control System
Need integration with version control systems (Bazaar, SVN, GIT). Store and retrieve objects (SP, Func, etc.) and DB schema at all. Diff, history, etc.
Just like in Eclipse, but (file) == (SP, Func and other DB schema objects)515 votesDear Users,
Thanks for your patience.
We would like to kindly inform you that we have released a new version of the tool. This version includes a lot of fixes.
Please be informed that the long-awaited Source Control feature is now available!
The full list of fixes and features you can find in Revision History:
https://www.devart.com/dbforge/mysql/studio/revision_history.htmlYou can upgrade to the new version within the app, just look on the bar on top for "Help→Check for updates".
Or you can use the link below:
https://www.devart.com/dbforge/mysql/studio/download.html
In case you have any additional questions or need any kind of assistance, kindly let me know.
Thanks in advance,
Devart Team
www.devart.com -
Export tables in one file
Export tables in one file.
When I need to export multiple tables I have to run PhpMySql.1 voteThis can be achieved with the Database Backup feature with the help of which you can export selected tables into one file. Please also see the following https://www.devart.com/dbforge/mysql/studio/docs/index.html?how_to_backup_a_database.htm
-
1 vote
-
Set INDEX type for PRI KEY in Primary Key Dialogue Box.
There doesn't appear to be anyway to define the Index type used on a Primary Key column when creating a table or altering a table without hand writing the DDL SQL. Please consider adding a drop down box in the Primary Key Properties dialogue box so this can be set when choosing other Primary key properties. Thanks.
1 voteThis can be achieved as follows:
1. Expand a table in Database Explorer.
2. Right-click the ‘Indexes’ node.
3. Select ‘New Index…’ from the popup menu. -
Export data and sheme in one file!!!
Export data and sheme in one file!!!
3 votesThis can be achieved as follows:
1. Right-click a database in Database Explorer and select ‘Backup and Restore → Backup Database…’ from the popup menu. Database Backup Wizard opens.
2. Move on to the ‘Backup content’ page of the wizard and select the ‘Structure’ and ‘Data’ options.
3. Complete the wizard. -
edit table comment
Editing of all table options in MySQL especially table comment.
1 voteThis can be done on the Main tab of Table Editor.
Please refer to the ‘Main, Table Editor’ topic in the product’s Help documentation for details.
-
1 vote
There are command line switches for generating data reports, backup, restore operations.
For help, please type the following in the command line prompt:
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql
-
Compatibility with MySQL 5.6
dbForge v6.2.280 won't work with timestamp(3) - can't see milliseconds
3 votesPlease perform the following:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Data Editor → Formatting’ branch.
3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
5. Click ‘OK’. -
template based stored procedure generator
Provide a template based stored procedure generator. This would help with large projects where CRUD stored procedures need to be generated for multiple tables
1 vote -
Make the DML editable when creating or modifying a table
Make the DML editable when creating or modifying a table. This is available in the MSSQL version of dbForge and is VERY useful when wanting to cut/paste column definitions from other tables
1 vote -
Show SQL of filter
When creating a complicated filter I would like to export the generated select statement to clipboard so I can use it for update statements
1 voteThis can be achieved as follows:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Output’ branch.
3. Select the ‘Write queries sent by the program to the SQL Log’ option.
4. Restart dbForge Studio for MySQL.Now you can view the corresponding queries on the ‘SQL Log’ tab of the ‘Output’ tool window that can be opened by selecting ‘View → Output’ from the main menu.
-
Multiple Screens and Displays
Add multiple monitor support please!
6 votes -
Add «Show as date/time» option to column settings menu in data tab
It's a common way to store Unix time data within INT fields.
So it's not very convinient to operate with it on data tab.Suggestion to add «Show as date/time» option to column settings menu in data tab.
Some like shown here: https://yadi.sk/i/NVBQYEEuc4FiP
3 votesThe grid is intended for viewing data, but not for casting. We can recommend you to use a selection from this table turning the column UNIX date time into the FROM_UNIXTIME function.
-
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 -
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 -
Record Count needed
Just like in Toad. Right click on table/view -> Record count. Just for a quick check
1 voteThis can be achieved by either of the following ways:
Turn off ‘Paginal mode’ from the toolbar of Data Editor or in the ‘Options’ dialog:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Data Editor → General’ branch.
3. Unselect the ‘Use paginal mode by default’ option.
4. Navigate to the last record with Ctrl+End.orExecute the following query:
select count(*) from ‘table_name’ -
Change the F5 shortcut key on Execute.
F5 key is sometimes used to Refresh the Database Explorer. This can be disastrous if accidentally pressed on the SQL Tab when your intention is to just Refresh the connection.
1 voteYou can assign another key for the ‘SQL → Execute’ command in the ‘Environment → Keyboard’ branch of the ‘Options’ window that can be opened by selecting ‘Tools → Options…’ from the main menu.
-
Which server and database am I about to run this query on?
When working on an SQL query with multiple servers available, it'd be nice to be able to display which server (and database) the sql will be running on... (or make it more evident if it's already there and I'm missing it)
1 vote
- Don't see your idea?