75 results found
-
Fixing database in git repo
When view contains some unicode notation for fields aka N' it shows difference over and over even after fixing.
When field contined some collation it shows difference over and over.
[ModelNumber] [varchar](50) COLLATE SQLLatin1GeneralCP1CI_AS NOT NULLPls fix it asap. I have dozen of objects showing that they have difference however they don't
3 votes -
Much improved syntax error and debugging experience in the template editor when using Entity Developer.
Currently, when you are working with your own templates or ones you have modified, it is very easy to have a few syntax errors during your edits. It is my experience that the line error information is either not correct or entirely not working most of the time. Clicking on an error is useless since it does not actually take me to the error (sporadic and inaccurate). After minor template changes I made, I have often spent hours trying to figure out the error messages I get when I run, only to find some stupid one character mistake in the…
3 votesAdminDevart (_, Devart) respondedCould you please clarify what functionality you are referring to and provide us a concrete example of this? Screenshots would be also of help.
You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom.
-
There is a problem using "groups" word as name for table or part of a stored procedure
There is a problem using "groups" as a name for a table or using that word as part of a stored procedure.
I have a table named like this and when trying to make a backup I always get the same error message: Unexpected symbol 'groups'
If I try to compare 2 schemas it also fails.
In my case I use dbForge Studio for MySQL Professional Edition v9.1.21
3 votes -
3 votesAdminDevart (_, Devart) responded
Could you please provide us a concrete example of this?
You can send a reply straight to our support system at supportATdevartDOTcom
-
3 votes
-
Fix JSON view colors for dark themes
Using the JSON view in dark themes is annoying as there is no way to configure foreground colors for numeric data types so they are displayed as black on black
3 votes -
"Modify via SQL" always Refresh automatically before opening Editor
When we work in Stored Procedures we already overwrote accidentially code as we were working in different windows and worked on an old version of the code
It is annoying to always need to refresh first to make sure that no old copy of the code is edited.
3 votes -
Search text in trigger statement
The text search in trigger statements doesn't work using the "Find box" with "Look in -> Current Document".
Can you please solve this problem?
Thank you very much for your great work!
Francesco
2 votes -
Code for CREATE TABLE with MariaDb "system versioning" is not generated correctly.
On a table with system versioning, from context menu I select:
Generate script as > CREATE > To new SQL window.
And the output does not include SYSTEM VERSIONING data at all.
When I run SHOW CREATE TABLE tablename - I get correct information.The same with "Edit table"
(In general it would be nice to set, if "Generate script" uses dbForge engine, or from database "SHOW CREATE TABLE", because output sometimes is drastically different)2 votes -
I need posibility to run SQL not SQL files only.
SQL code saved in file with "config" extension cannot be executed. Can you redefine this ? I need posibility to run SQL not SQL files only.
2 votesAdminDevart (_, Devart) respondedCould you please let us know why you need this?
-
Floating Windows - why is this disabled for DB object tabs?
I'm not sure if this is a bug or if I'm just "holding it wrong" but there doesn't appear to be a way to get object editing tabs to float. Windows like the Object Viewer do (though this is disappointingly without independent minimising controls) but if I'm editing a table or a sproc then the "Float" option is disabled.
Is there a reason for this?
Ideally I think it would greatly help the product if it were possible to float windows and group floated windows into one floating tab group and if each floating object can be minimised/maximised independently of…
2 votes -
Allow variable identifiers to be user defined to accommodate multiple environments.
We are unable to define delimiters for variables. This causes query code from dbForge to fail when copied to a java based production environment.
Currently the dbForge variable delimiters are not compatible with many environments.
Provide means for users to define variable delimiters like DbVisualizer does.
2 votes -
database name
DATABASE: test
DATABASE: Test
DATABASE: tEsTdbForge identify the same database and can't find tables because the database differs to others as identified with the same name
2 votesAdminDevart (_, Devart) respondedCould you please describe it in more detail?
Also, you may need to change or remove a database name in the ‘Database’ field of the Database Connection Properties dialog box (right-click the connection in Database Explorer and select ‘Modify Connection…’ from the popup menu).
-
Crashed automatically
During a long time runing and I havn't do any operation, the dbForge Studio for MySQL will crashed by itsell.
I see the windows event log like below, any solution?
Faulting application name: dbforgemysql.exe, version: 7.3.137.0, time stamp: 0x5a5750d3
Faulting module name: ucrtbase.dll, version: 10.0.15063.674, time stamp: 0x8ac9f9d4
Exception code: 0xc0000409
Fault offset: 0x000000000007350e
Faulting process id: 0x26fc
Faulting application start time: 0x01d398c7e6228539
Faulting application path: C:\Program Files\Devart\dbForge Studio Express for MySQL\dbforgemysql.exe
Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
Report Id: dc61c8e8-1ed4-44d0-8ac0-57011fb3f67a
Faulting package full name:
Faulting package-relative application ID:2 votesAdminDevart (_, Devart) respondedCould you please turn on dump generating as described below and send it to us for investigation?
1. Start Regedit.exe
2. Create a registry key:
“HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Windows Error Reporting\LocalDumps\dbforgemysql.exe”
3. Add the following values into it:
“DumpFolder”=“С:\\DbForgeDumpFolder”
“DumpType”=dword:00000002
“CustomDumpFlags”=dword:00001124
4. After the application crashes, send us the content of the folder “DbForgeDumpFolder”.You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
BUG: When Copy & Paste As New Record string values are cut off after NON-Iso characters. Just like ä ö ü. even if it is defined as UTF-8
BUG: When Copy & Paste As New Record string values are cut off after NON-Iso characters. Just like ä ö ü. even if it is defined as UTF-8
1 vote -
output window
1) meanwhile the execution of SQL script file if I click on some other window, ant then return in output window...the output windows shows the first output...and not the (more usefull) last one.
2) please fix it! I have more than one schema. I select the first one. Open a SQL file...launch it. Ok. I open a second SQL file...THE SCHEMA CHANGE without show me the change and dbForge run the SQL script on the second schema!!! Damn it!
1 vote -
bug in table edition with graphic table editor
the table designer has a BUG. A table column can have as a default value an internal server variable, in my case @@bindaddress. The correct way to add it (@@bindaddress), and it works. But when the table editor reverses a table definition, it misinterprets these defaults and saves it back wrong.
1 vote -
There's no effect in the setting of Hightlight SELECT Statement?
I remember this effect is good for the text editor of the SQL,but why is no effect now?
1 voteAdminDevart (_, Devart) respondedCould you please provide us a screenshot explaining this and describe the steps to reproduce the issue in detail?
You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom
-
there is a BUG on the tool
When you reverse engineer a table with a column defined like this
tdate timestamp NOT NULL DEFAULT date(CURRENTTIMESTAMP) ON UPDATE CURRENTTIMESTAMP
after any change in the table, unrelated, you write the same column as
tdate timestamp NOT NULL DEFAULT 'date(CURRENTTIMESTAMP)' ON UPDATE CURRENTTIMESTAMP
which is wrong, the quotes cannot be there. The modification fails.1 voteAdminDevart (_, Devart) respondedCould you please provide us the CREATE definition of the table and specify what version of dbForge Studio for MySQL you are using?
You can reply straight to our support system at supportATdevartDOTcom
-
Data viewer stops working
The data viewer stops working intermittently. The only way to get it working again is to restart dbForge. I execute a query, and then right click on a cell in the results and select Data Viewer. In most cases this shows the data in the Data Viewer panel but it regularly jus displays nothing.
1 voteAdminDevart (_, Devart) respondedPlease make sure you are using the latest build 6.2.280.
If the issue still persists in the latest build, please provide us the CREATE definition of the table and a test record so we can reproduce the issue on our side.
You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.
- Don't see your idea?