465 results found
-
Please save the current setting "Current Document" on the Find Dialog
Please save the current setting "Current Document" on the Find Dialog. It defaults to 'All Open Documents' which is very dangerous
1 vote -
1 vote
-
A search box at the top of tables to make it easier to locate a particular table - I have well over a 100 and don't always remember the name
A search / filter box at the top of "tables" to make it easier to locate a particular table - I have well over a 100 and don't always remember the full name of the table. You type in part of the name and it would filter the tables list by the entered text.
1 vote -
Database copy you may select all database but it is not possible to set all include data and Drop if exist on target
Database copy you may select all database but it is not possible to set all include data and Drop if exist on target
1 vote -
Add an indication as to what database or file has been run in the Backup / Restore dialog box
I regularly run large files against a database or restore multiple databases at one time into separate environments (dev, stage, etc). When the Restore Completed Successfully message appears, there is no way to determine which script or database has been completed. I would suggest amending the message to something like "Restore to database xxxx completed" or "Execution of script xxxx in database yyyy completed successfully"
1 vote -
1 vote
-
Viewing first data table in Table/view detail
When open table, configure if view data first or Columns, now only open in columns tabs. i prefers data tabs. (Cuando abres una tabla que se pueda configurar si se ve primero tabla de datos o de configuración de columnas. Ahora solo se abre en el tabs de configuración de columnas)
sorry my inglish is no good. :-)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 -
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 -
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 -
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 -
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 -
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 -
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 -
Properties view on table, option to view all fields
In Properties section you can only view the tables properties, but if a additional view/option can be give to list the column names and type it will help alot for now one has to open the table each time to view these instead of a quick click on table and see iets columns.
Also if those fields (name and type) can be selected for copy it will help alot
as I use it alot in Workbench when developing.1 vote -
You have a bug, this stored procedure has legal text, you can compile it, but it cannot be edited by the tool.
You can compile this stored procedure but you cannot edit with your tool, it says that the code is wrong, but it is not.
CREATE DEFINER = 'root'@'%'
PROCEDURE simulation.comparebill()
BEGIN
with mybill AS(
with billing AS(select c.day AS day,c.code AS code,cast(c.seconds as double) / 60.00 AS Mins,
case when r.code is null then 0.005 when c.jurisdiction = 'Inter' THEN
r.inter when c.jurisdiction = 'Intra' then r.intra else greatest(r.intra,r.inter) end AS rate,
ifnull(r.description,'Missing Destinations at $0.005') AS description
from (cdr c INNER join ratedeck r on(c.code = r.code))) select billing.day AS day,billing.description AS description,
round(sum(billing.Mins),2) AS Minutes,
round(sum(billing.Mins * billing.rate),2)…1 vote -
Allow Skip Idénticas, remove or unmap
Allow Skip Idénticas, remove or unmap. If one knows the databases are offline, idéntica tables will Stay the same and dont need to be recompared. Do better at managing Idénticas.
1 vote -
Showing total rows next to record count
Showing total rows next to record count example. "Record 1 of 302+ of 25000" or something similar, always knowing the total rows in a query or filter is very important
1 vote -
1 vote
- Don't see your idea?