131 results found
-
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 -
IF END ELSE matching. Put cursor on IF and highlight the matching END
Put cursor on IF highlight the matching END
3 votes -
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 -
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. -
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 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 -
3 votes
Such feature is present in dbForge https://www.devart.com/dbforge/mysql/studio/docs/index.html?how_to_manage_database_connections.htm
-
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/
-
turn off data types in column headings
I dont need data types in column headings, it disturbs me.
3 votesAn option added.
-
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 -
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 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 -
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 -
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…
-
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.
-
Add ability to compare stored procedures with formatting applied
Having the ability to compare formatted versions of stored procedures would allow to ignore stored procedures that are identical even if they are not formatted exactly the same.
The performance cost would be marginal compared to the usefulness of sorting out equivalent stored procedures.
When comparing code, what it does is what is important.
1 vote
- Don't see your idea?