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

400 results found

  1. Move the functionality of Security Manager to Database Explorer in order to access it in a more intuitive way.

    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  ·  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. SQL Query Builder, Data Editor, Data Report and Data Export available as runtime for distibution by developers.

    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)
  3. Add schema name into database diagram tables names, eg into brackets like 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…)
    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)
  4. Most of the times we will take input parameters as XML datatype but finally output we are getting in table format. If we need to get the output on XML formal then we need option to convert datatable to XML.

    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)
  5. Opening a saved or recent file (schema or data comparison) should not start comparing directly but instead open the "Edit comparison" dialog in the Mapping tab, just in case the user wishes to change the items being compared. When using slow connections between servers, this would be very helpful. If you feel may users would not like such a change, it could be made configurable in the application options (a "Don't start comparison immediately when opening a comparison file" checkbox).

    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  ·  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. Per your response "Unfortunately, Query Builder does not support CTE yet."

    You added support for CTE's to the application, but left it out of the query builder. So, the result is even though there is support now for CTE's, you still can't fully use it.

    Can you you just add the WITH statement to the query builder along with the other (SELECT, DELETE, etc....) keywords it supports?
    Seems like it would be a quick, simple, change.

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 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. 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…

    11 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)
  8. It seems good if you add ability to unpin data window from query. For example, It will be nice (if you use two monitors) to edit query on the first monitor and view data on the second.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. The way that Sublime Text 2 manages key bindings is far superior to the Visual Studio way which dbForge Studio currently implements. Specifically, I would like to be able to edit a text file that describes how keys ought to be bound.

    Personally, I prefer emacs-style key bindings, but not everyone does and my keyboard doesn't have the home/end/pgup/pgdown buttons because I use a MacBook Pro.

    dbForge Studio doesn't appear to support bindings for moving to the end or beginning of a line, so I'm stuck without an ability to remap these keys.

    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. To show a 'many' relationship on the child side, a 'crow's foot' shape is used now. SSMS uses 1 and * (asterisk sign) to show one-to-many relation. So you can add similar notation to the Diagram Document Options. (Now there are two options available: IE and IDEF1X)

    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)
  11. 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  ·  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. Hi. I'm currently evaluating studio for sql server. OK, i'm primarily interested in schema and data comparison but evaluating the whole studio product. Here's a couple of things which i think would be useful additions/modifications to the UI of the product(s) (schema and data comparison).

    1. The "recent files" section. I think it would be better if there was a "favorites" section above "recent files" and the user was able to choose whether he wishes to have the "recent files", "favorites" or both sections shown. Also, comparison projects could have an editable title so in the "favorites" section, one could see…
    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  ·  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. When designing fairly complex queries that would result in the altering of several (potentially hundreds) of rows of data it would be nice to be able to see a 'preview' of what the results of running it might be. This would help greatly in refining the query as it is being written so that it really does end up producing the desired results.

    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)
  14. 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  ·  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 selecting a Recent Files' item that is not currently accessible, dbForge for SQL Server removes that item from the list. This is a highly unusual UX experience and very annoying.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. I would like to see an option on tab context menu. Often I need to duplicate (clone) my query. So another useful option in context menu when clicking on Query Tab would be "Duplicate query" or something like that.

    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  ·  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. Abitlity to view/create/modify SSIS packages

    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)
  18. Allow for the top filter row to be used on the DexExpress grid like the used to view table data.

    6 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)
  19. Data Viewer is not working after a day of application activity

    Data Viewer stops displaying anything in a day after being started. You will need to restart the application so it starts working 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  ·  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)
  20. 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  ·  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?