131 results found
-
Mutiple result sets displayed into tabbed data views
Be able to see results of recent queries in data view
4 votesHello,
> Mutiple result sets displayed into tabbed data views
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 -
Lookup editor for data columns with foreign key
For columns included in foreign key constraint Data Editor will allow to view and pick master records from popup editor.
4 votesWill be included in the next release
-
Edit result set of a query with JOIN
Data Editor with allow to edit result set of a SELECT statement containing JOIN clause.
Data Editor toolbar will contain a combo-box that allows to chose table to edit. This table columns are highlighted and all other columns are grayed.4 votesWill be included in the next release
-
Server-side filtering in Data Editor
Allows to get correct filtering results when only a portion of data is fetched from server (e.g. when paginal mode is on)
4 votesWill be included in the next release
-
Add the ability to connect through a proxy server
Add the ability to connect through a proxy server
4 votes -
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. -
find in LOB editor
add possibility to ctrl+F to find text in LOB editor
3 votesThis feature is implemented in the new version 6.0 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/studio/
-
Support synchronization of security data
It would be nice if the schema comparison included security. Security manager is great but if you are maintaining multiple databases, having to manually keep permissions in sync is a pain.
3 votes -
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’. -
Ability to export database diagram as an image
I would like to be able to generate either a single image (jpeg, png, gif) containing the whole schema, or page images. This would be really useful when publishing schema on a website for review.
The perfect solution would be where dbForge Studio for MySQL could arrange for a mime type for their dbd file, and develop browser plugins to view the dbd (like the adobe pdf reader can read pdf's), which would allow pan and zoom to make reviewing larger schema easier.
3 votesThis feature is implemented in the new version 6.0 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/studio/
-
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.
-
Navigation through Tabs (switching) by Ctrl-PgUp, Ctrl-PgDown
Navigation through Tabs (switching) by Ctrl-PgUp, Ctrl-PgDown as moder IDE do.
3 votesThe feature is available in dbForge Studio for MySQL, v6.2.
-
Instead of "allow NULL" call it "NOT NULL" in the table design general view
Instead of "allow NULL" call it "NOT NULL" in the table design general view (in line with SQL and most other tools).
3 votes -
Improve "new relation" feature, add foreign columns and indexes automatically
Just like in MySql Workbench, the "new relation" tool in the diagram view should:
- create foreign keys automatically (manual creation is error prune and just a lot more work)
- it should create the respective indexes automatically3 votesThis feature is supported in the latest version 6.0 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/studio/
-
Add '<-- Update' (source/left) during schema compare.
Add '<-- Update' (source/left) during schema compare.
Currently options are:
'--> Update' (target/right)
' X Drop' (target/right)
' - None'If 'Source/Left' options AND 'Target/right' options are selected by the user, generate 2 separate scripts - one for each Schema
3 votesThis can be achieved as follows https://s8.postimg.cc/xvt8wrws5/wrap_options.png
-
Projects folder on SVN/Git/Shared folder
We are some DBAs on the company and we to share the projects folder, is there any way to export/import them? or better, to use a shared resource to use it? Normally we use SVN, so keep the project folder on a SVN working copy should be the best option.
3 votes -
Interbase / Firebird Ex- / Import (CSV, XML, SQL)
Sometimes it´s necessary to move data between databases / tables. For the common use the backup facilities are good, but when it comes to selected Data (last change > ...) it fails.
Wouldn´t it be nice to export data from a query or a view? And of course to be able to import it into some other database or table?
Some kind of rudimentary replication.
Might be handy for updating price / article / ... Lists and sales / jobs done ... between outlets of an enterprise?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 -
Quick jump to corresponding BEGIN <-> END
In bigger procedures with a lot of nasted BEGIN-ENDs it would be very useful to have a shortcut key or right mouse button option to jump to BEGIN/END corresponding to the one on which you currently have cursor.
3 votes -
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.
- Don't see your idea?