134 results found
-
NULL in OUT Parameter in Stored Procedure
If OUT Parameter is INT or BIGINT
and if result is NULL for OUT Parameter
dbForge for MySQL returns 0 instead of NULL
Please add this feature in your coming release.3 votes -
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/
-
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’. -
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 -
command line interface to run reports
Command line interface to run reports from windows or external applications.
3 votesThis feature is implemented in the new version 6.0 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/studio/
-
IF END ELSE matching. Put cursor on IF and highlight the matching END
Put cursor on IF highlight the matching END
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\ -
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
-
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/
-
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 -
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.
-
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 -
3 votes
Such feature is present in dbForge https://www.devart.com/dbforge/mysql/studio/docs/index.html?how_to_manage_database_connections.htm
-
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.
-
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.
-
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 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…
-
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.
-
Retrieve Data select top x rows
Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).
I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).
2 votes
- Don't see your idea?