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

168 results found

  1. 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 →
  2. When connecting to Azure database server with checked flag "Show all databases" - in the list present only "master" database under "System Databases" directory and database that was selected in "Edit connection" window. In case there was not selected any database(Filed "Database:" was empty) - program connection to some not specified nowhere default database and show "Tables", "Views", "Synonyms", "Programmability" and "Security" items under established connection name at "Database Explorer"

    15 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 →
  3. Currently I always have to switch to SSMS to modify a table that is referenced by foreign key constraints, because I get errors that the table can't be rebuild.
    Would be fine to get the same (or better) possibilities as in SSMS.

    31 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Features  ·  Admin →
  4. The software is great at restoring query tabs from the last session. It would be good to be able to save the current session's query tabs (and sql content) as a workspace. This would simplify working on multiple projects.

    12 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 →
  5. Please add support for new FOR JSON

    8 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  ·  Features  ·  Admin →
  6. Provide the ability to view the SQL Server Logs

    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  ·  Admin →
  7. I'd like to be able to export the database diagrams to a pdf, or something more scalable when publishing my diagrams to my teams documentation library.

    8 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  ·  Features  ·  Admin →
  8. Allow us to adjust the font size in the database explorer pane.

    86 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Features  ·  Admin →

    This can be changed as follows:
    1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Environment → Font and Colors’
    3. In the ‘Show settings for’ drop-down menu, select
    ‘Database Explorer’.
    4. Specify the needed font and size.

  9. When comparing and synchronizing views while using a different schema-mapping:
    *) equal views are marked as different cause of the different schema in the view name and the different schema within the select -> please adapt the compare-logic to accept the correct displayed sqls as equal
    *) the generated sql for updating views doesn't work because they contain the right schema (target) in the view name, but the wrong schema (source) within the select -> please replace objects with the source schema within the select of the view with the target schema

    7 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 →
  10. Quick jump to corresponding BEGIN <-> END

    In bigger procedures with a lot of nasted BEGIN-ENDs it would be very useful to have a shortcut key or right mouse button option to jump to BEGIN/END corresponding to the one on which you currently have cursor.

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  11. For example, on our server, we currently have over 400 event databases. We would need to copy and paste the line to call the execute function 400 times and change the database name on each line.

    It would a great feature if SQL Studio could give us a list of all databases on the server we connect to (with a check box next to each one), with an option to "select all". It would then automatically execute the query against all checked databases.

    This would save us a lot of time, and would mean your product has all the functionality…

    54 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  12. Code compare built in dbForge schema comparison is nice, but I miss bottom "Diff pane" like WinMerge has. This is very useful for long line code comparison.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
  13. In MSSQL Management Studio you have ability to view xml document returned from query or sp, as pretty formatted SQL document. It opens in separate window (fullscreen).
    It is a must have feature in dbForge Studio for SQL Server

    60 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
  14. when auto complete drop-down appear, we need to use space-bar to complete the word like as visual studio or ssms.

    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  ·  Admin →

    This can be setup as follows https://snipboard.io/uqb2m9.jpg
    1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
    2. Navigate to the ‘Text Editor → Code Completion → List Members’ branch.
    3. Select the ‘Whitespace’ option in the ‘Commit Selection’ section.
    4. Click ‘OK’.

  15. You can change the filter and modify sort order. Would be nice if there was an option to flush these settings into a below query. For example, you have "SELECT * FROM table1", execute that, pick to sort by column1, column2, and also where column3 = "AAA", then you use that option - and get "SELECT * FROM table1 WHERE column3 = "AAA" ORDER BY column1, column2".

    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  ·  Admin →
  16. Manual refresh appears to be broken in this version. This even includes doing an edit on a table and the script generated does not mirror the underlying table. Have repeatedly seen this.

    1 vote
    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  ·  Bugs  ·  Admin →
  17. When you sync the schema of a database that has a full text index in it and stored procedures that reference that index, you cannot sync the schema to an empty database in one step. You must do the tables and the index first, then the functions and procedures.

    1 vote
    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  ·  Bugs  ·  Admin →
  18. You should be able to (when virtual space is enabled) hold ALT+Shift and using the up/down arrow keys, select in a vertical line. Allowing you to modify / add or remove characters on multiple lines simultaneously. Similar to how this works in notepad ++ / SSMS 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…)
    2 comments  ·  Features  ·  Admin →
  19. It would be nice if there is an option to visually align the text on both sides in the table comparison panel.

    This would mean to align all exact lines on both sides and when the are lines which exist only on the left or the right to put an empty line on the other side.

    It makes the visual comparison easier and similar to how the Diff/Compare function works in Visual Studio.

    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  ·  0 comments  ·  Features  ·  Admin →
  20. Currently in the differences in the table columns are highlighted with some sort of blue/green, while the column names and the DDL are also in the blue/green color space.

    It is hard to easily figure out what is the difference.

    It would be really helpful to be able to change the highlight to any chosen color - for myself I would choose yellow :)

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