464 results found

1. Allow disabling quotes for SHOW CREATE TABLE during schema compare.

   Give an option to run SET sqlquoteshow_create=OFF; before a schema compare. So that the schema generated via MySql does not add the quotes to everything.

   6 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  ·  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

   Submit Rating

2. 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) AS Total
   from billing group by billing.day,billing.description WITH ROLLUP)
   select ifnull(mybill.day,'') AS DAY,ifnull(mybill.description,'') AS DESCRIPTION,
   lpad(format(mybill.Minutes,2,10),14,' ') AS Minutes,
   lpad(concat('US$ ',format(mybill.Total,2)),14,' ') AS Total FROM mybill
   WHERE description IS NOT NULL OR day is null
   ORDER BY day DESC;
   END

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

   Submit Rating

3. add UI for sorting and searching for connections in the database explorer

   I have about 100 database connections - these appear to be presented in creation order, so I have to remember when I created something in order to find it

   This view should at least have a sort option... Others have suggested search, which would also be a great help

   4 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  ·  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

   Submit Rating

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

   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

   Submit Rating

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

   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

   Submit Rating

6. 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 RECURSIVE TMP as Select .... from ...) Select ... from TMP

   • crdebug.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 crdebug database are found ... crdebug.UPDATEWATCH3, crdebug.TRACE, crdebug.LEAVEMODULE, crdebug.UPDATESYSTEM_CALLS

   == German ==
   Der "Find Invalid Objects" Assistent listet in der neuen Version "dbForge Studio for MySQL 9.0.338" folgende Objekte auf:

   • In Views werden temporäre Tabellen als nicht auffindbar gelistet
     In Vden Views werden die Temporären Tabellenz.B. mit dem folgendem Befehl erzeugt:
     WITH RECURSIVE TMP as Select .... from ...) Select ... from TMP

   • crdebug.ENTERMODULE2 wird nicht gefunden. Es wird in der jeweiligen Datenbank gesucht; jedoch nicht in der Datenbank cr_debug.

   • crdebug.ENTERHANDLER wird nicht gefunden. Es wird in der jeweiligen Datenbank gesucht; jedoch nicht in der Datenbank cr_debug.

   • weitere Objekte aus der crdebug Datenbank werden nicht gefunden... crdebug.UPDATEWATCH3, crdebug.TRACE, crdebug.LEAVEMODULE, crdebug.UPDATESYSTEM_CALLS

   == 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 RECURSIVE TMP as Select .... from ...) Select ... from TMP

   • crdebug.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… 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…)
   0 comments  ·  Bugs  ·  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

   Submit Rating

7. 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.id ASid,
   Z.von_bis ASvon_bis,
   Z.amount ASamount,
   Z.von ASvon,
   Z.bis ASbis
   FROM (counterZ
   JOIN reading A
ON ((Z.id= A.zaehler`)))
   As you can see, a lot of parentheses are added inside the Select From part.

   When editing such an object again, you often have to remove the additional characters (`characters and brackets) before you can edit the object in question again.

   There should be new options with which the strange behavior can be deactivated if necessary.

   == German ==

   Info: Der Feature-Editor kann den Quell-Code nicht korrekt übernehmen. Im Forum https://forums.devart.com/viewtopic.php?f=23&t=41350 kann das Anliegen richtig angezeigt werden.

   Nach dem Erstellen einer View, Function, Stored Procedure werden die Objekte in der aktuellen Version stets mit einem `-Zeichen am Anfang und Ende eines Namens gekennzeichnet.

   So wird zum Beispiel aus einem Simplen Select-Befehl ...

   SELECT Z.id,
   Z.von_bis,
   Z.betrag,
   Z.von,
   Z.bis FROM zaehler Z
   INNER JOIN ablese A
   ON Z.id = A.zaehler

   ... nach der Übername ...

   SELECT
   Z.id ASid,
   Z.von_bis ASvon_bis,
   Z.amount ASamount,
   Z.von ASvon,
   Z.bis ASbis
   FROM (counterZ
   JOIN reading A
ON ((Z.id= A.zaehler`)))

   Wie man sehen kann, werden zusätzlich viele Einklammerungen innerhalb des Select From-Teils hinzugefügt.

   Beim erneuten Bearbeiten eines solchen Objekts muss man oft erst die Zusätzlichen Zeichen ( `-Zeichen und Einklammerungen) entfernen, ehe man das betreffende Objekt wieder normal bearbeiten kann.

   Es sollten neue Optionen geben, mit denen das eigenartige Verhalten bei Bedarf deaktiviert werden kann.

   == 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.id ASid,
   Z.von_bis ASvon_bis,
   Z.amount ASamount,… 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…)
   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

   Submit Rating

8. 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 the least efficient method possible to make the necessary changes.

   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… 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…)
   0 comments  ·  Bugs  ·  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

   Submit Rating

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

   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

   Submit Rating

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

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

    Submit Rating

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

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

    Submit Rating

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

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

    Submit Rating

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

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

    Submit Rating

14. Implementazione lingua italiana del prodotto
    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  ·  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

    Submit Rating

15. database name

    DATABASE: test
    DATABASE: Test
    DATABASE: tEsT

    dbForge identify the same database and can't find tables because the database differs to others as identified with the same name

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

    Submit Rating
    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).

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

    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

    Submit Rating

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

    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

    Submit Rating

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

    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

    Submit Rating

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

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

    Submit Rating

20. 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, but I didn't find it.

    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,… 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…)
    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

    Submit Rating