465 results found
-
Change Font Size
Option to set the font size on the database Explorer and other view windows, like the Data Viewer for example, on 4K monitor , the size are very small , don't and using window Scale. mess up all (Version 9.1.8)
1 vote -
Ability to save scripts for comparing tables
In my project, my team needs to compare over 100 tables and they do not see an ability to run saved scripts. Using this feature, they can create the comparison scripts as an one time activity and then run them as needed.
1 vote -
Taskbar item should show up for each floated (query) window
I like to have floating query windows because I run a lot of queries and often would like to compare results in windows next to each other.
Currently these floating (undocked) windows do NOT produce a taskbar item respectively. I think they should. This way I can find my queries instead of losing track of them. One window might cover the others and then I can't see them.
Navicat currently has this feature. dbForge can top Navicat.
Please implement this feature! The taskbar item should show up in the monitor where the floating window currently is located.
Thank you!
1 vote -
Different row color every 3rd row for visual differentiation
All the rows currently have the same color (except any row that is selected).
They should have color differentiation. The "old school" way was to have alternating colors but the smart way is to have a different color every third row, as that is sufficient for eyeballing a long row. Each row will have a different-colored neighbour this way and so there's no confusing each row visually.
Let's do this! Navicat has this formatting implemented, I'm surprised dbForge doesn't have any visual row differentiation.
Thanks!
1 vote -
Facilitate MariaDB 10.11
The current version of DB fORGE STUDIO supports up to MariaDB 10.6 which is limited in respect of JSON functionality. With respect to querying you cannot join a regular table on a JSON path or use methods like JSON_TABLE(). Such efforts result in an error.
1 vote -
Compare data bases lists table as different, thought they are the identical
When comparing databases, we constantly get the tables with no differences. And final script doesn't have any alter statements.
Ex.: the table
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT NULL,
SiteGroupId INT NOT NULL
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb40900ai_ci;ALTER TABLE SecurityContextXSiteGroup
ADD UNIQUE INDEX SecurityContextXSiteGroup_UN(SecurityContextId, SiteGroupId);ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourp_FK FOREIGN KEY (SecurityContextId)
REFERENCES SecurityContext(SecurityContextId) ON DELETE CASCADE ON UPDATE CASCADE;ALTER TABLE SecurityContextXSiteGroup
ADD CONSTRAINT SecurityContextXSiteGourpFK1 FOREIGN KEY (SiteGroupId)
REFERENCES SiteGroup(SiteGroupId) ON DELETE CASCADE ON UPDATE CASCADE;The other table ("differs"):
CREATE TABLE SecurityContextXSiteGroup (
SecurityContextId INT NOT…1 vote -
Add command palette functionality
I love the command palette in VS Code and Chrome Dev Console. I can press control+p and enter a filename or control+shift+p and type, find and perform common operations.
I'd love to be able to press something like that where I can type in a table name. The list would show me matching tables in all of my connections (or even just my current active connection) and give me options to select from the table, scroll to and select the table in database explorer, open the table editor, etc.
Other common commands could be in the command palette too, like:…1 vote -
Erro no atalho
Erro no atalho , como copiar e colar... ctrl+q para filtrar... f5 para execultar
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 -
copy and paste
copy anda paste from view data and excel not work
1 vote -
horizontal toolbars
I see now a vertical tab instead of a horizontal tab as usual. I cannot figure out how to reset the app to its normal behavior. Also how do I enlarge the font of the stored procedures and table editor, it's too small for my old eyes.
1 vote -
select, copy and paste objects between diagrams
allow objects to be 'copied' between diagrams. I would like to be able to select a group of tables from one diagram and create a new diagram from those selected tables.
1 vote -
SQL notebook that can be global or per database. This can be helpful for storing and retrieving reusable SQL queries without saving files
SQL notebook that can be global or per database. This can be helpful for storing and retrieving reusable SQL queries without having to save and organize a bunch of .sql files in folders somewhere.
This is especially useful for complex queries for specific DBs or global generic ones. Also for sharing with a team.
Key word searching or tags would be nice as an option in it too1 vote -
Allow Schema Comparison to ignore differences in integer "size"
In versions of MySQL prior to 8.0, integer values were specified with a "size", such as "INT(11)". In MySQL 8.0 and newer, the size property of integers is removed, resulting in the same value having the type "INT". This results in Schema Comparison across MySQL versions (5.7 vs 8.0) reporting false-positive differences for tables.
The "ignore data types" option in Schema Comparison does not resolve the false positives, and is also probably too blunt, because column size does matter for text and binary data. Please add an option to specifically ignore differences in the "size" of integers.
1 vote -
Update Schema Comparison to improve cross-version comparision of Views
When comparing Views between MySQL 5.7 and 8.0, Schema Comparison detects "differences" to two conditions that are actually equivalent, resulting in false-positive change detection.
- Quoted text strings are prefixed with _UTF8 in MySQL 5.7 and _UTF8MB3 in MySQL 8.0. These are actually the same character set and represent no change. In fact, if MySQL 8.0 reported UTF8, it would be different, because in MySQL 8.0 the meaning of UTF8 is now UTF8MB4.
- In MySQL 8.0 Views, the schema prefix on table names (schema.table) is automatically removed when the schema of the specified Table matches the schema of the View. Therefore,…
1 vote -
Delete multiple rows
Hello,
When deleting multiple rows, the application deletes them one at the time.
If you could use a "IN" condition with the primary key, if any, the execution will be must more faster.1 vote -
Support displaying multiple databases in a connection
Currently, in Database Connections Properties, you can only select a single database or check the Show all databases checkbox. It would be useful to be able to select multiple databases in the dropdown. As an example, we could then select informationschema, mysql, performanceschema, and sys and put them under a MySQL connection.
1 vote -
view with a UDF calling an aggregate function adds quotes around the aggregate
I'm creating a view using the valid SQL:
SELECT dateAsString(MAX(a.dateStart)) AS LastDate ...
dateAsString is a UDF in my database that accepts a DATE parameter.
The query executes fine. When I save it in a view, though, dbForge changes the query text to:
dateAsString(MAX(a.dateStart))Which, obviously, won't work.
Any thoughts?
0 votes
AdminDevart
(_, Devart)
responded
Could you please provide us the following information:
1. Version of the MySQL server.
2. CREATE definition of the UDF.
3. The assembly file containing the functions called by the UDF. -
scroll 'wheels' do not work
Whether used on my laptop with a touchpad or my desktop with a mouse, dbForge Studio doesn't support scrolling in any window by any means other than clicking or dragging the scroll bar. It will initially scroll for perhaps a second and then it stops.
0 votesAdminDevart
(_, Devart)
responded
You could try the following instructions http://www.microsoft.com/hardware/en-us/help/windows-8/how-to/mouse/use-partialscroll-mouse
-
Fix Stored Procedure Editor to accept ALTER TABLE xxx RENAME TO yyy
As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.
Here is a simple procedure that will trigger the error:
DELIMITER $$
DROP PROCEDURE IF EXISTS sp_test$$
CREATE DEFINER=
root@localhostPROCEDUREsp_test()
MODIFIES SQL DATA
BEGINALTER TABLE foo RENAME TO bar;
END
$$DELIMITER ;
Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error…
0 votesAdminDevart
(_, Devart)
responded
Could you please provide us the following information:
1. Server version.
2. Result of the following query:
SHOW CREATE PROCEDURE sp_test;You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
- Don't see your idea?