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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
    • 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
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
      • 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
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
        • 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
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
          • Allow LocalReport Render accepting CSV format

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

            13 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
            • 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
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
              • 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
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  5 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                • 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
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                      • 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
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          2 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                          • 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
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                              • 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
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                                • 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
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 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
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 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
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 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
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 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
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            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