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. How I can I monitor last 100 queries for a particular DB

    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  ·  Questions  ·  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. How do I save the DB connection ...similar to how I can register servers in SSMS. Thanks

    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  ·  Questions  ·  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. If a DML query contains an error, the file is not saved. It is absurd to have to go into Notepad to save a file.

    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  ·  Bugs  ·  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. Hi, we use a lot of json caluses in our db procedures e.g.:
    select
    *
    into
    #parcel_data
    from
    openjson(@parcelData, '$')
    with
    (
    "ParcelId" int '$.ParcelId',
    "ParcelTypeId" int '$.ParcelTypeId',
    "ShipmentId" int '$.ShipmentId',
    "BarCode" nvarchar(100) '$.BarCode'
    );
    Why don't You prepare such a helper in dbForge Studio ? It could be located on the level of "Generate script as" menu for each table for instance. To have the possibility to prepare our own plugins would be also a good idea.

    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  ·  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. Database Explorer doesn't include System Procedure folder which would be great to have.
    Thanks.

    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  ·  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. Capacity to copy a code snippets to create a new one.

    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  ·  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. When a value is changed in the Data Editor, the Data Editor logic compares the value with the existing value and makes a decision whether to update the existing value based on whether the new value is considered different. Currently, this equality comparison is case insensitive, which is a bug. It must be case sensitive. SSMS will update data based upon consideration for case sensitivity, but not the Data Editor.

    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  ·  Bugs  ·  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. llow to group/organize Functions or Stored Procedures within folders created by the user. This way, it is possible to group by functionality.
    Over time these kind of objects pile up and become increasely difficult to manage.

    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  ·  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. The "Add related tables"-function (same as in SSMS) is very useful when creating a database diagram from an old database.

    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  ·  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. would it be possible to add a RegEx search in the script to automatically rename the tabs

    "^(\s)(CREATE|ALTER|CREATE\sOR\sALTER)(\s\w\s)((([|)..(]|))|)(([|).(]|))\s*$"

    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  ·  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. Show somewhere (the status line at least or perhaps in a new status window) the percentage of commands of a script that has been executed.

    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  ·  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 a space automatically after accepting an intellisense suggestion.

    For example after a table name, when typing "w", "WHERE" appears, when hitting tab it adds that word to the text area, yet I need to then manually add a space. Why not add it as part of the intellisense (as we're used with VS) so I can simply keep on typing seamlessly?

    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  ·  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. 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…)
    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. Since V.6.0.563 in the diagram fonctionnality, the Container's title and the stamp's text color are white, resulting in very hard to read titles for the containers and impossible text to read in stamps.

    21 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  ·  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 we go to a new customer site for an install, we typically get connected to the network, open schema/data compare for a deployment and then add a new connection. The problem is when we go back to that site (or remote connect in), it can be tricky to find the connection for the customer.

    Can we have something in the connection manager to arrange the connections in alphabetical order so they are easier to find?

    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  ·  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. 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…)
    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)
  17. Add the ability to ignore Users in Schema Comparison.

    1 vote
    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)
  18. There are times that you may wish to perform two similar structure or data comparisons. It would be useful if when right-clicking on the tab of a data comparison window, in the context menu that appears, there was a "clone" option. This would generate a clone of the existing structure/data comparison window containing the exact same options of the original window. Then you would be able to just alter the few options you wish and perform the new comparison in the new window, without destroying the comparison that exists in the original window.

    2 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. Like in Management Studio, I would like to be able to see the Execution Plan of my query.

    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  ·  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 using the "Truncate Table" feature on a table which has an active table lock, dbForge completely freezes up and ultimately crashes. The app should "gracefully wait" rather than crash.

    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  ·  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 specify what product version you are using?

    Please also provide us a screenshot of any possible error and perform the following:
    1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Environment → Output’ branch.
    3. Select the ‘Write queries sent by the program to the SQL Log’ and ‘Log application errors’ options.
    4. Unselect the ‘Delete application log after closing’ option. Click ‘OK’.
    5. Reproduce the issue and send us the *.log file with the latest date from the folder:
    SystemDrive\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\

← Previous 1 3 4 5 17 18
  • Don't see your idea?