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

168 results found

  1. Suggestion to redesign the visual stored procedure editor of dbForge.

    Uh... there are a number of major misses here in 4.0.

    I login to a database, expand the Programmability section, then right-click a procedure and select 'Edit Procedure.' The script that is generated is a CREATE PROCEDURE method, which out of the box won't work because the procedure already exists.

    Okay, so I change it to ALTER PROCEDURE and press F5 to rebuild the procedure. I get a dialog box prompting me for parameters! Oh, I guess F5 means RUN the procedure? No, that's not what I want. It looks…

    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  ·  3 comments  ·  Features  ·  Admin →
  2. If import data failed (eg duplicity in key, cannot save importlog to C:\ etc), then BACK button is disabled. Therefore after fixing the problem, we have to start import wizard from scratch
    It would be perfect simply click BACK button and try 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…)

    If data import failed, you can leave the wizard open, fix the problem and click ‘Import More’ on the last page of the wizard. All import settings will be restored.

  3. 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  ·  Features  ·  Admin →
  4. When selecting a data source, it would be nice to see the quantity of the records in the table.

    Also, when performing export, add the ability to skip the current table.

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

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

  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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’.

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