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. 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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. I can set parameter for my query. But if I use profiling mode, DBForge 5.0.337 ignore the parameters.

    0 votes
    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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. I use version 4.5.60 and do the following: I edit a table (remote connect to SQL2012Express) and add two new columns (one bit, one int) with NOT NULL and Default Value. I click "Script change" and I execute only the two ADD COLUMN statements. It works, I check it with "Retrieve data". I close all tabs and go to again to "Edit table". I get the old schema (without the new two columns). I close your application and start it again: all works fine!

    0 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 →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
2 Next →
  • Don't see your idea?