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

  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. In SQL Complete the F12 (Go to definition) expands the item in database explorer. In dbForge Studio this opens table in new window.

    I would like similar option in text editor context menu, for example Locate in Database Explorer, which will expand to the wanted node, whether it is table, column, procedure, view etc.

    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. 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)
  4. 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)
  5. 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)
  6. 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)
  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…

    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. 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)
  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 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

  12. 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)
  13. 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)
  14. 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)
  15. 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)
  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. 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)
  18. It would be nice to be able to group connections to folders in Data Explorer.
    Ablility to create folder structures in Data Explorer and move connections to different folder.

    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. 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  ·  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. You can change the filter and modify sort order. Would be nice if there was an option to flush these settings into a below query. For example, you have "SELECT * FROM table1", execute that, pick to sort by column1, column2, and also where column3 = "AAA", then you use that option - and get "SELECT * FROM table1 WHERE column3 = "AAA" ORDER BY column1, column2".

    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  ·  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?