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

254 results found

  1. Do you plan adding user extensions for the IDE (plagins) or some other mechanism to extend the functionality with external utilities?

    For example:

    1. Using the external xml (you could include the editor), add an ability to add menu items (main, popup menu for a database, object, in the editor) where an external program with parameters will run (on a modal window) upon a click: current connection string (with a password, asking the user's permission), current database, current object type, current object name, etc.

    A return code will tell what to do ( -1 - error, 0 -nothing to do, 1-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…)
    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. In SQL it is possible, when adding a column with a default value to a table with existing data, to set the value of the column in the existing rows to the default value:

    ALTER TABLE {TABLENAME}
    ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
    CONSTRAINT {CONSTRAINTNAME} DEFAULT {DEFAULTVALUE}
    [WITH VALUES]

    I would like to select this option when adding a column to the table in the designer, and also be able to include the option when scripting the changes to the table - when a schema comparison is done, have the WITH VALUES option included in the script.

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

    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)
  4. Add an option allowing to check if a record already exists when adding identical record.

    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)
  5. "smart rename" to rename an object in database automatically and its reference and dependency.
    Just like competitive product "red-gate sql prompt" did.

    By the way , Devart DBforge Studio for SQL Server is very good and powerful IDE for me. I've bought a licsence.

    Thank you and best wishes.
    Happy New Year. ^_^

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  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)
  6. In the search window has the ability to copy into clipboard current line. Is it possible to modify to copy all the rows or selected rows ?

    4 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)
  7. Ability To Hide Relationships On A Diagram

    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)
  8. At present, if I developed a SQL query, stored it and try to load it back into dbForge at a later date, dbForge 'remembers' the SQL connection it is associated with and tries to connect automatically. I want to be able to disable this behaviour via options - eg opening file does NOT try to be clever.

    EXTENDED RATIONALE

    In common usage, the feature is quite useful. Unfortunately, in some of the projects I am working with, I have to constantly switch between different environments (prod, pre-prod, demo, devops, etc) protected by external VPN. All environments are hosting the same…

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  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)
  9. Add ability to also search in SQL Server Agent Jobs for references to stored procedures, tables etc. to dbForge Search.

    Redgate SQL Search has this functionality.

    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)
  10. Please move the Clear button for Query History from the main UI screen to be in the Options menu. In context, it seems like it is going to clear the search filters rather than wiping out the entire query history. It does warn you - but the history is so useful and important. Clearing it out should be a harder, more explicit step than just clicking twice. Not that I've done that... Multiple times...

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  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)
  11. I like to create visualizations of Data Warehouses using dbforge. In a Data Warehouse, foreign keys are typically not created physically.
    If I could create data base diagrams in dbforge, importing existing tables and creating virtual foreign keys it would be the perfect tool for DWH documentation.

    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)
  12. When you filter the objects in the Explorer->Tables view
    It only logical that the auto completion in the Sql script would be filtered too.

    Maybe an option inside Options -> Code Completion -> "Use filtering on objects" would allow the user to select the desired flavor.

    If you have that option selected, when you do a filter in object explorer, when you are writing a sql sentence autocompleting tables, it only shows tables with that particular filter.

    Thank you.

    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)
  13. It is fairly common in other tools/database (like Access for instance) for exported money or currency type fields to represent negative numbers by putting brackets around the value. Currently when such values are imported they give a truncation warning and put the value in as positive.

    (10.00) should go in as -10.00 instead of giving a warning and going in as 10.00.

    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)
  14. 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  ·  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. The Pivot Table is great, however it would be nice if it provided the SQL code, such that it can be used elsewhere. This would make for a great pivot builder.

    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)
    1. The routed line that maps relationship of the table to the parent with a foreign key align the line drawn between them to the columns mapped, so that easy to visualize the exact FK column matching visually.

    2. That an additional display option allowed. Instead of just CONSTRAINTS alone, offer a Foreign Key option. This pane at the bottom wouldn't be the name of the foreign key, but instead the myid - references Accounts(Id) This would make the documentation easier to use.

    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)
  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…)
    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)
  17. Show column totals (sum) or average at the bottom of the column. This would be great with a right click of the column header then click then click Group Footer then click Sum or Average

    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)
  18. LinqPad has one useful feature that could be used here in dbForge Studio too. It has a panel which shows folder structure of one specific scripts folder (configurable location). In this folder users can organize scripts into subfolders (projects). And by double-clicking on script in this panel you open the script. This folder can also be synced (via dropbox or other cloud drives) so you have same structure and scripts on multiple machines. This is a similar feature request as project workspaces. Could be easy to develop and would really help us who work on lots of projects and databases…

    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)
  19. When entering parameter values on a stored procedure of the type of datetime or smalldatetime the datetime picker defaults to the current time, but might better default to midnight or allow the user to quickly change the time to midnight (such as a button click) as it is too laborious to change all of the times to midnight, which I'd guess may be the most common usage for stored procedure/function datetime/smalldatetime entries (dates without the time).

    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)
  • Don't see your idea?