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

164 results found

  1. Extend the connection categories marking feature so the objects (tables, views, procedures, etc) belonging to the connection also have the same marking as the corresponding connection.

    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  ·  Features  ·  Admin →
  2. CREATE TABLE #Table1 ( c1 int, c2 DATETIME2)
    ;

    SELECT * FROM #Table1;

    INSERT INTO #Table1 (c1,c2) VALUES (1, SYSUTCDATETIME ());

    --dbforge returns: 7/29/2015 8:58:48 AM
    --sqlstudio returns: 2015-07-29 09:00:32.5318459

    -- we are missing the nanoseconds

    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 →

    This can be setup as follows:

    1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Data Editor → Formatting’ branch.
    3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
    4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
    5. Click ‘OK’.

  3. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  4. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Bugs  ·  Admin →
  5. 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 →
  6. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Features  ·  Admin →

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

  7. 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 →
  8. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  9. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  10. 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)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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)
    You have left! (?) (thinking…)

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

  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. I was able to connect to SQL Server running on Ubuntu with SQL Server Management Studio. Be nice to do it with dbForge. Got the error message that the version of SQL Server wasn't supported when I tried.

    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  ·  Features  ·  Admin →
  17. Every time I update db Forge I end up in the situation where it asks me for my license. This is so annoying because I then end up in this loop where I have to find my license details, enter them in, get an error message because it is not happy with it, then contact you guys to get a new license. Why can't you just remember the license and not ask me for it again until it expires. I have a team of developers who ran the update this morning and are now unable to do any work until…

    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  ·  Features  ·  Admin →
  18. 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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?