460 results found

1. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. 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 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 generated update script:

   -- Disable foreign keys

   /*!40014 SET @OLDFOREIGNKEYCHECKS=@@FOREIGNKEYCHECKS, FOREIGNKEY_CHECKS=0 */;

   SET NAMES 'utf8';

   --

   -- Set default database

   USE client_sol;

   --

   -- Enable foreign keys

   /*!40014 SET FOREIGNKEYCHECKS=@OLDFOREIGNKEY_CHECKS */;

   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… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. 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: import, export, backup, restore.

   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:… more

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Erro no atalho

   Erro no atalho , como copiar e colar... ctrl+q para filtrar... f5 para execultar

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. copy and paste

   copy anda paste from view data and excel not work

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Bugs  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Questions  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. 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

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. 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 too

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  Features  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. 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

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    planned  ·  2 comments  ·  Features  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. 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

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    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.

14. 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 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, Devart) responded

    You could try the following instructions http://www.microsoft.com/hardware/en-us/help/windows-8/how-to/mouse/use-partialscroll-mouse

15. 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@localhost PROCEDURE sp_test()
    MODIFIES SQL DATA
    BEGIN

    ALTER TABLE foo RENAME TO bar;

    END
    $$

    DELIMITER ;

    Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error message "Unable to parse source text" and refuse to open.

    Similar error messages come up when trying to execute a schema comparison that includes affected procedure.s

    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@localhost PROCEDURE sp_test()
    MODIFIES SQL DATA
    BEGIN

    ALTER TABLE foo RENAME TO bar;

    END
    $$

    DELIMITER ;

    Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error… more

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    AdminDevart (_, 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 .

16. compare objects via right-clicks

    compare source objects, table def & data via right-clicks (See Beyond Compare@ScooterSoftware.com)

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. table change -> view update (with preview)

    When making a table change, validate all source objects / views (in case of column name change). Provide list of objects that this update affects and allow double-click to edit or view update (with preview) Beyond Compare style!

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Features  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. PHP code editor
    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Gutter (right margin)

    Add gutter (aka right margin) for code inspections.

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Make it understand macroses used in UniDac

    It would be great if dbForge Studio for MySQL understood macroses, that are used, for instance, in UniDac, or just ignored them.

    Currently, if you copy code from the TUniQuery SQL editor, you need to then edit it. Once it has passed debugging, you need to edit it once again in TUniQuery SQL editor. It's quite uncomfortable and sometimes takes much time.

    Also, code formatter converts &dtstart into & dtstart (i.e adds space after ampersand (&).

    0 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close