460 results found

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

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

   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. multiple result set pages for show previous data as toad for mysql
   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

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

   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

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

   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

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

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

   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

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

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

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

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

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

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

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

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

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

    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

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

    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

18. When we alter a table and we do a EDIT on the same table after, the changes are not visible.
    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

19. Export to MS Excel 2007

    Currently, exporting to MS Excel 2007 more than 1048576 rows, dbForge doesn't slipt to a new Sheet the remaining rows.

    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

20. Projects

    I'm not the DBA but a DB developer. I use PROJECTS to manage scripts and SQL tools by project and support ticket.

    I want to be able to define the various FIlter Setting within a project as well.

    Meaning, when I load a PROJECT, not only do I get access to my various SQL scripts for that project, but it also loads FILTER settings as well. We have a few thousand tables, and it's various tedious to keep redefined the filters when I switch projects.

    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