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

38 results found

  1. Take two identical databases on different SQL Server instances (or on prem vs Azure). Ensure they are identical by doing a schema compare. Take a data generation file that is configured and works for one database. Take that file and change the target to the new database. The pre-existing configuration does not get applied to the new database.

    The workaround is to create a copy of the existing data generation file, open the new configuration .dgen file in a text editor and change the ConnectionString line in the xml to match the new database's properties. In order to get the…

    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)
  2. Fix issue with diagram tool auto redrawing relationship lines when tables are dropped and recreated with no changes to relationships from old to new tables.

    Specifically I reverse engineered my tables into the database diagraming tool. Then painstakingly organized the tables then adjusted all the relationship lines so they take a short path and do not cross then saved the diagram.

    When re-opening it everything is fine. But - if I ever drop and recreate the tables (e.g. with a script to change the schema) the diagram tool auto-redraws all the relationships and the diagram becomes a mess.

    Please fix.…

    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)
  3. 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)
  4. There is an error on list object permissions on Security Manager (on specific database or all server)

    SQL Server: 2022 Enterprise Core
    dbForge Studio for SQL Server: 6.4.7

    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  ·  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)
  5. 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)
  6. When I open an existing stored procedure or view with Modify menu item, dbForge studio formatting is automatically applied. Is there a way to prevent this?

    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  ·  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. When I reformat the document it doesn't put Aliases, Table Names or Column Names in [] even though I have that option on.

    Formatting should enforce the rules I have in place. I want Table Names, Column Names, Aliases all enclosed in [].

    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  ·  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)
  8. 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)
  9. 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)
  10. 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)
  11. 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)
  12. 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…)
    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)
  13. 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  ·  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\

  14. Window headings are only sql, sql1, sql2 an not the name of the datatable.

    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)
  15. Shortcut Ctrl +Alt+o is in conflict with windows Alt+o . So you can't get the Polish letter 'ó' what is annoying when try to comment your code in Polish not only because the letter, but especially because jumping out of your current context. Suggestion: option for you own definition of the short cut.

    10 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  ·  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)
  16. If you set a breakpoint, then close the query, when you open the query back up, the previously set breakpoint is no longer present.

    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)
  17. Search does not find all stored procedures in a case sensitive database. The default case insensitive search misses some objects. To make it work, you must specify the exact case sensitive search string and make the search case sensitive. The default server collation in my instance was case insensitive.

    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)
  18. I changed the grid to update a table, but the update did not use the primary key of the selected row and updated thousands of rows! My expectation is that the PK of the selected "update" table would be used to update one row. This is a terrible bug and makes the update feature unusable when using a join.

    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)
  19. I customize the tool bar and arrange them how I want them and the reset on their own if I do anything like execute a query, move to another tab and move back, etc. They should lock in place and be the same on each query window.

    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. Opening windows takes much time.
    I believe the most often used features must work as fast as possible to provide the best experience (including not only processing but opening windows).
    See how long it takes to open "New Data Comparison" and moving through tabs "Source and Target", "Options", "Mapping".
    The app itself opens slowly as well opening "dcomp"-files.

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