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

156 results found

  1. Add Git source control option (SVN and TFS are already supported). I find that the concept of Git and how it works fits really well with our database development flow.

    89 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  2. Allow us to adjust the font size in the database explorer pane.

    86 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Features  ·  Admin →

    This can be changed as follows:
    1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Environment → Font and Colors’
    3. In the ‘Show settings for’ drop-down menu, select
    ‘Database Explorer’.
    4. Specify the needed font and size.

  3. In MSSQL Management Studio you have ability to view xml document returned from query or sp, as pretty formatted SQL document. It opens in separate window (fullscreen).
    It is a must have feature in dbForge Studio for SQL Server

    60 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
  4. Especially systems that provide a command line tool to perform tasks like CheckIn/CheckOut/AddFile ...
    E.g. Seapine Surround or others

    55 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  5. For example, on our server, we currently have over 400 event databases. We would need to copy and paste the line to call the execute function 400 times and change the database name on each line.

    It would a great feature if SQL Studio could give us a list of all databases on the server we connect to (with a check box next to each one), with an option to "select all". It would then automatically execute the query against all checked databases.

    This would save us a lot of time, and would mean your product has all the functionality…

    54 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. I like to right click a table name and dbforge should produce a stored procedure for insert/update out of it, like

    CREATE PROCEDURE tblTest1_IU
        @id Int,
        @[user] Int,
        @stamp DateTime2(6) AS
    BEGIN
      IF EXISTS ( SELECT * FROM dbo.tblTest1 WHERE id = @id)
      UPDATE dbo.tblTest1 SET
        [user] = @[user],
        stamp = @stamp
      WHERE
        id = @id
      ELSE
      INSERT INTO dbo.tblTest1 (
        id,
        [user],
        stamp)
      VALUES (
        @id,
        @[user],
        @stamp)
    END
    
    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  7. In dbForge Schema Compare for SQL Server you can see actual code difference in UI in Text Compare section. But when it produces a report there is no option to include Text Compare details. Report only has object level details.

    It would be useful to to have option of including actual Text Compare for automated notifications about schema changes.

    39 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Features  ·  Admin →
  8. It would be perfect to add database documentation feature.
    Generate documentation as CHM or/and as documentation project which could be used by third party tools like Help&Manual.

    38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Features  ·  Admin →
  9. 36 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  10. Add an ability to export database schema and (optionally) data to an SQL script.

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  11. It'd be great if dbForge Studio could periodically save a copy of the query file in some temp folder and also provide an interface to search all that history (and not just the current window).

    32 votes
    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  ·  Admin →
  12. The Find and Replace defaults to a scope of "All Open Documents", which is quite irritating and potentially dangerous when Replacing. This causes a jump to a different open document and is an unnecessary distraction. A safer and more reasonable default would be "Current Document", as most of the time I am interested in finding something in the current document. Very rarely am I interested in finding text in all other open documents (Object Finder is a better tool for that kind of thing) and would only want to Replace in All Open Documents in very controlled circumstances.

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Features  ·  Admin →
  13. In dbForge - as with SSMS - when you run a query, the results appear in a pane at the bottom. SSMS lets you easily toggle the visiblity of that pane with the Ctrl+R keyboard shortcut.

    You can do the same thing with dbForge but there's no keyboard shortcut for it. Instead you have to click on the little double down arrow button at bottom right.

    Please add a keyboard shortcut so it's easy to quickly toggle the visiblilty of the results pane.

    Thanks!

    28 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  14. Redgate does a data generator that is quite useful. It looks at the schema for the tables and generates randomized (according to rules that you can select) data to fill them. It is quite useful when you need to say generate 100,000 rows for testing.

    28 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  15. Ability to associate a color to a connection, so that queries/tools open for that connection can have background or border of that color to remind you which connection you are working with. We have local dev/shared dev/qa/staging/production environments, and I would like to be able to visually differentiate which connection is being used.

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  16. 25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  17. Implement the ability to backup and restore databases just like in dbForge Studio for Oracle and dbForge Studio for MySQL.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
  18. one glaring omission seems to be that you cannot create new databases using this tool - so I have to still revert to Management Studio to create the database, then switch to Devart for everything else.

    Is it possible you could add this functionality?

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
  19. Quick jump to corresponding BEGIN <-> END

    In bigger procedures with a lot of nasted BEGIN-ENDs it would be very useful to have a shortcut key or right mouse button option to jump to BEGIN/END corresponding to the one on which you currently have cursor.

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  20. Especially: renaming table aliases. Other suggestons:
    adding aliases, adding or removing AS keywords, replacing aliases with table names or vice versa, removing 'redundant' aliases or table names.

    18 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
← Previous 1 3 4 5 6 7 8
  • Don't see your idea?