134 results found
-
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.
-
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’. -
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. -
Data editing Mode per Categories and/or Server
Set the Data editing Mode (RO o. RW o. Ask) per Categories.
Sample:
Live = RO
Defelopment = RW3 votesPlease note that there is a feature allowing to change a connection’s color:
1. Right-click a connection in Database Explorer and select ‘Modify Connection…’ from the popup menu. The ‘Database Connection Properties’ dialog opens.
2. In the ‘Document Category’ drop-down menu, select the appropriate item or add a new one by clicking the three dots button against the drop-down menu. -
Add parameter in command line to backup all objects in separate files
Add a parameter in the command line interface in order to generate all the objects in separate files when performing a DB backup.
3 votes -
Correctly display encoded carriage return and newline in procedure editor
When editing a stored procedure, function, or trigger, statements that contain an escaped carriage return (\r) or newline (\n) are not displayed correctly in the editor. That is, they are incorrectly displayed as an actual carriage return or newline. To replicate, create a stored procedure with the line: IF LOCATE('\r', field) > 0 THEN ...
Save the the procedure and then open it again in the editor.
3 votes -
Save current session before close the application
Save opened windows before close the application
3 votesThis can be achieved with the Database Project feature. You can add the necessary documents in the project, save it and select ‘Load Last Opened Project’ under ‘Environment Settings’ in the ‘Environment → General’ branch of the ‘Options’ window. So, next time you open dbForge, your documents will be opened automatically.
Also, by default, the documents auto save feature is turned. Despite the fact that the documents may have not been saved yet, next time you start dbForge, all tabs will be restored. You can specify the file types to restore in the ‘Restorable file types’ section of the ‘Environment → Documents → Restore’ branch in the ‘Options’ widow. The restorable files with corresponding paths are specified in the *.xml file that is located in the following folder:
SystemDrive\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for MySQL\ -
IF END ELSE matching. Put cursor on IF and highlight the matching END
Put cursor on IF highlight the matching END
3 votes -
Database backup into separate files
It would be really useful to have functionality to backup database schema/data into separate files. This especially handy when it comes to source code control. I know some other desktop MySQL managers do have it for ages. It would be convenient to have such a feature in dbForge Studio so we can forget about using other MySQL desktop apps.
3 votes -
3 votes
Such feature is present in dbForge https://www.devart.com/dbforge/mysql/studio/docs/index.html?how_to_manage_database_connections.htm
-
Support large (4k) resolution screen
Today 4K resolution are widely adopted and mixed with 1080p
In windows, we can use font scaling according to the screen
that feature isn't used in dbforge studio, when we move the software from one screen to another, the layout should be adapted according to the settingsmoreover, the size of the font isn't used everywhere (the database explorer, the properties, or even the modify table feature doesn't use it) and the icons size should be increased if seen on a 4K display
3 votes -
Support Mariadb 10.3 or at least allow connecting to unknown future versions with just a warning.
I would much rather take the risk that something won't work quite right than be relegated to not even being able to try. Most things should work no matter what.
3 votes -
Provide a feature in new data geretion
Automatic generation of fake data in tables in new data gnration.
3 votesThis feature is present in dbForge Studio for MySQL and can be accessed by selecting ‘Tools → New Data Generation…’ from the main menu.
-
turn off data types in column headings
I dont need data types in column headings, it disturbs me.
3 votesAn option added.
-
Ability to export SQL to clipboard and new editor
I'd like that when I right click a table, choose Export Data then To SQL, I'd be given the opportunity to simply copy generated SQL to clipboard, instead of having to save it into a file (or, also, to open generated SQL in a new editor, without saving to a file).
It would be nice to have the same in data view: I'd select a few rows, choose Export Data, choose a great new option "To SQL", and then could export to a file, clipboard or editor.
2 votesHello,
> Ability to export SQL to clipboard and new 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 -
Automatic Reconnection
I get a message "connection lost to mysql" always, so I need to click twice. The reconnection should be automatic. If there is a way to do this now, please let me know.
2 votessee coments
-
Ability to specify different formatting rules for conditions in brackets
For example...
WHERE
----X = 1
----AND Y = 2
----AND (Z = 3 OR Z = 4)Currently the OR will drop to a new line...
WHERE
----X = 1
----AND Y = 2
----AND (Z = 3
----OR Z = 4)which is hard to read
2 votesThis feature is available in dbForge Studio for MySQL, v6.1.166.
-
update code completion with table changes
When you change or create a table you need to manually refresh for code completion to pick-up the new changes.
Would be nice for use lazy people if it refreshed with changes :)
2 votesThis feature is available in dbForge Studio for MySQL, v6.1.166.
-
Automated Migration Tools
Would love to see more smart and automated tools to migrate databases. Currently you must do a back up and restore. How about extending some of the tools to allow you to simple select source, destination, change some options, and move an entire database.
2 votesThere are the Copy Database, Data Compare, Schema Compare and Script Folder features supported in the command line interface.
Also, Exit Codes were added in the command line interface.
-
Ability to save and reuse Data Sync table mappings etc
Hi, I use your schema and data synchronisation features but with the data one I rarely (never) want to compare every table and some of the ones I don't need are quite large so I use the mapping features to de-select those I'm not interested in. Trouble is I have to do this every time as there's no way to save the connection and mapping details into a file for repeat use (if you've used Red Gate's Data Compare for SQL Server then you'll know what I mean).
Any chance you can add this functionality in, please?
2 votesPlease note that dbForge performs mapping identically to Red Gate.
Once automapping is performed and the user specified objects are excluded from the mapping, you can perform comparison and then save it. When you open the save comparison, the previously saved user specified mapping gets restored. Such a behavior is also identical to the Red Gate’s one.
If you perform automapping, exclude specific objects from the mapping, perform comparison, save, then close the document, make changes in Source and Target by removing the pair of the mapped tables and then adding the pair of new tables, then open the saved project, the saved mapping gets restored where possible. That is, the removed pair of the tables is excluded from the mapping. For the rest, the mapping is restored and the new pair of tables is mapped automatically. Such a behavior is also identical to the Red Gate’s one.
Additionally, starting…
- Don't see your idea?