460 results found
-
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 -
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 -
Be able to disable GroupDatabasePrivileges query from executing in Schema Compare and actually NOT RUN the query
Be able to disable GroupDatabasePrivileges query from executing in Schema Compare and actually NOT RUN the query as its slow one som systems. In schema compare I have ignore privileges ticked, but the query still runs
6 votes -
International date formatting not working
See: https://i.imgur.com/FvTda6n.png
Sometime in version 9, 'datetime' fields in tables and queries format to the American standard, even though the formatting options show an example of International formatting, this is not applied
4 votes -
Show/Hide additional document views
With new DBForge update (2020), keyboard shortcut to show/hide additional document views is gone. Please add this feature back as it was extremely convenient to show/hide data results when writing long procedures.
5 votes -
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).
-
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 -
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 -
Start transaction read only
When I editing storage procedure and I add START TRANSACTION READ ONLY;
it is marked as error ';' expected8 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 -
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.
0 votes -
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
- Don't see your idea?