471 results found

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

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

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

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

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

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

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

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

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

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

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

12. onlyoffice sheet import same as Google Sheets method

    Import from Onlyoffice with Nextcloud same as Google Sheets method

    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. right-click on cell -> Set value to -> custom value requested by input

    right-click on cell -> Set value to -> custom value requested by input,

    actually I can set to 0 or null, but in my case y need value "1" or another value.

    I Actually re-paste values from same column to the rows needed, it's more easy for me set value to all column if I do a good search query before.

    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. Character set 'perlogicalinterfacedtoview' is not supported

    Comparing two databases I encounter this error.
    I have selected "Detect mysql charset" as I am advised by the error message.
    However I keep receiving this error.
    Is there a way to manually add some encodings?
    I have updated the application to the latest update.
    DB forge Studio for Mysql Pro.

    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

15. Please add: ignore views when comparing database schema in DBforge studio for mysql

    I would like to exclude tables with table_type VIEW, aka exclude the views when comparing two database schemas..
    This would be a nice feature.

    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

16. modify your Database Design Diagram options to include the ability to manually force a one to one relationship. Currently not able to do so.

    See above

    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

17. Give new tabs custom descriptions
    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. retreive data with sql

    I want to retreive data with editable sql (select statement). It could be implemented now, but I want it in context menu.

    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

19. Add ability to compare stored procedures with formatting applied

    Having the ability to compare formatted versions of stored procedures would allow to ignore stored procedures that are identical even if they are not formatted exactly the same.

    The performance cost would be marginal compared to the usefulness of sorting out equivalent stored procedures.

    When comparing code, what it does is what is 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

20. Improve copy database function in MySQL

    Just like in HeidiSQL
    1. Allow select not only schema but also tables and other objects
    2. Allow set "copy data" for each tables individually (eg. log tables with millions and GB of worthless records, whitch I don't need on destination)
    3. Allow to skip errors and go further (eg. from MySQL 5.7 to 8.0 I have some columns named ROWS or LEAD, whitch couse errors in 8.0, but I cannot fix it if I cannot copy that objects)
    4. Add logs from copu function to Error List view. Currently they are showed only as a small on-mouse over hint.

    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