471 results found
-
update initial screen size defaults
When starting up, don't maximize the window unless the screen size is 1920x1080 or smaller (full screen is disturbing on a 4K display).
if screen size larger than 1920x1080, size to 1920x1080 instead of maximizing
1 vote -
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 votes
AdminDevart
(_, Devart)
responded
Could 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).
-
Find Invalide Objects
== English ==
The "Find Invalid Objects" wizard lists the following objects in the new version "dbForge Studio for MySQL 9.0.338":Temporary tables are listed in Views as not being found
In Vden Views, the temporary tables are e.g. created with the following command:
WITH RECURSIVETMPas Select .... from ...) Select ... from TMPcrdebug.ENTERMODULE2 is not found. It is searched in the respective database; but not in the cr_debug database.
crdebug.ENTERHANDLER is not found. It is searched in the respective database; but not in the cr_debug database.
No further objects from the cr…
0 votes -
Object Name Format
== English ==
Info: The feature editor cannot correctly adopt the source code. In the forum https://forums.devart.com/viewtopic.php?f=23&t=41350 the request can be displayed correctly.
After creating a view, function, stored procedure, the objects in the current version are always marked with a `sign at the beginning and end of a name.
For example, a Simplen Select command ...
SELECT Z.id,
Z.von_bis,
Current amount,
Z.von,
Z. bis FROM zaehler Z
INNER JOIN reading A
ON Z.id = A.zaehler... after the takeover ...
SELECT
Z.idASid,
Z.von_bisASvon_bis,
Z.amountASamount,…1 vote -
Optimize sequence for constraint alterations
When you alter several constraints, drops come before adds.
Where the changes are simple, it should be safe to group them in order to minimize the time that the constraint is not in effect. I have some huge tables. If I alter three constraints to switch from UPDATE to RESTRICT, for example, the third constraint is inactive until the table is literally copied three times.
There's another post about grouping the alter commands together, and this would make a big improvement where each change causes a table copy.
In the case I just ran into, however, the generated script was…
1 vote -
Data generation for existing rows
I regularly work with privacy sensitive data. When copying a production database to a an acceptance or development environment, it would be really useful to be able to use the Data Generation to overwrite the existing names with generated names.
3 votes -
Start transaction read only
When I editing storage procedure and I add START TRANSACTION READ ONLY;
it is marked as error ';' expected8 votes -
1 vote
-
Queries Log Viewer
I noticed that you have the Event Profiler tool for SQL Server - is there a similar tool available for MySQL? I know there is the query analyzer built into dbForge Studio, but what we want to do is run a web application against our MySQL database and profile the calls being made to the DB in real time.
1 vote -
Show only Key Columns in the Database Diagram
When we drag and drop to create an ERD, all the Columns of the Table are showing and the entire Table is shown. If there 50 Column then we have to manually size the table height on the screen.
Is there an option to always show only the Key Columns when the table is dragged and dropped on to the Database Design Page?
Some of the unwanted columns on the screen are highlighted for reference.
Only Key Columns like the Primary, Unique, Foreign Keys should be shown on this screen.3 votes -
[Data Generator] Note per Data Generation file
When I create a Data Generation file, I of course adapt it in some ways. Sometimes this is just disabling one field or similar. It would be nice if one could write down some notes on the top level of the file, so what you see when you click the database name. That would enable me to e.g. write "disabled foo.bar because of circular dependency".
3 votes -
Data Generator: Generate Data for multiple databases at the same time
We have servers with many databases (>100). Right now I have to create a project for each of them, and run the data generation individually.
It would be great if there was a way to create a project in dbForge Data Generator for MySQL that covers multiple databases instead of one.
3 votes -
Show SQL statements when using the grid-based data editor for beginners
I am writing a textbook of MySQL for students from community colleges. I found dbForge Studio (express edition) is a wonderful tool for them to learn MySQL. Instead of SQL editor, they like the GUI interface even more . So, it would be better if they see the SQL statement run behind after they do something in GUI interface. For example, it will be more interesting if they may see an ALTER SQL statement after they edit data of a table by changing a text or a number using the grid-based data editor. I hope there is the feature already,…
1 vote -
multi default database
It's great if I can choose many database as default at start. Currently it just support one default database
May be it will be like this: database1;database2;database34 votes -
Prompt when editing multiple rows
When editing a data result in the grid view and the edit is affecting multiple rows, no warning / question is given. This is a very helpful feature in SQLyog when editing relative complex data results with multiple joins, and stops me from switching.
3 votes -
Combine ALTER Statements
When making multiple modifications to a table, the generated SQL script contains multiple ALTER statements. For example, If I were to add 3 new columns to a table, the resulting script would be something like...
ALTER TABLE table ADD COLUMN newcolumn1 INT;
ALTER TABLE table ADD COLUMN newcolumn2 INT;
ALTER TABLE table ADD COLUMN newcolumn3 INT;... when these could actually be combined into a single ALTER statement like...
ALTER TABLE table
ADD COLUMN newcolumn1 INT,
ADD COLUMN newcolumn2 INT,
ADD COLUMN newcolumn3 INT;The 3 separate ALTER statements essentially take 3 times longer to run than the single combined…
14 votes -
Support step-by step debugging for trigger
I would like to be able to debug trigger statements.
I would for example set a breakpoint in a trigger, execute an insert, update, or delete statement and the debugger would stop at the breakpoint allowing to check the variables and step into the code.1 vote -
Default search / replace look in
When multiple documents are open, in Find/Replace, set the default "Look in" as Current Document. Many times, by not looking to the default selected "All open documents", the replace was done to all open documents. In the few cases I want to replace in all documents, I would prefer to select the option myself or to chose Refactor.
1 vote -
Insert current timestamp (UTC) as cell value, even it has integer type.
no all of the timestamp columns has timestamp type. It wold be great to have feature as "Insert -> current timestamp" by right click on the cell value or in different way :) Thanks!
1 vote -
Commandline Issues
Whem importing from Access Database tables with a space in the name do not work at all. Also I just updated to the latest version hoping it would be fixed and now when the console prints out how many records have been imported, it prints on a new line instead of same line.
3 votesAdminDevart
(_, Devart)
responded
> Whem importing from Access Database tables with a space in the name do not work at all.
Could you please send us the imported file and let us know if you are importing into a new table or existing one?
> Also I just updated to the latest version hoping it would be fixed and now when the console prints out how many records have been imported, it prints on a new line instead of same line.
Could you please provide us a screenshot of this?
- Don't see your idea?