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

168 results found

  1. A tool to read transaction logs similar to http://www.apexsql.com/sql_tools_log.aspx

    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 →
  2. Currently in the differences in the table columns are highlighted with some sort of blue/green, while the column names and the DDL are also in the blue/green color space.

    It is hard to easily figure out what is the difference.

    It would be really helpful to be able to change the highlight to any chosen color - for myself I would choose yellow :)

    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 →
  3. It would be nice if there is an option to visually align the text on both sides in the table comparison panel.

    This would mean to align all exact lines on both sides and when the are lines which exist only on the left or the right to put an empty line on the other side.

    It makes the visual comparison easier and similar to how the Diff/Compare function works in Visual Studio.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  4. When I filter the results grid in DBForge Studio for SQL Server, it's great to quickly get the results i need! However, there are times I'd like to see the SQL of the filter (i.e. what it is putting in the WHERE clause) so I can use it in my own SQL query. Currently I do not see a way to view or export that. This would be a nice feature to have!

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  5. when auto complete drop-down appear, we need to use space-bar to complete the word like as visual studio or 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  ·  Admin →

    This can be setup as follows https://snipboard.io/uqb2m9.jpg
    1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Text Editor → Code Completion → List Members’ branch.
    3. Select the ‘Whitespace’ option in the ‘Commit Selection’ section.
    4. Click ‘OK’.

  6. It is typical to write or extend a sql stmt on the top of a query window and to see the result in the bottom.
    dbForge has not that standard behaviour for this window. My Suggestion is to configure or save the last the window layout as it will be needed.
    I know there are two buttons in the bottom to click on to change this layout but when you work the whole day with this tool and you have click 200 times a day these both buttons it's getting bothersome and not a good user experience.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  7. Can you add the features in the Card View of the record to scroll the value with the scroll's button mouse?
    When I have many columns its long to press all the time the arrow

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  8. Support for Common Table Expressions (CTEs)

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  9. I see that you are using Developer Express Grids and controls but that you are using version 13 compared to the current version 19. Please update the grids and controls to the current version and allow users access to most of the features those grids provide.

    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 →
  10. Currently, unless you override it, the semi-colon is used as the default delimiter for all CSV export and copy functions. It would be very helpful to be able to set the comma as the default in options.

    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 →

    This can be setup in the ‘Data Export → CSV’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).

  11. Add support for SQL Server PaaS editions such as SQLDW and SQLDB

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  12. It would be great if the system would automatically refresh an object when you open it to edit. SSMS does pulls the current version, but this system just opens the cached version. This has cost me hours over the time I've used this product. One example use case:

    • Right click a stored procedure > modify
    • Make changes
    • F5 to run update script
    • Close window
    • Sometime later, repeat and you get the version that was from before you made the first changes.
    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  13. 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…)
    completed  ·  2 comments  ·  Features  ·  Admin →
  14. It would be extremely helpful if the results of a dbForge Search (within SSMS) could be exported (or at a minimum, be able to be highlighted and copied).

    Also helpful would be a way to narrow/filter the Found In results (to say just body). This would be moot point if data could be exported.

    3 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  ·  Features  ·  Admin →
  15. Migration Based Deployment System

    I’m searching for an option that the database keeps a log of the migrations (scripts) that are already performed. When I’m deploying new migrations it can simply look which migrations are already done (or set to not done) and continue from there.

    When my colleague is then updating his database he can execute all scripts which aren’t yet done on his database. This will results in his database being completely updated while saving, updating of removing the data (This is done without a compare (just script executions) which is great, because his changes aren’t removed). Then…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Features  ·  Admin →
  16. SQL query window does not accept adding the 'WINDOW xxx AS' clause to a query with a window function.

    3 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  ·  Features  ·  Admin →
  17. Currently when I use Query designer the resulting query is expressed as:

    SELECT
      Hygiene360Log.Hygiene360LogId,
      Hygiene360Log.RequestDate
    FROM dbo.Hygiene360Log
    

    Where what I want is the minimum length of text to correctly identify tables and objects, like this:

    SELECT
      Hygiene360LogId,
      RequestDate
    FROM Hygiene360Log
    

    It's very annoying

    3 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  ·  Bugs  ·  Admin →
  18. Why a new object can only be created from main nodes ("Tables", "Procedures"...). Uncomfortable when there are many items I have to scroll up to the top and only then I can create new object from popup.

    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  ·  Admin →
  19. Examples:
    IIF() function is not colored
    CONCAT function is colored blue instead of pink (which I think should be the case)
    FORMAT function is not colored

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  20. It would be very nice if dbForge could have an option to jump to/from Begin/End statements. This allows us to clearly see where a structure begins/ends (in large scripts).
    Also faint lines connecting begin/end, ( and ), like DevExpress's CodeRush or Notepad++ would be very nice.
    Currently you have faint lines around select statements and so forth. That is very useful, but the suggestion above will enhance the usefulness of the current structural highlighting.

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →
  • Don't see your idea?