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

66 results found

  1. 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.

  2. In dbForge Schema Compare for SQL Server you can see actual code difference in UI in Text Compare section. But when it produces a report there is no option to include Text Compare details. Report only has object level details.

    It would be useful to to have option of including actual Text Compare for automated notifications about schema changes.

    39 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  ·  Features  ·  Admin →
  3. It would be perfect to add database documentation feature.
    Generate documentation as CHM or/and as documentation project which could be used by third party tools like Help&Manual.

    38 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Features  ·  Admin →
  4. The Find and Replace defaults to a scope of "All Open Documents", which is quite irritating and potentially dangerous when Replacing. This causes a jump to a different open document and is an unnecessary distraction. A safer and more reasonable default would be "Current Document", as most of the time I am interested in finding something in the current document. Very rarely am I interested in finding text in all other open documents (Object Finder is a better tool for that kind of thing) and would only want to Replace in All Open Documents in very controlled circumstances.

    29 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 →
  5. The scaling on 4k monitors is not very good. Most text is readable but some text like on the title bar and in code-completion dropdowns are being truncated. I have to override the high DPI scaling behavior and set it to System to make it more readable and user friendly. Of course, when I do this it makes some text like that on the start page slightly fuzzy.

    17 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Features  ·  Admin →
  6. 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 →
  7. In SSMS / Visual Studio you can select a box section / columns from multiple lines for editing using the <Alt> key (EG: Select area on a single line, press <Alt> and down / up arrow and you'll have those same columns then selected in other rows too).

    This allows for quickly replacing / editing data that recurs across multiple consecutive lines - It's proved a HUGE time-saver.

    I believe this is what was asked for here:
    https://devart.uservoice.com/forums/177009-dbforge-studio-for-sql-server/suggestions/14157501-column-mode

    and it would be great to have that added into Studio.

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Features  ·  Admin →
  8. When a sql script is being edited and saved in same directory automated created *.design file. The *.design files in working directories is no good. I suggest to add ability set path for storing *.design files in separate directory. By default it can be temp directory.

    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  ·  4 comments  ·  Features  ·  Admin →
  9. 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 →
  10. Add ability show|hide Field description in the Table entity additionally to the Field Name and Type

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

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

    This can be setup as follows:

    1. Right-click in the diagram and select ‘Options…’ from the popup menu. The ‘Options’ window opens.
    2. Switch to the ‘Notation’ tab.
    3. Select the appropriate option from the ‘Field Details Level:’ drop-down menu.
    4. Click ‘OK’.

  11. 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 →
  12. 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 →
  13. Please enable Autofilterrow in gridviews!
    (Feature from DevExpress)

    Regards


    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  ·  1 comment  ·  Features  ·  Admin →
  14. 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 →
  15. Currently dbForge Source Control generates files using <schema>_<objectname>.sql naming convention.
    dbForge Schema Compare does the same if you script objects to a folder.

    Such naming convention does not match our naming conventions.

    Can you please add ability to define object file name format in Source Control and Schema Compare? At least define separator between schema and object name and file extension.

    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  ·  Features  ·  Admin →
  16. I have to script data so it won't produce an error when running the sql statement.. 80% of the time I have to manually update the data synch scripts like this:
    IF NOT EXISTS (SELECT * FROM dbo.DescriptionReference WHERE DescriptionId = '0243b2d2-58b2-4aaf-8cfd-0011f036f0e3')
    INSERT dbo.DescriptionReference(DescriptionId, CultureCode, IsDefault, Description, LongDescription, SourceTable, IsActive, Created, CreatedBy, Updated, UpdatedBy)
    VALUES ('0243b2d2-58b2-4aaf-8cfd-0011f036f0e3', N'en-US', 1, N'2300 REF F8 - P', NULL, N'FormatRuleValue', 0, '2015-06-01', 'TESTA', '2015-06-01', 'TEST')
    If I don't and the data exists it throws an error and stops our DB Upgrade process..
    IT WOULD BE GREAT if you could have an option to turn on…

    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  ·  0 comments  ·  Features  ·  Admin →
  17. Generate a matrix showing tables vs. procs/functions that Create, Read, Update or Delete data in that table.

    Perhaps this could be achieved by expanding the detail available in the "Used By" section of each table.

    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 →

    In version 6.0, the new command ‘Generate Script As → CRUD’ is available in the popup menu of a table in Database Explorer.

    This feature can be setup in the ‘Generate Scripts → CRUD’ section of the ‘Options window’ (select ‘Tools → Options…’ from the popup menu).

  18. Frequently I have the need to comment or un-comment a section of my SQL code, e.g. a set of columns or a portion of a WHERE clause. It would be nice if I could select the block, right-mouse, and select comment/un-comment to place the "--" characters in front of the selected lines of code.

    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 →
  19. The Generate Scripts function under Tasks is missing the option to include database triggers in the list of available objects to include in the output. Triggers are a fundamental component for replicating database schemas and should be included in the scripted output.

    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 →
  20. 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 →
← Previous 1 3 4
  • Don't see your idea?