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.

156 results found

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

  2. Configurable Layout

    It is typical to write or extend a sql stmt on the top of a query window and to see the result in the bottom.
    dbForge has not that standard behaviour for this window. My Suggestion is to configure or save the last the window layout as it will be needed.
    I know there are two buttons in the bottom to click on to change this layout but when you work the whole day with this tool and you have click 200 times a day these both buttons it's getting bothersome and not a good user experience.

    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 →

  3. 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 →

  4. 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 →

  5. Option to align the text in the table comparison panel

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Features  ·  Admin →

  6. 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 →

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

  8. 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 →

  9. 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 →

  10. Copy with column names doesn't paste correctly into Excel

    Do any select, copy with column names. Paste into Excel. Data pastes properly, but column names do not.

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

  11. 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 →

  12. 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 →

  13. Import Excel - a preference to change default varchar size from current 4000

    Whenever importing workbooks, the data type for text gets set to varchar(4000)

    In a normalized table it is rare to have all fields of this size - but more importantly, the maximum length that T-SQL allows for INDEXING is 900, so if I was to have a default value which is most flexible, it would be 900, not 4000.

    Since spreadsheets tend to be flat data with many columns that have to be analyzed in many ways - I always have to go through each column before importing to figure out which column I may want to create an index…

    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 →

  14. Ability to select encoding when exporting to DBF

    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 →

  15. 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 →

  16. Intellisense for tables in tempdb

    When joining, querying, or trying to expand table.* column names for a table in the tempdb database, Intellisense does not work even for tables that existed when starting dbForge.

    It would be nice to be able to have that feature even if it meant manually adding the table to the Intellisense cache.

    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 →

  17. 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 →

  18. Card View Scroll

    Can you add the features in the Card View of the record to scroll the value with the scroll's button mouse?
    When I have many columns its long to press all the time the arrow

    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 →

  19. Integrate this voting site into the product to get more feedback.

    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 →

  20. 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 →
1 2 4 6 7 8
  • Don't see your idea?