220 results found
-
GROUP_CONCAT
Don't show GROUP_CONCAT in queries.
3 votes -
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 -
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
-
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’. -
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 -
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.
-
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. -
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. -
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.
-
Cannot edit views if column no longer exists
If you have a view that uses/selects columns that no longer exist, you cannot open the view to edit/fix the missing columns:
View '<TABLE>.<VIEW>' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
3 votesPlease check that you are using the latest build 6.3.358 https://www.devart.com/dbforge/mysql/studio/download.html
-
Support for fractional datetime
since Mysql 5.6.4 (2011), there is a support for fractional datetime and timestamp.
cf. http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html
select now(6) should return 2015-07-16 23:48:52.720993 (like with phpmyadmin) and not 16/07/2015 23:46:52
or better , it should return the localized version 16/07/2015 23:46:52.720993
3 votesThis can be setup as follows:
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’. -
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 -
Process left in memory after program closes.
Each new run left another instance. Eat memory, lock updates. All 7.x versions, last 7.0.52.0 too.
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\ -
3 votes
Such feature is present in dbForge https://www.devart.com/dbforge/mysql/studio/docs/index.html?how_to_manage_database_connections.htm
-
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 -
Mysql 8.0
Nao tem suporte ao MySql 8.0
3 votes -
Fix data compare by text key
Beginning with dbForge Studio of MySQL 7.3 (possibly earlier), and continuing into the recently released 7.4.201, I am seeing some incorrect results when using the data comparison feature.
Specifically, it seems to happen when I compare data based on a textual key column rather than the integer-based primary key. Here is an simple example that will produce incorrect results with 7.4.201:
-- ###########################################
-- Server 1CREATE TABLE test (
id INT(10) UNSIGNED NOT NULL AUTOINCREMENT,
keyVARCHAR(255) NOT NULL,
value VARCHAR(80) NOT NULL,
PRIMARY KEY (id),
UNIQUE INDEX uniquekey (key)
)
ENGINE = INNODB,
CHARACTER…3 votes
- Don't see your idea?