Skip to content
← Customer Feedback for Devart

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

(thinking…)

How can we improve the product?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

134 results found

  1. Sticky "Object has invalid source text and cannot be saved"

    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)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. Transaction log reader

    A tool to read transaction logs similar to http://www.apexsql.com/sql_tools_log.aspx

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Copy with column names doesn't paste correctly into Excel

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Execute current statement : CTRL+ENTER

    CTRL+ENTER to execute the current statement, or be able to set the key combination(s) in Options.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  AdminDevart (_, Devart) responded

    This can be achieved as follows:

    1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Environment → Keyboard’ branch.
    3. Type ‘Sql.ExecuteCurrent’ in the ‘Show Commands Containing’ field.
    4. Select the found ‘Sql.ExecuteCurrent’ command in the list below.
    5. In the ‘Use new shortcut in’ field, select ‘Text Editor’.
    6. Set the focus in the ‘Press shortcut keys’ field and press the required key combination.
    7. Click the ‘Assign’ button.
    8. Click ‘OK’.

  5. Autocomplete doesn't work if table belongs to schema and no alias or schema name used in join.

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Add ability to enter product key on trial versions

    Not a big deal, but it would be nice to be able to just enter a product key, instead of having to download a new version.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. buggy release

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. Add ability to define object file name format in Source Control and Schema Compare

    Currently dbForge Source Control generates files using <schema>_<objectname>.sql naming convention.
    dbForge Schema Compare does the same if you script objects to a folder.

    Such naming convention does not match our naming conventions.

    Can you please add ability to define object file name format in Source Control and Schema Compare? At least define separator between schema and object name and file extension.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. F3 button not working properly

    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)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. Control-N in an SQL window

    When I press control-N in an SQL window, why does the new window not inherit the server and database of the current window?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. Skin styled images not showing in menu

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. Invalid error line for "Display Estimated Execution Plan"

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. Ability to set edition for trial mode.

    During the 30 day trial, the application runs in enterprise mode. It would be ideal to have the option to change the edition that it runs as so that we can easily see what features we gain/lose with each edition. For example: My company is looking at standard edition. I have to keep going to the website to see if the feature I am currently playing with comes with that edition. It is making my evaluation much more difficult.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. How to create column of type nvarchar(max)?

    The "column properties" dialog does not list that data type.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. Bring back the single-DB Connection

    The Single DB feature was removed in V5, and I would like to see it brought back

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. Source support for the online (www.visualstudio.com) version of TFS.

    The visualstudio.com online version of TFS will not authenticate with Source Control. I have tried alternate credentials and using the tool from http://nakedalm.com/tools/vso-service-credential-viewer/.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. In Database Explorerer it should be possible to see the data type and NULL/NOT NULL settings of fields like in SSMS

    In Database Explorer it should be possible to see the data type and NULL/NOT NULL settings of fields like in SSMS.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. Autosize

    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)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  19. password change on expiry

    My dba set a security policy to reset the users sql password once a month.
    When i log in using MS-SSMS, when the change password is due, the application tells me that the password is expired already and then offers me to change my sql password immediately.
    DbForge just tells me that i cannot use my old password.
    Can you add this change password on expiry feature please?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    completed  ·  AdminDevart (_, Devart) responded

    Now, the updated view editor contains the text of the view as well as the visual representation of the query on the diagram.

  20. Invalid scripting for FK deleting using "IF OBJECT_ID('FK_...', 'F') IS NOT NULL" check.

    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)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
1 3 5 6 7
  • Don't see your idea?