220 results found
-
MySQL data to JSON
Export table data or custom query data in Json format with the possibility of grouping by selected keys.
4 votes -
Application freeze on big database
There is Magento database (~250 tables). After updation to 5.0.76 when I tryed open any table in thid db for editing application freeze for 0.5 minutes. Before (5.0.67) it will ok.
4 votesThis issue is supposed to be fixed in the new version 6.0 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/studio/
-
Using "create script as + create" generates an invalid script in dbForge Studio for MySQL
Using "create script as + create" generates an invalid script in dbForge Studio for MySQL
This happens when the default value on a field is currenttimestamp(6) ON UPDATE currenttimestamp(6)
Example of what gets generated.
CREATE TABLE test.junkola (
Id int(11) NOT NULL AUTOINCREMENT,
RowVersion datetime(6) NOT NULL DEFAULT 'CURRENTTIMESTAMP(6)' ON UPDATE CURRENT_TIMESTAMP (6),
PRIMARY KEY (Id)
)The QUOTES around 'current_timestamp(6)' do not compile in your tool.
3 votes -
Cannot see correctly the view's queries and update them on version: 6.1.142.
Views does not seem to work well in the new release..
3 votesThis issue will be fixed in the next product build.
-
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/
-
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. -
Not open some of the procedures for editing.
Not open some of the procedures, don't know what it is, but with a short name opening all the time, and long not open > ~ 40 characters (can cause). The error message "Cannot parse the source code"
3 votesWe would like to let you know that we have released a new build 6.3.339 of dbForge Studio for MySQL where the issue you reported is fixed http://www.devart.com/dbforge/mysql/studio/download.html
Thank you for your help in improving dbForge Studio for MySQL.
-
Make “Execute Current Statement” work when the caret is after the trailing semicolon
In the query editor please make “Execute Current Statement” work when the caret is after the trailing semicolon! It is very awkward to have to type a semicolon, then have to press left, only to execute the statement.
If there is no other statement on the line, there is absolutely no ambiguity as to what statement should be executed.
Both MySQL workbench and Oracle SQL developer can do this, and there never was any confusion.
3 votesHello,
> Make “Execute Current Statement” work when the caret is after the trailing semicolon
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 generation of database diagram schema and FK relations
Automatic generation of database diagram schema and FK relations
3 votesPlease note that you can drag’n’drop a database from Database Explorer onto a Database Diagram document that can be created by selecting ‘File → New → Database Diagram’ from the popup menu. Relations between tables will be displayed on the diagram. The database changes made on the diagram will be applied straight to the corresponding database.
Please refer to the ‘Designing Databases with Database Designer’ and the following articles in our blog:
http://blog.devart.com/how-to-create-mysql-database-in-one-shot.html
http://blog.devart.com/getting-started-with-database-designer.html
-
Prevent editing of data in a sql query, if no primary key.
Prevent editing of data in a sql query, if no primary key. Now it is allowed, and updates all data on the condition of the query, not the exact line.
3 votes -
When searching objects (cntrl+D,F), searching in tables data and you get a lot of results, that do not fit in result windows, a scroll bar i
When searching objects (cntrl+D,F), searching in tables data and you get a lot of results, that do not fit in result windows, a scroll bar did not show up. It needs to click on the place where it should be, only then it appears.
3 votes -
Make "AS" keyword auto-select in code completion dropdown.
Most keywords seem to auto-select in the code completion dropdown as you type, with the only exception I've noticed so far being "AS" for column and table aliases (even though its the only choice in the list most of the time). Other short keywords such as "ON" and "BY" will auto-select, making it easy to type in lower case, get the suggestion dropdown, have it automatically selected for you, hit Enter to get the upper case equivalent and keep on going. With "AS" it breaks that pattern requiring you to hit down to select it in the list first.
3 votesIt’s not highlighted because this could be a part of a user-defined alias starting with AS…
Though, you can manage this with the ‘Select items in the list even if a user input is expected’ option available in the ‘Text Editor → Code Completion → List Members’ branch of the ‘Options’ window that can be invoked by selecting ‘Tools → Options…’ from the main menu.
-
Issue with import of DATE/DATETIME fields from Excel 2007
In latest version of dbForge while importing Excel 2007 file columns formatted as a date cannot be properly recognized as dates (they are recognized by dbForge as serial numbers) and due to this cannot be properly imported to the corresponding table fields. In older versions such bug hasn't had a place.
Import date fields from Excel 2003 works fine in 6.3.330 version.BR
3 votes -
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’. -
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 -
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 -
execute a structurecompare or datacompare atthe same time
excuse my english, is google translator
3 votesThis could be performed with the Copy Database feature https://www.devart.com/dbforge/mysql/studio/docs/index.html?copy_databases.htm
-
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/
-
GROUP_CONCAT
Don't show GROUP_CONCAT in queries.
3 votes
- Don't see your idea?