473 results found
-
"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 -
Better error message in data comparison (table name)
Hello,
When doing a data comparison and having an error, a message such as the following one is displayed:
"Error (1,1): Duplicate entry 'WBAH2022-2' for key 'Old'"The problem is that, when the data comparison is against tables, it's not easy to find the table with the problem. It would be very useful to have, at least, the name of the table.
Having also the value of the primary key would help further for this kind of error.
3 votes -
github copilot
Are there any plans to introduce GitHub co-pilots into dbforge studio for MySQL?
3 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?
-
2 votes
-
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 .
-
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).
-
explorer interface
- click on conection name expant tree node & conect 2 DB
- after close connection same action will only expand tre node, but not connect 2 DB - it wrong 4 several DB developers.
MUST:
click on node [+/-] expand|collapce it, but click on connection name is ALWAYS make real connection 2 DB when expanded.2 votes -
Disable foreign keys when deleting or truncating table
When deleting or truncating a table I would like to have the option to disable foreign key checks for this operation. This could be a simple check box which is unchecked by default.
If foreign keys are present, I either have to drop the database and recreate the whole schema or delete one-by-one figuring out the correct order or I have to write an SQL script with a lot of drop table statements and surrounding them with the foreign key checks setting.
This is cumbersome, especially for development purposes when I have to clear test data very often or deploy…2 votes -
Sync edit object in tag with selection in the database explorer
Please could you add a feature where the tab you are editing, e.g. a table, is sync selected with the database explorer
2 votes -
Remember last open tab in table/view detail
Most of the time, I want to see the table data, so I have to change tab from "Main" to "Data" every time I open the table details. Please add an option that remembers the last open tab for each table/view.
2 votes -
parameters
When defining the parameters for a Stored Procedure using the UI. Could the TAB key navitgate through the columns in the list "Name", "Type" and "Direction"? It would make it much quicker to add these if the hands can stay on the keyboard.
2 votes -
Smart explain integration
Advices to use indexes in queries
2 votes -
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 -
Todo/Task list for Database Project feature
To expand on the Project feature a Todo/Task list would be awesome as it would help me keep track of things I've done and haven't!!
2 votes -
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 -
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 -
memsql support
Предполагается ли поддержка memsql? https://www.memsql.com/product/
База реализует протокол MySQL. к ней можно подключиться любым MySQL клиентом, но не DbForge. Выдает ошибку https://i.imgur.com/vDP8fI0.png
Вероятно связано с особенностями DbForge при подключении к MySQL.
Поддержка memsql практически ничего не стоит, так как используется MySQL протокол, зато можете написать, что DbForge очень крутой и поддерживает еще и эту memsqlС уважением, Сергей
2 votes -
Automatic naming of the connections should be reversed
When a new connection is created, it gets the name of the database.ip.add.re.ss, but when you have 100+ connections, it takes a long time to find the one that you need to work with, since typically the database names are the same, at least in my business. I need that the name be ip.ad.re.ss.database, and the IPs be sorted by IP, not alphabetically, si it would be faster to locate a connection.
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
- Don't see your idea?