Skip to content

dbForge Studio for SQL Server

dbForge Studio for SQL Server is an SQL server development tool incorporating query builder, data import/export and compare tools for managing and analyzing data.

To consider your idea as soon as possible, follow the guidelines:
  • Describe the goal you want to achieve and what result you want to get
  • If you have a solution, add it to the description
  • Give examples that we can use to implement your ideas
  • Add one suggestion per post. If you have several ideas, share them in separate posts
  • Add comments to the suggestion

dbForge Studio for SQL Server

Categories

JUMP TO ANOTHER FORUM

28 results found

  1. After searching for an object, if you clear the filter, data is not displayed

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  2. When dbforge Studio creates the Documention for a Database all "Depends On" and "Used By" refers are empty when the Database Name contains a "-".

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  3. Probably 2-3 times a day DB Forge crashed. Quite often it does this while i'm not even using it. All I get is the windows 'dbForge Studio for SQL Server has stopped working' dialog (the one which has the Debug and Close Program buttons). This has started happening after the last update

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  4. Often, when editing functions, and I try to save something with invalid syntax, I will get a pop-up with "Object has invalid source text and cannot be saved" instead of the useful list of errors with line numbers. (However, the product still often red-underlines a problematic portion in these cases.)

    That annoyance is separately reported here:

    https://devart.uservoice.com/forums/177009-dbforge-studio-for-sql-server/suggestions/7488676--object-has-invalid-source-text-improve-error-i

    However, sometimes, after getting this once, every successive save will fail with that error, even after the problem has been resolved. Copying and pasting into SSMS will verify that it is correct. Then closing and re-opening the function editor window will allow me…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Admin →
  5. Invalid scripting for FK deleting using "IF OBJECTID('FK...', 'F') IS NOT NULL" check.
    There is need to use schema as part of FK name. Reason: "OBJECT_ID() function returns NULL for "non-dbo schema" FK.

    Bad script:
    IF OBJECTID('FKFDlalala', 'F') IS NOT NULL
    ALTER TABLE EE.FD
    lalala
    DROP CONSTRAINT FKFDlalala
    GO

    Uber script:
    IF OBJECTID('EE.FKFDlalala', 'F') IS NOT NULL
    ALTER TABLE EE.FD
    lalala
    DROP CONSTRAINT FKFDlalala
    GO

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
  6. Do any select, copy with column names. Paste into Excel. Data pastes properly, but column names do not.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Bugs  ·  Admin →
  7. if you edit a user-defined functions, any pre-existing permissions are removed. They should not be.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  8. Apologies, not sure if this is a bug or needs to be a feature. I love the identification of tabs using the shape and color of a connection. I would LOVE it if that color would also transfer to the status bar, which on my setup is always blue. Due to the status bar's visibility, I get super confused when I'm on a connection colored, say, red (production) but the status bar is blue (test).

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  9. Am I the only one thinking the latest version of DB forge is still full of bugs?

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  10. dbForge Studio crashes after an extended period of being open ( memory leak most likely) 5.4.275

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  11. Lost cursor after executing script

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  12. I have reported a few bugs over the past few months, and although you are good at responding and looking into this there seems to be a few bugs that you can't seem to get right.

    1. Upgrading. It is always painful. Links that you publish to download the upgrade don't work. There are always licencing/activation problems, etc. I upgraded yesterday as advised (having gone through the normal pain to find the right place to download), and everything seemed to work. Yet today I am asked to enter my activation key yet again. Why can't you just make the upgrade seamless?…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  13. 5.4.211 crashes upon schema synchronization

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  14. I have a database server with many dozens of databases containing many hundreds of objects (tables, views, etc.) each. I use the mouse scroll wheel to scroll this list in MS SSMS and I would hope to be able to do this with dbForge Studio.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Bugs  ·  Admin →
  15. Example:
    select *
    from Schema1.Table1 join Schema1.Table2 on Table1.[AutoComplete doesn't show table fields]

    select *
    from Schema1.Table1 T1 join Schema1.Table2 T2 on T1. [AutoComplete works properly]

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
  16. Normally, if I do an incremental search (CTRL+I) or a normal search (CTRL+F), pressing F3 takes you to the next location of your search text in the current file. With DBForge it seems to jump all over the place. The only place it doesn't take you to is the next location in the current file, which basically makes it impossible to use.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
  17. If you set "Use styled images" in options, all the icons/images use this setting except for the cell edit cascade menu... as shown here:

    http://tinypic.com/r/2cmvvwn/9

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  18. use this script for test:
    DECLARE @FILENAME AS NVARCHAR(500),
    @FILE
    NAMEPRE AS NVARCHAR(500),
    @FILE
    NAMESUF AS NVARCHAR(500),
    @SQL
    STMT AS NVARCHAR(MAX)

        SET @SQL_STMT = 
    'SELECT 
            t1.*,
            CASE WHEN c1 IS NULL
                 THEN ''Y''
                 ELSE ''N''
            END AS [COLUMN1],
            t2.c3
       FROM t1
       LEFT JOIN (SELECT *
                    FROM (VALUES
    (''v1'',''v1'',''v1''),
    (''v2','v2','v2''),
    (''v3'',''v3'',''v3'')) RET (c1, c2, c3)) t2 ON t1.c1 = t2.c2 '
    

    if you press "Display Estimated Execution Plan", then the first line will be highlighted with an error: Incorrect syntax near ','.
    But if you press "Execute" then correct one will be highlighted

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
  19. Last beta version does not autosize the result set (regression). You have to retrieve multiple times to get the results aligned properly.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
  20. Quando executo uma consulta pela primeira vez, após a carga da aplicação, nada é exibido. Somente após fechar uma das janelas é que consigo voltar a visualizar a saída dos resultados.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
← Previous 1
  • Don't see your idea?