Visual Studio IDE

Announcement: This forum has been migrated to provide our customers one convenient and responsive system for all feedback. You can now suggest new ideas, browse and vote on existing ideas in the Visual Studio Developer Community. To learn more about the migration to Visual Studio Developer Community please check out the release blog post.

We’d like your suggestions and ideas to help us continuously improve future releases of Visual Studio, so we’ve partnered with UserVoice, a third-party service, to collect your feedback. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

This site is for feature suggestions; if you need to file a bug, you can visit our Developer Community website to get started.

Note: your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy and license terms.

We look forward to hearing from you!
- The Visual Studio Team

I suggest you ...

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Data Comparison Support for Identity Fields

    SSDT Data Comparison does not handle identity columns. We need ability to specify what to match on instead of using PK, which in case of identity columns is not going to match across servers. Also, need to be able to ignore columns. Redgate Data compare has these features already.

    16 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  2. Fix the SSRS Query Designer to allow use of DAX variables when referencing SSAS 2017 Tabular Models

    We recently upgraded our Development environment from SSAS 2016 Tabular to SSAS 2017 Tabular. Our client was hoping to make use of object level security available in SSAS 2017. We have many paginated reports with datasets queries written in DAX. We make use of DAX variables whenever possible. Everything worked fine when our data source was SSAS 2016. Now that our data source is SSAS 2017 we get a generic "unexpected error". If we modify our DAX and remove the DAX variable declarations we can get SSDT to recognize our query is valid. We have tried the latest SSDT builds…

    15 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  3. Generate Entity Framework models from Database Project

    Allow for Entity Framework code first model generation to target a Database Project and generate or update the entity models from the SQL files contained in the project.

    15 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  4. Include 64-bit version of Import and Export Data Wizard with SSMS 2016 install

    Since SSMS 2016 is only 32-bit it only comes with the 32-bit edition of the Import and Export Data Wizard. This does not work if you have the 64-bit Office installed. I can't import any Excel file because I can only have the 64-bit ole provider installed and I need the 32-bit one. If I run the SQL Server Installer I can only can this the 64-bit Import and Export Data Wizard by installing the fully SSIS which I don't need on my development machine.

    15 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow LocalReport Render accepting CSV format

    Please allow LocalReport.Render method accepting CSV formats as well.

    13 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  6. Task List Support (TODO) for SQL Files, Queries, Store Procedures and Functions

    It's really frustrating that there is a task list in Visual Studio and Management Studio, but no interpretation of the common TODO parameter. It would be really helpful if e.g. --TODO: get's highlighted and recognized in the task list. Of course then I would expect to jump directly to the TODO, like it's used in C#.

    13 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow filtering by "is null" in SSDT View Data

    SQL Server Object Explorer has the option to View Data for a table, which opens a tab with the table data. The tab has an option to filter the data, but you can't filter by "IS NULL". You can only put values in the Filter column of the Filter and Sort window.
    I suggest you either add a check box column to filter the column by null value, or allow typing "is null" in the Filter column.

    13 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  8. Data Compare automation table list

    This is a copy of the ticket here: https://visualstudio.uservoice.com/forums/121579-visual-studio-2015/suggestions/2238554-data-compare-automation-table-list?tracking_code=1d1709c3782b3501b0ab7fa8837b7534

    It was suggested if this is still valid to reopen a new ticket or search for an existing ticket. There are many folks looking for similar functionality to this in many littler tickets... This is still desired!

    It would be nice to save data comparisons (in a definition file, etc) or pass in which tables to compare via command line / command utility. When comparing data in larger databases (say, 500+ tables) and I want to compare only a subset of tables (say, 50-100) the interface requires manually selecting only the…

    12 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  9. SSRS New Parameter Area: Adding Text Box/Messages

    With the new design area for SSRS's parameter area, allowing for excellent arrangement of the parameters, could a feature be added to allow for using a cell (or multiple cells) to allow for text to be displayed. This would allow for a message or instructions to be placed for the end user, prior to the report being generated, such as an email to the BI team, or high level description of the report use.

    12 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  10. Support Server Multi-Targeting for ISDeploymentWizard.exe

    When deploying from VS 2015 everything works, when using the command line tool, package execution fails. Repro steps:

    - Compile SSIS project from VS 2015 Update 2 with SSDT 2016
    - Run the following command line targeting a SQL 2012 server: ISDeploymentWizard.exe /Silent /ModelType:Project /SourcePath:".\XYZ.ispac" /DestinationServer:"Server\sql2012" /DestinationPath:"/SSISDB/Path/Folder"
    - Execute "XYZ.ispac" via SSMS 2016

    - Package execution does not start and returns error:

    Error: Package migration from version 8 to version 6 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number."

    12 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  11. measures grid when working with SSAS tabular models is so clunky!

    The main issue is that the column widths are dependent from the table columns, which makes no sense since measures are independent from those. The UX/interface for handling measures needs to be reconsidered.

    10 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  12. Database Project - SSDT Publish profile properties and configuration

    SQL server Database Project (SSDT)
    Please add option for to Ignore or Exclude below objects also
    1. Full text index
    2. Full text catalog
    3. Schema (Drop schema)
    4. Others (We can provide objects name to exclude)

    Because these are the only objects which can not be excluded by the publish profile parameter rite now. if it has been included we can deploy are changes directly to the Target environment.

    10 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  13. SSIS Script Tasks to not error when executed on SQL Server 2014

    Issue Definition: A SSIS package in SSDT 2015 and this package has a script task.
    The script task works fine when we run the package from SSDT2015 and it fails when the package is executed in SQL Server 2014.

    Following is the error seen:
    Script Task: Error: There was an exception while loading Script Task from XML : System Exception : The script task uses version 14.0 script that is not supported in this release on Integration services. To run the package, use the Script task to create a new VSTA script. In most cases, scripts are converted automatically to…

    10 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  14. Include the Business Intelligence Template in Visual Studio 2017

    I just installed the new Visual Studio 2017 RC and noticed that the BI template is missed.

    10 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  15. Improve SSDT Build Times

    We have a sqlproj with over 1K Stored Procedures and the build time is horrendous. We'd love to see this improved.

    10 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  16. Make SSDT project's setting (such as database settings and so on) be specific to build configuration

    Right now SSDT project's settings are same for all build configuration. It would be great to have specific settings for each configuration.

    For example, production sql server works in partial containment mode. Test server is not. It is impossible to publish to both server's without changing project's settings each time. So it's impossible to automate publishing process without workarounds.

    10 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  17. Support project templates and item templates for SSDT database projects.

    Our team uses established patterns for designing and publishing databases using SSDT and database projects. Much of the work that we do when designing a new database involves copying folder structures, files and script templates into a new database project. It would be great to distribute an SDK that automates the process in Visual Studio.

    9 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  18. Data Source View (DSV files) more merge friendly

    Would be good if the diagrams layout in DSV files were located in a separate file.

    When using merge tools (including the TFS merge tool) most of the issues related to merge conflicts relies on the diagrams. Sometimes it makes impossible to merge branches.

    9 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  19. CREATE OR ALTER not just 'CREATE' for Stored Procs in DB Projects

    Currently when we make a change to a stored procedure we need to switch the CREATE statement to 'CREATE OR ALTER'. So that we can apply the change directly to the local Dev copy of the DB (ctrl-E) during development, but this causes DB build to fail. We have to change it back to CREATE for tests with auto-deploy on.

    9 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
  20. Add a button to sql server object explorer window

    Detect if sql server management studio is installed and add a button that launches management studio connected to same server instance that is the selected server instance. This will allow us to do the work we can in Visual Studio and when needed click the button to switch to management studio to handle the things we can't in VS.

    9 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →

Feedback and Knowledge Base