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

156 results found

  1. When I open an existing stored procedure with Modify menu item, dbForge studio formatting is automatically applied. Is there a way to prevent this?

    6 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  ·  Questions  ·  Admin →
  2. The Find and Replace dialog has two annoyances :
    1. "Look in:" should indicate "Selection" whenever the dialog is open and there is text selected in the query window. Particularly important for replace actions !
    2. When switching to either the "Find what:" or "Replace with:" edit field, the content should be selected instead of placing the cursor at the end. This way, what the user types reaplces the content of the edit box.

    Thanks for voting :)

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  3. 5 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  ·  Admin →
  4. Implement at least two color schemes dark and bright so when changing to the dark scheme, a user is to be able to quickly change the text color as well.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  5. more than 65000 recordes can be experted in csv format files, but they cannot cope with ' or " is text fields.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. When OPENJSON along with WITH to list fields to pull from the JSON data the fields are not visible for code completion purposes. For example in the query below there is no code completion for B.* in the select list and the fields need to be entered manually.

    SELECT PD.ProductDimId AS ProductDim
    , [Date] = CAST(JSONVALUE(J.JSONData,'$.fields.trandate') AS DATE)
    , TONumber = JSON
    VALUE(J.JSONData,'$.fields.tranid')
    , TransactionInternalId = J.InternalId
    , [Status] = JSONVALUE(J.JSONData,'$.fields.status')
    , Line = B.line
    , B.Quantity
    , TOCurrentValueUSD = B.CurrentUSDValue
    , TOLandedCostPerItem = b.LandedCostPerUnit
    , FromLocation = CASE JSON
    VALUE(J.JSONData,'$.fields.location') WHEN 16 THEN 'In Transit/On Water' ELSE…

    4 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 →
  7. View object by schema. This would make the explorer more clear and easier to find objects if you've lots of tables and views split by schema

    4 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. Add icons which will make it easier to distinct columns which are primary/foreign keys in database explorer.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  9. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  10. Currently on the command line, the /sync option allows you to specify a file to write the sync script to, instead of executing immediately. When no file is specified, the sync is executed immediately. I would like a way to send the results of the sync operation to a log file of type .txt.

    I think it would be beneficial to have a couple of different logging levels:

    0 - verbose; each object start and stop time, warnings, and errors
    1 - warnings; only objects causing warnings or errors to occur
    2 - only errors

    Warnings should include the object…

    4 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 →
  11. Generate a matrix showing tables vs. procs/functions that Create, Read, Update or Delete data in that table.

    Perhaps this could be achieved by expanding the detail available in the "Used By" section of each table.

    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 →

    In version 6.0, the new command ‘Generate Script As → CRUD’ is available in the popup menu of a table in Database Explorer.

    This feature can be setup in the ‘Generate Scripts → CRUD’ section of the ‘Options window’ (select ‘Tools → Options…’ from the popup menu).

  12. Probably 2-3 times a day DB Forge crashed. Quite often it does this while i'm not even using it. All I get is the windows 'dbForge Studio for SQL Server has stopped working' dialog (the one which has the Debug and Close Program buttons). This has started happening after the last update

    4 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  ·  Bugs  ·  Admin →
  13. The Generate Scripts function under Tasks is missing the option to include database triggers in the list of available objects to include in the output. Triggers are a fundamental component for replicating database schemas and should be included in the scripted output.

    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 →
  14. An interface for tSQLt tests. Schemas, procedures, add test, add test class (schema) and so on. Something like Red Gates Sql Test but as a VS add-in and with the ability to view a single database. Also. the ability to the various displayed objects would be very useful. Filters could be fairly simple, class name contains, test procedure contains, begins with, ... Would be nice if the filters could be saved between sessions but certainly not a requirement.

    4 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  ·  Admin →
  15. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  16. Often, when editing functions, and I try to save something with invalid syntax, I will get a pop-up with "Object has invalid source text and cannot be saved" instead of the useful list of errors with line numbers. (However, the product still often red-underlines a problematic portion in these cases.)

    That annoyance is separately reported here:

    https://devart.uservoice.com/forums/177009-dbforge-studio-for-sql-server/suggestions/7488676--object-has-invalid-source-text-improve-error-i

    However, sometimes, after getting this once, every successive save will fail with that error, even after the problem has been resolved. Copying and pasting into SSMS will verify that it is correct. Then closing and re-opening the function editor window will allow me…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Admin →
  17. Frequently I have the need to comment or un-comment a section of my SQL code, e.g. a set of columns or a portion of a WHERE clause. It would be nice if I could select the block, right-mouse, and select comment/un-comment to place the "--" characters in front of the selected lines of code.

    4 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 →
  18. 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 →
  19. Please add the ability to zoom in/out in the query window to change the text size

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  20. In the Schema comparison options, to have another option available to ignore the column order for the included columns in a nonclustered index, as this column order is not relevant.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  • Don't see your idea?