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. SSDT: Saving Data Comparison

    I use a lot of Data Comparison, but for one of my database I need to change the Comparison Key (why you don't take the primary key for the default Comparison Key?)

    The Comparison Keys used for the comparison aren't saved in the DCMP file (the unselected tables too).

    Please save all information when a comparison is saved.

    46 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 →
    • Sql Server Object Explorer filters for database objects.

      Sql Server Object Explorer needs to have filters for database objects. When filters are added they should not be like the filter options

      42 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        4 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
      • Add "Generate rollback script" button in SQL Server Data Tools' Schema Compare

        I use Generate Script button to produce a script to introduce changes from development to other environments.
        Normally the deployment procedure is (simplified):
        Script the change using Schema Compare.
        Backup the target database.
        Apply the change.
        If something goes wrong: Restore from backup.

        This works if the script fails. However, sometimes the change has issues that have made it through testing, that do not become apparent for some time (like the middle of the next day...). At this stage I have the option of restoring, and losing user data. Alternatively, restore the backup I did to another database (or SQL…

        41 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 →
        • Improve SQL Server Management Studio Diagrams

          Improve SQL Server Management Studio Database Diagrams to use modern disign (aperance) like VS Class Diagrams or EF Diagrams.

          It is unaceptable on these days that SQL Server Managemnt Studio renders that ugly and old diagrams with those old fat lines and borders. We would love to see SQL Management Studio Generating beautiful diagrams like VS Class Diagram or EF Diagrams.

          Also allow "Fit to print" options like CA Erwin does.

          39 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 →
          • SSDT: Globally suppress errors on Database projects

            We use database projects mostly for getting database objects into source control and doing schema comparisons to push changes back and forth between databases. Everything works well expect unresolved reference errors floods the error list. Can we get the ability to globally suppress errors on these types of projects?

            36 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 →
            • Add support sqlite databases in SSDT

              Please work on SQL Server Data Tools support sqlite databases in Visual Studio that now support in UWP,Entity Framework Core and Windows 10

              35 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 →
              • Support for SSIS projects in Visual Studio 2017

                Support for SSIS projects in Visual Studio 2017

                32 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 →
                • Allow for overriding a stored procedure or function in a referenced sql project

                  If you have a SQL proj that references a dacpac, that dacpac may have stored procs or other objects that are designed to be overridden or extended by later projects.

                  Currently if you try to create a procedure with the same name, you get SQL71508 errors ("the model already has an element with the same name").

                  The behavior I am looking for is similar to virtual/override in .NET.

                  Being able to suppress this error and still generate the relevant ALTER would also work.

                  31 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    3 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                  • SQL Server projects in VS2013 should generate create script only for object in the project

                    When creating SQL Server Project in VS2013 and referencing another SQLServer project on the same server and database. The generated create script generates create statements for objects defined in the referenced DB.

                    30 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 →
                    • Stop SSIS Script Task Projects entering the Recent Projects List in Visual Studio

                      When I edit the code inside a script task in SSIS, the auto-generated project gets added to the Most Recent Projects list in Visual Studio. If I edit a script task ten times, when I open Visual Studio, all I see in the list of recently used projects is SSIS script task projects with names like SC_5d7025a13224fabc1256de123f... etc. Since none of these projects will ever be opened directly from Visual Studio, they should not have been added to the MRU list.Since none of these projects will ever be opened directly from Visual Studio, they should not have been added to…

                      29 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 →
                      • use sqlcmd variables in schema compare

                        In my database project I use sqlcmd variables for synonyms that point to other databases. In schema compare it would be nice if these sqlcmd variables are evaluated/replaced to avoid false positives in comparison.

                        27 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          3 comments  ·  SQL Server and Data Tools  ·  Flag idea as inappropriate…  ·  Admin →
                        • SSDT: Initial Data Support (not only schema but Data too)

                          I think it would be very use-full to be able to store 'initial' data inside of the project. Very often database has some static look-up data that would be very nice to have inside of the project..

                          right now the work around is possible having a bunch of post-deploy scripts with a merge statements inside, but I think some native support would add value.

                          24 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 →
                          • SSDT should warn against unnamed constraints

                            Allowing unnamed constraints introduces inconsistency between the source code (SQL Project) and deployed system (SQL database) as the unnamed constraints get created with a random name.
                            This means a schema compare of two databases created from the same SQL project will have diffs.
                            Real problems occur when deploying updates to a target database whose schema is not 100% known (due to random constraint names).
                            This problem would be solved if SSDT was aware of unnamed constraints and either warned or forced a name for all constraints.

                            24 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 ability to save data compare options, tables, columns for future re-use

                              Currently you can't save the tables / columns you want as part of the data compare. It would be nice to have this feature.

                              21 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 →
                              • Schema Compare bug Target or Source is unavailable

                                Hi!
                                When I'm using a connection with Sql Server Authentication without select Remember Password, after restart Visual Studio, when I re-enter the password and click in compare, I receive the error "Target is unavailable" or "Source is unavailable" depending where is my connection.
                                If choose Remember Password and then restart Visual Studio, the error disappear. But it's a database with sensitive data and we can't save password for security reasons.
                                I have read other forums and this is not a problem with password, but a bug.

                                21 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 SSDT MSBuild Tasks

                                  Please support MSBuild tasks (maybe in a NuGet package) for SSDT (at least SSIS package building) across Windows/Linux/Mac so that we could author SSIS packages on Linux/Mac using VSCode.

                                  21 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 →
                                  • Don't rebuild SQL Server Database Projects every time

                                    Currently, SQL Server Database Projects are rebuilt systematically even when it seems unnecessary and the user asked for a normal build (as opposed to a forced rebuild).

                                    This can be reproduced by creating a new empty sqlproj using the SQL Server Database Project template, and select "Build" twice. It will be rebuilt the second time even though no change occured in between.

                                    20 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 →
                                    • Dependency Graphs for SQL Server Database Projects

                                      This suggestion is migrated to Developer Community. Please use below link to view the current status.
                                      https://developercommunity.visualstudio.com/content/idea/351241/dependency-graphs-for-sql-server-database-projects.html
                                      Visual Studio 2010 does not support generation of Dependency Graphs for Database Projects.

                                      It would be great if Visual Studio 11 could support the new SQL Server Data Tools Database Projects.

                                      It would be great to be able to generate dependency graphs for all database objects and cross-database project references.

                                      20 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 →
                                      • Schema Compare - Allow to configure schemas to ignore/include.

                                        In the current database I work we have a lot of schemas that I will not use. It will be good if there were a feature that allow us to include/exclude schemas from the comparison. That will help to speed up the comparison and also to focus and the objects I care.

                                        This feature will be appreciated.

                                        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 →
                                        • add support for @variable names been used in table names and columns for dynamic queries

                                          hi, i am not sure if this the best place to post this request, if not please let me know if a similar section exists for SQL server requests.

                                          as the title said, it would be a huge advantage to allow in our queries without having to make them "strings" to use any name you wish as passing parameter to allow more dynamic queries, but at the same time avoid syntax mistakes by using the full sql managements intelligence abilities!

                                          in other words allow the following kind of syntax to be executable:

                                          declare @tableName nvarchar(max)
                                          declare @columnName nvarchar(max)

                                          select myStaticcolumn,…

                                          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 →

                                          Feedback and Knowledge Base