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

268 results found

  1. Add an option to display output for multiple queries stacked instead of as individual tabs (see how this works in SSMS)

    3 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  ·  Features  ·  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. Would be great to be able to tag certain objects and associate to a folder. For example, if i was working on a project that touched 8 table, 10 stored procedure and 5 views, I would tag each of those objects and associate to a folder/project.. This is essentially a custom filter that would group all the objects I'm working on for a particular project. Makes it easy to manage

    3 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  ·  Features  ·  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. When selecting objects to script, there are global checkboxes for Schema and Data. I'd like to see two columns in the tree-list of objects, where I can individually mark a table for just schema or just data, or both (default)

    2 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  ·  Features  ·  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. When I execute a Query, if the Results are hidden, I would like them automatically shown.

    7 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  ·  Features  ·  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. EDIT: Apparently this editor doesn't support any formatting?

    I want DISTINCT and TOP to line up with the first column not with SELECT.

    So this:
    SELECT
    DISTINCT
    TOP 100
    t.[TraineeName]

    would be

    SELECT
    DISTINCT
    TOP 100
    t.[TraineeName]

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. If I have column names or table names like

    MyTabel, it should be able to split it apart at the capitalizations and tell me that Tabel is spelled incorrectly and offer suggestions on how to fix it.

    Same goes for Table Names, Stored Procedure Names, etc...

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. I added new fields and moved them up, it gave me a warning of "The object requires rebuilding, this may result in the loss of some properties.". Is there a way to tell what properties those are or is it just an warning that might not even exist?

    This feels like a CYA warning message. If I'm going to lose something, it would be nice for me to know what it thinks I'm going to lose.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. In MS SSMS I can select rows and drag them in the grid to change their position. I would like to do the same with dbForge.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. I want to be able to multi select rows in the table editor so that I can delete them all at one time.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. In MS SSMS I can select multiple rows in a table definition and then do a Control-C to copy those definitions. I can then go to a different table (or even the same table) and paste the definitions in.

    I typically have 4 columns that are always on my tables (DateCreated, CreatedByID, UpdatedByID, and UtcTimestamp) and it's easier to just copy them from another table then to enter them in by hand every time I create a 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…)
    0 comments  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. It appears that I can't export the font and colors settings in Options -> Environment -> Fonts and Colors. This would be a great feature addition that would allow me to export my personal theme design and apply it again whenever I do an upgrade or install the software again.

    3 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  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. In SSMS, there is a feature called Registered servers, which allows for creation of groups of servers eg. Development, which contains sql server instances for all development servers.
    With this option, a user can execute the same script against all the servers in the group.
    This can be useful in a scenario such as if you need to execute a query against your database in each of your retail locations.
    I would like to see this feature implemented in dbForge Studio IDE.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. llow to group/organize Functions or Stored Procedures within folders created by the user. This way, it is possible to group by functionality.
    Over time these kind of objects pile up and become increasely difficult to manage.

    4 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  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Hi, we use a lot of json caluses in our db procedures e.g.:
    select
    *
    into
    #parcel_data
    from
    openjson(@parcelData, '$')
    with
    (
    "ParcelId" int '$.ParcelId',
    "ParcelTypeId" int '$.ParcelTypeId',
    "ShipmentId" int '$.ShipmentId',
    "BarCode" nvarchar(100) '$.BarCode'
    );
    Why don't You prepare such a helper in dbForge Studio ? It could be located on the level of "Generate script as" menu for each table for instance. To have the possibility to prepare our own plugins would be also a good idea.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Database Explorer doesn't include System Procedure folder which would be great to have.
    Thanks.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. The "Add related tables"-function (same as in SSMS) is very useful when creating a database diagram from an old database.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. would it be possible to add a RegEx search in the script to automatically rename the tabs

    "^(\s)(CREATE|ALTER|CREATE\sOR\sALTER)(\s\w\s)((([|)..(]|))|)(([|).(]|))\s*$"

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Show somewhere (the status line at least or perhaps in a new status window) the percentage of commands of a script that has been executed.

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Please add a space automatically after accepting an intellisense suggestion.

    For example after a table name, when typing "w", "WHERE" appears, when hitting tab it adds that word to the text area, yet I need to then manually add a space. Why not add it as part of the intellisense (as we're used with VS) so I can simply keep on typing seamlessly?

    3 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  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. Typing "order" after a table name brings up the intellisense with "ORDER BY", yet when hitting tab to accept, only "ORDER" gets entered in the text area, the only way to get both words is by hitting Enter. Why not on tab like I'm used to?

    3 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  ·  Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

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