240 results found
-
Add 'Comma' to the Column Separator options when exporting for CSV and remember the selection from the last export
It can be very frustrating when doing lots of exports to keep having to update the custom field which defaults to ';'.
1 vote -
Generate insert data from the grid
an option to automatically generate the insert of the filtered data and displayed in the data grid
1 voteThis can be performed by right-clicking in the data grid and selecting ‘Script Data as INSERTs to → …’
-
How to make request that returns data from period "yesterday" or "current month" (needed for autoreport)?
How to make request that returns data from period "yesterday" or "current month" (needed for autoreport)? Thnks!
1 vote -
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.
-
Export Data, Header and Footer not added
When exporting data to Excel you can specify a header and a footer to be add. But in the result they are not added
1 voteThese parameters will be visible when you send the Excel document to print. You can check this on the preview stage.
-
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’ -
export diagram as a vector graphic
It would be nice if diagrams could be exported as vector graphics (SVG, EPS, or WMF, or ...).
Such as the diagrams can be imported in a MS-Word document and can be scaled without loose of resolution.As alternative, it would be nice if, while exporting as image, we can choose a resolution for the image.
By the way I was really searching for a long time for a tool like your "dbForge Studio for MySQL" and I think it is the best around.
It does include all I Need and much more.Thanks, Michael ;)
1 voteThis can be performed as follows:
1. Right-click the diagram and select ‘Export to Image…’ from the popup menu. The ‘Save As’ dialog opens.
2. In the ‘Save as type’ field select ‘Enhanced Metafile Format (*.emf)’.
3. Click ‘Save’. -
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 -
Database Explorer doesn't update - 6.2.280
Under newest version (6.2.280) database explorer doesn't update, even after manually refreshing.
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.
-
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 -
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 -
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
-
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
-
Add shortcut to copy and remove row
Product: dbForge Studio for MySQL
would you please think about add such keymap support for the sql edit:
Edit.CopyRow, we just foucs the cursor on some row, and press Ctrl+c, then copy this row
Edit.DeleteRow,we just foucs the cursor on some row, and press Ctrl+L, then remove this row directly.
these function are very usefully on visual studio edit, so plz consider these.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. -
how sync table without key column?
i am able to do that with : EMS Data Comparer for MySQL in the past
but now i use your tools and i have a problem to sync table without Key1 votePlease perform the following:
1. In the New Data Comparison wizard, select the databases to compare.
2. On the ‘Mapping’ page of the wizard, select the row with the mapped tables and click the three-dotted button located at the end of the row. The ‘Column Mapping’ dialog opens.
3. Select the columns that will be used as a comparison key and select the ‘Key’ checkbox against them.
4. Click the ‘OK’ button.
5. Click the ‘Compare’ button in the wizard.Comparison should complete successfully.
-
Problems with Intellisense drop down box not updating
v 6.3.341
Open a SQL editor window, write a SELECT query - list the FROM tables, start to build SELECT clause.
Don't save Query - leave open in editor. Open a Table being referenced in query, and add a new field. Switch back to SQL editor. The new field doesn't appear in the Intellisense drop down (or whatever you call the drop down box - MS call it Intellisence) as you type.
I was doing this in the SELECT clause. I had also given the tables aliases in the FROM clause, if that make any difference.Many thanks.
1 vote -
1 vote
- Don't see your idea?