Skip to content
← Customer Feedback for Devart

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

(thinking…)

How can we improve the product?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

134 results found

  1. DB Forge crashing

    Probably 2-3 times a day DB Forge crashed. Quite often it does this while i'm not even using it. All I get is the windows 'dbForge Studio for SQL Server has stopped working' dialog (the one which has the Debug and Close Program buttons). This has started happening after the last update

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  2. Ability to Enable or Disable Trigger

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  3. Provide the ability to export data in MS Excel 2010 format.

    more than 65000 recordes can be experted in csv format files, but they cannot cope with ' or " is text fields.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  4. Generate CRUD Matrix from a SQL Server database.

    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)
    Close
    Close
    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)
    Close
    Close
    completed  ·  AdminDevart (_, Devart) responded

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

  5. Interface for tSQLt

    An interface for tSQLt tests. Schemas, procedures, add test, add test class (schema) and so on. Something like Red Gates Sql Test but as a VS add-in and with the ability to view a single database. Also. the ability to the various displayed objects would be very useful. Filters could be fairly simple, class name contains, test procedure contains, begins with, ... Would be nice if the filters could be saved between sessions but certainly not a requirement.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  6. Add table triggers as an option to the Generate Scripts database scripting function

    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)
    Close
    Close
    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)
    Close
    Close

  7. Transaction log reader

    A tool to read transaction logs similar to http://www.apexsql.com/sql_tools_log.aspx

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  8. Control-N in an SQL window

    When I press control-N in an SQL window, why does the new window not inherit the server and database of the current window?

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  9. Source support for the online (www.visualstudio.com) version of TFS.

    The visualstudio.com online version of TFS will not authenticate with Source Control. I have tried alternate credentials and using the tool from http://nakedalm.com/tools/vso-service-credential-viewer/.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  4 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)
    Close
    Close

  10. Hierarchical data viewer

    Is it possible to add hierarchical data viewer? I mean, viewer where you can set parent and child field and it build a tree based on query.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  11. Make schema comparison in vertical windows rather than in horizontal ones

    Currently, the screen is divided onto two horizontal parts where the top window contains objects and the bottom one has their text representation which is not quite convenient because there is a lot of spare place left not used.

    Visually, it would be much more convenient to have the ability to place the windows vertically rather than horizontally unlike the current implementation.

    For example, like in AdeptSQL Diff.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  12. Invalid scripting for FK deleting using "IF OBJECT_ID('FK_...', 'F') IS NOT NULL" check.

    Invalid scripting for FK deleting using "IF OBJECTID('FK...', 'F') IS NOT NULL" check.
    There is need to use schema as part of FK name. Reason: "OBJECT_ID() function returns NULL for "non-dbo schema" FK.

    Bad script:
    IF OBJECTID('FKFDlalala', 'F') IS NOT NULL
    ALTER TABLE EE.FD    lalala
    DROP CONSTRAINT FKFDlalala
    GO

    Uber script:
    IF OBJECTID('EE.FKFDlalala', 'F') IS NOT NULL
    ALTER TABLE EE.FD    lalala
    DROP CONSTRAINT FKFDlalala
    GO

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  13. Ability to set edition for trial mode.

    During the 30 day trial, the application runs in enterprise mode. It would be ideal to have the option to change the edition that it runs as so that we can easily see what features we gain/lose with each edition. For example: My company is looking at standard edition. I have to keep going to the website to see if the feature I am currently playing with comes with that edition. It is making my evaluation much more difficult.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  14. "Object has invalid source text" - Improve Error Information

    For simple error situations, the editor will collect errors and display them in the error grid upon save attempts. However, for many errors, it will simply display "Object has invalid source text and cannot be saved".

    If I take the entire editor contents and paste it into SSMS and attempt to execute it, helpful error text will be returned, such as "Must declare the scalar variable '@foo'", complete with a line reference.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  15. Data Comparison and Sync: Add option to "ignore computed columns"

    Some of my tables have computed columns. I try to go through the mappings and manually un-check those tables before I do a data sync, but I sometimes miss one, the sync blows up, and I have to start again from scratch.

    Since it doesn't normally make sense to try to write to a computed column, I think there should be a (defaulted to on) checkbox that says "ignore computed columns".

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  16. Adding an option to add "if exists..." to script generation

    Can we have an option to choose that makes dbForge generate "if exists" statement when generating scripts for database objects?
    Ie:
    when clicking on a sproc, table, view or synonym and selecting: "Generate Script As" - "Drop and Create", it would be nice if the generated script checks if the entity exists before dropping it.

    Currently, I have to do this manually every time to have a decent deployment script.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  17. Script generating with table rename and reinsert data

    Here is some table need to recreate and refill data after if. Recreation reason- identity increment has been changed.

    This script was generated:

    IF OBJECTID(N'dbo.EDDevicesSHADOW', 'U') IS NOT NULL
    AND OBJECT    ID(N'dbo.tmpdevartEDDevicesSHADOW', 'U') IS NULL
    EXEC sprename N'dbo.EDDevicesSHADOW', N'tmpdevartEDDevices_SHADOW', 'OBJECT'
    GO

    IF NOT EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    AND EXISTS (
    SELECT 1 FROM sys.indexes
    WHERE name = N'PK    EDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
    EXEC…

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  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)
    Close
    Close

  18. Setting to customize the highlight color in the table comparison panel

    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)
    Close
    Close
    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)
    Close
    Close

  19. Ignore index included column order

    In the Schema comparison options, to have another option available to ignore the column order for the included columns in a nonclustered index, as this column order is not relevant.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close

  20. Zoom query window (like SSMS)

    Please add the ability to zoom in/out in the query window to change the text size

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    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)
    Close
    Close
1 3 5 6 7
  • Don't see your idea?