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.

168 results found

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

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

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

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

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

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

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

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

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

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

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

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

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

  14. Script generating with table rename and reinsert data

    Here is some table need to recreate and refill data after if. Recreation reason- identity increment has been changed.

    This script was generated:

    IF OBJECTID(N'dbo.EDDevicesSHADOW', 'U') IS NOT NULL
    AND OBJECT    ID(N'dbo.tmpdevartEDDevicesSHADOW', 'U') IS NULL
    EXEC sprename N'dbo.EDDevicesSHADOW', N'tmpdevartEDDevices_SHADOW', 'OBJECT'
    GO

    IF NOT EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    AND EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PK    EDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    EXEC…

    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  ·  1 comment  ·  Features  ·  Admin →

  15. Ao tentar executar consulta na primeira vez

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

  16. Hi. I suggest to add the feature for select only a database, on Connection Properties.

    Include the option for to open only the connection with database specified.

    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 →

  17. Showing the connection color in the status bar

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

  18. Open new tabs next to current one

    Opening up a new tab all the way at the end is so Internet Explorer (not in a good way). 99.999% of the time if I'm opening up a new tab it's intended to supplement my work in the tab I'm in, so visually it is most useful if it just starts up next to the current tab.

    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 →

  19. Refresh option in Data Import wizard

    When I use the import wizard it would be handy to have a refresh option. If I'm partway through the wizard and decide I'd like to create a table manually, I can't then specify that table to import to without closing the wizard, force a refresh and start all over again

    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 →

  20. DataCompare: Add option to turn ON\OFF Generation of "IF NOT EXISTS" on inserting

    I have to script data so it won't produce an error when running the sql statement.. 80% of the time I have to manually update the data synch scripts like this:
    IF NOT EXISTS (SELECT * FROM dbo.DescriptionReference WHERE DescriptionId = '0243b2d2-58b2-4aaf-8cfd-0011f036f0e3')
    INSERT dbo.DescriptionReference(DescriptionId, CultureCode, IsDefault, Description, LongDescription, SourceTable, IsActive, Created, CreatedBy, Updated, UpdatedBy)
    VALUES ('0243b2d2-58b2-4aaf-8cfd-0011f036f0e3', N'en-US', 1, N'2300 REF F8 - P', NULL, N'FormatRuleValue', 0, '2015-06-01', 'TESTA', '2015-06-01', 'TEST')
    If I don't and the data exists it throws an error and stops our DB Upgrade process..
    IT WOULD BE GREAT if you could have an option to turn on…

    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  ·  0 comments  ·  Features  ·  Admin →
1 2 3 5 7 8 9
  • Don't see your idea?