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

370 results found

  1. In my development, I use :variable for paramters. I come from the Oracle world. This @ thing causes me 2 issues. First, it stops my query from working with copy/paste once I debug it. Second, when I copy a query from the web, or my app, and try to paste it in, I have to edit it.

    It would be nice if EITHER:
    1) The : worked as a bind variable (even if I had to turn on a flag)
    2) The : REPLACED The @ if that makes it easier for you to do...

    9 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  ·  Flag idea as inappropriate…  ·  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. Filter Objects in databse explorer and then select contecxt menu item to generate the CREATE script.
    This would be much faster and easier to handle than the newly integrated Generate Script Wizard.

    9 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  ·  Flag idea as inappropriate…  ·  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. Many large numbers are hard to read, and only Date / DateTime formats can be specified. I'd like to add thousand separators (either komma or dot) at least

    9 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  ·  Flag idea as inappropriate…  ·  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 right-clicking a view or table, please have SQL Studio do a background "refresh" of the view or table before opening the edit window so the user can be assured of getting the current code or view. If I don't remember to hit F5 or 'refresh' I get old, cached data which can be very confusing and frustrating.

    9 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  ·  Flag idea as inappropriate…  ·  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. Can you please add functionality for if not exists condition while generating sync script for tables and procedures.
    for example : if db compare tools detects that a column needs to be added into other database in such a way that it will first check if that column does not exists in target table then only create that column.
    and if exist procedure then drop and create procedure.

    8 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  ·  Flag idea as inappropriate…  ·  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. Make an option for the editor to show vertical lines for each tab stop. On long scripts, I sometimes find myself putting a piece of paper up to the screen, which is of course silly.

    It would be even better if the lines were distinguishable some way-- perhaps with a tiny number, or if you hovered over them, it could show a tooltip of the first few lines before the start of that indent.

    8 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  ·  Flag idea as inappropriate…  ·  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. hi guys

    a simple UNION like

    SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber
    UNION
    SELECT TOP 10 contact
    number FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber

    will create an error "1 Not unique table/alias: 'c' Query.sql".

    It would be nice to see the querybuilder processing these kind of sql's.

    kind regards
    peter

    8 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  ·  Flag idea as inappropriate…  ·  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'd like to be able to export the database diagrams to a pdf, or something more scalable when publishing my diagrams to my teams documentation library.

    8 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  ·  Flag idea as inappropriate…  ·  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. Add option to hide schema as part of the table name in database diagrams. Since the new version 5.4 table name in database diagram show "SchemaName.TableName". Sometimes long table name get cropped so we have to extend the table's box to see the table name. Diagram need to be larger now... not good...
    I'll go back to an older version for the time being.

    8 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  ·  Flag idea as inappropriate…  ·  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. Please enable Autofilterrow in gridviews!
    (Feature from DevExpress)

    Regards


    8 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  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's possible to have a fine grained control on several to render several element on diagram. For example now I see field with not null attribute with a font normal and field with Null attribute in Italic and not in black color but in gray.
    Can we have full control on way this element be rendered?
    Some times can help can change background of table box or header color to group related table that can appear anywhere on page without use the actual "container" feature.

    8 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  ·  Flag idea as inappropriate…  ·  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. Please add multiline tabs. I often have many tabs and it's much easier to navigate between them visually (i know where is each of them) then with dropdown or arrows.

    Also, please add more descriptive names in document tab names, something like SQL1.SERVERNAME.DATABASE, or options with parameters so that everyone can name tabs based on connection. Now everything is SQL1, SQL2, SQL3 regardles on which database I'm connected to (and I'm usually connected to more that one database). Coloring helps me to distinguish between development and production database, but it's not easy do distinguish between two or more production databases…

    8 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  ·  Flag idea as inappropriate…  ·  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. While designing a query user should have possibility to save Query as Object - Microsoft Access approach.
    Then user comes back to this query and re-use: execute or modify.
    This would be advantage for those projects where user operates with similar entities.
    Use Scenario: I create a query "Active Users", save this query.
    Then I write another query which uses entity "Active Users". In my new query designed I drag and drop existing query as Table and e.g. join real table with "Active Users" entity.

    7 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  ·  Flag idea as inappropriate…  ·  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. On a multiple execution query, allow to customize the name of the results tabs, by default only shows the table name, useless if the tables are the same.

    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  ·  Flag idea as inappropriate…  ·  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. When analyzing data I often filter the result grid from a query to see how many records there based on certain conditions. The problem is that it doesn't show the number of records after the filter has happened. I then usually export to Excel and then count it that way which is not that productive.

    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  ·  Flag idea as inappropriate…  ·  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. Allow the grouping and saving of scripts into a project or solution. This would allow the grouping of related scripts into a single file set that can then be opened more easily. This would also allow a developer to more easily keep scripts related to a specific job synchronized and loaded.

    For example, loading the Paycheck project will load all of the scripts related to the Paychecks task. Then, by loading the Employee project will switch out the scripts with the ones for the Employee task.

    7 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  ·  Flag idea as inappropriate…  ·  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. It would be nice to have a "column mode selection" or "vertical selection", just like the one existing on "Sublime"

    7 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  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Could you please describe this in more detail and specify what functionality of dbForge it relates to? Screenshots would be also of help.

    You can reply straight to our support system at supportATdevartDOTcom

  18. It would be nice to have an ability to group our connections in Database Explorer by it's document category.

    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  ·  Flag idea as inappropriate…  ·  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. When building an UPDATE query in Query Builder, make it possible to specify the FROM and JOIN clauses in order to define source tables.

    7 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  ·  Flag idea as inappropriate…  ·  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. When comparing and synchronizing views while using a different schema-mapping:
    *) equal views are marked as different cause of the different schema in the view name and the different schema within the select -> please adapt the compare-logic to accept the correct displayed sqls as equal
    *) the generated sql for updating views doesn't work because they contain the right schema (target) in the view name, but the wrong schema (source) within the select -> please replace objects with the source schema within the select of the view with the target schema

    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  ·  Flag idea as inappropriate…  ·  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?