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

382 results found

  1. 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  ·  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. 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  ·  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. 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  ·  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. 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  ·  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. 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  ·  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. 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  ·  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. 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  ·  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. 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  ·  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. In SSMS, there is a feature called Registered servers, which allows for creation of groups of servers eg. Development, which contains sql server instances for all development servers.
    With this option, a user can execute the same script against all the servers in the group.
    This can be useful in a scenario such as if you need to execute a query against your database in each of your retail locations.
    I would like to see this feature implemented in dbForge Studio IDE.

    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  ·  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. When we do an import for dbf file, the first file is ready to create a new table with the file name for the table's name. At the end, when the import is done, we can click on "Import more". We select a new dbf file but it tries to import in an existing table or the previous table name and a number at the end. It must always be the file name for the table name when we want to import to a new table.
    Thanks a lot!

    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  ·  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. if you write part of a column name, intellisense gives you a list to chose from, but automatically selects the first row, so you can confirm the choice by pressing TAB. That works in WHERE, ON, GROUP BY, ORDER BY statement, but not in SELECT. I am quite sure that in one old Release this worked. not sure, why it does not anymore.
    Right now in SELECT you have to write part of the column name and then use cursor down to select the first item on the list, then press tab.

    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  ·  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. In MS SSMS I can select multiple rows in a table definition and then do a Control-C to copy those definitions. I can then go to a different table (or even the same table) and paste the definitions in.

    I typically have 4 columns that are always on my tables (DateCreated, CreatedByID, UpdatedByID, and UtcTimestamp) and it's easier to just copy them from another table then to enter them in by hand every time I create a table.

    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  ·  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. I want to be able to multi select rows in the table editor so that I can delete them all at one time.

    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  ·  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. I added new fields and moved them up, it gave me a warning of "The object requires rebuilding, this may result in the loss of some properties.". Is there a way to tell what properties those are or is it just an warning that might not even exist?

    This feels like a CYA warning message. If I'm going to lose something, it would be nice for me to know what it thinks I'm going to lose.

    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  ·  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. If I have column names or table names like

    MyTabel, it should be able to split it apart at the capitalizations and tell me that Tabel is spelled incorrectly and offer suggestions on how to fix it.

    Same goes for Table Names, Stored Procedure Names, etc...

    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  ·  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. EDIT: Apparently this editor doesn't support any formatting?

    I want DISTINCT and TOP to line up with the first column not with SELECT.

    So this:
    SELECT
    DISTINCT
    TOP 100
    t.[TraineeName]

    would be

    SELECT
    DISTINCT
    TOP 100
    t.[TraineeName]

    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  ·  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. The window selection dialogs have a Name and a Path column. You can resize the dialog to your heart's content, but it will not have any effect on the width of the Name. Which, if the window is displaying a DB object, will have the schema part of the name prepended. Which, if th. e schema part of the name is long enough to be useful, will cause the interesting part of the name to be truncated.

    Provide an affordance that will allow users to resize the width of the Name column in the window selection dialog. Alternatively, provide a…

    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  ·  Bugs  ·  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. From the Database Explorer > DatabaseName > Security > Schema, be able to right-click and Create New Schema

    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  ·  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. SELECT * FROM BaseProfile A
    JOIN Base
    Profile_Trl A1 ON A.ID = A1.ID WHERE A1.id=20200215

    edit table:BaseProfileTrl,After editing one row of data, I found that the entire table got updated.

    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  ·  Bugs  ·  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. I would suggest that the possibility of having in the editor the features of "Word Wrap" and "Show visual glyphs for word wrap" as they exist in the editor of Visual Studio be added.

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