SQL Connect (for Visual Studio)

Thank you for trying SQL Connect. Your feedback will influence what we do next!

Suggest a new feature, an enhancement, a bug, ask a question...

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 vote and comment on it.

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

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

  • Hot ideas
  • Top ideas
  • New ideas
  1. Simple

    I want simple:
    1. I like the Solution Explorer - Keep that
    2. I would like to double click an item have it open, start typing and have it do an auto checkout
    3. When I was done and checked it back in, I would like THAT script to be synchronized back to the server

    This would be simple easy and faster than the synchronize method now. This product may buy me the history (source control), but it will cost me production. Not worth the tradeoff.

    A long time ago I used a simple product called SQL IDE Xpress -…

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
    • script as alter for views

      For functions there is a right click button that says scripts as alter.
      For views we don't have that button.
      I Prefere to have the button there as well.

      7 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
      • bug in sql connect for visual studio

        I am currently evaluting your product to decide whether it should be purchased. After startup SQL Connect for Visual Studio is crashing when I try to preview its window. Apparently there is some kind of problem with how xaml is being parsed. Here's the stack trace:
        ______________________________________________________

        An exception was encountered while constructing the content of this frame. This information is also logged by running the application with the /log parameter on the command line, which stores results in "C:\Users\osneed\AppData\Roaming\Microsoft\VisualStudio\10.0\ActivityLog.xml".

        Exception details:
        System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Windows.Markup.XamlParseException: Set property 'System.Windows.Controls.ContentControl.Content' threw an…

        5 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
        • Can't CTRL-F6 to Next Window when editing a Stored Procedure

          Hi
          Just noticed that for some reason I can't use CTRL-F6 to go to the next Window when editing a Stored Procedure via the SQL Connect windows in VS2010.

          If I'm editing a table, that works fine, but editing an SP or using the "Script As Alter..." windows seems to block CTRL-F6.

          A minor issue, but thought I'd point it out

          Richard

          4 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
          • trace file gets huge and hogs perfomance

            Hi,

            the latest SQLConnect version (1.1.1.111) creates a huge log file while running visual studio for a longer time. Each start creates around 1MB and it shortly gets to 50 MB and creates a new log file (log file available).
            I can't seem to disable the trace just to disable the SQLConnect extension, which is not what I want.

            Kind regards
            Joscha

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
            • User filter in SQL Source Control that excludes users and roles from my checked in code

              SQL Connect is not aware of the filter settings and exclusions I have defined in Sql Source Control. Namely, I do no want extraneous users and roles from getting checked into my source control system yet every time I perform a sync, SQL connect brings that information over.

              18 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
              • Invalid object name synchronization

                I moved my views into a new schema, and renamed them to something more appropriate for the project. However now every so often I get an error message when trying to sync, Invalid object name 'old view name which has been renamed and can no longer be found with a VS search', Synchronization failed Edit Synchronization SQL...

                If I then try and execute the synchronization sql I get an error in sp_refreshsqlmodule_internal again stating the old no longer current view name was the error. But again a visual studio search brings up no ref to the old view.

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                • High disk usage

                  Hi,

                  I am trialing SQL Connect at the moment on Windows 8 using Visual Studio 2012 and SQL Management studio 2012 with SQL Server 2012 installed locally.

                  When I use SQL Connect on my local database from within my solution in Visual Studio, it causes excessive disk usage 100% of the time. I am getting ~14Mb/s disk usage caused by SQL Server process when any solution is open with a SQL Connect project in there.

                  Hope this helps.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                  • Synchronization stops working after moving SQL Connect project to any folder other than root

                    Each SQL Connect project is created at the root level of a project. If you move that project into a different logical solution folder, the synchronization stops working.

                    9 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                    • Cannot uninstall SQL Connect

                      Cannot uninstall SQL Connect from Control Panel. Fails with "you do not have sufficient access to uninstall SQL Connect"

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        2 comments  ·  question  ·  Flag idea as inappropriate…  ·  Admin →
                      • Is there anyway to make the Sync and Get Latest run faster?

                        After adding a SQLConnect project to my solution, GetLatest operations within the VS2010 IDE now take at least five minutes whereas prior to adding this project it took all of 10 seconds.

                        After making one change to a single stored procedure, the synchronization process takes way too long.

                        2 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  question  ·  Flag idea as inappropriate…  ·  Admin →
                        • Better integration in VS 2010 and SQL Compare

                          When you right click on the project, it's possible to open it in SQL Compare. This is a great feature, as I love SQL Compare and it gives me full control on how to compare my project and database. But it only comes up with Red-Gate's default settings. I would love to have a feature that allows me to connect a SQL Compare project file to my SQL Connect project. I can then make all the compare settings for a specific project, save it, and join it to the SQL Connect project. Of course I can fire up the SQL…

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
                          • Create folders in the SQL Connect Project

                            I've been using SQL Compare and Data compare for years, and was planning to use the new SQL Server 2012/VS2010 Data Tools instead. But those MS tools are far from the quality of Red-Gate.

                            I've installed SQL Connect and I like the core concept. BUT I have hundreds of stored procedures which I have categorised in folders in a VS 2010 Database project. Great for better overview and control for my developers. Doing the same in SQL Connect is as I understand not possible. Is this something you consider as new functionality in SQL Connect? For now this is actually…

                            6 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              7 comments  ·  feature  ·  Flag idea as inappropriate…  ·  Admin →
                            • sqlconnect views

                              In SqlConnect a key feature is that it preserves comments including those that are _on_ the argument lines of stored procudure.

                              However for Views all the formatting and comments are stripped. By default I would except the SQL to appear formatted as entered (tabs/comments). For some cases this can be more valuable than the graphical representation.

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                              • Field properties

                                It would be really useful if we could see the structure of the table including column types and sizes (pref with columns sorted alphabetically) in a window without opening the alter database dialog.

                                3 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
                                • What is the point of the data folder?

                                  There's a "Data" folder that has nothing in it. I assume it's to add default data to tables, yet I can't seem to add anything to it.

                                  4 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  question  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Solution Explorer scrolls to top each time I open a Database Object

                                    Each time I double-click a Stored Procedure or Table in the Database Project, solution explorer scrolls back to the top.

                                    Just an annoyance more than anything - should stay on the opened object same as any other project file.

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Importing more than one SQL Source Control database into a solution

                                      Is it possible to import more than one SQL Source Control database into a single solution? As soon as one has been imported, the SQL Connect window switches to 'Sync' mode and you can't access the import option.

                                      2 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  question  ·  Flag idea as inappropriate…  ·  Admin →

                                        Sorry for the inconvenience here. For now we only have a workaround for this.

                                        Please right click on the first imported Project and “Unload Project”. The option to import another project should reappear. Once completed with the second import you can right click and “Reload Project” for the initially imported Project.

                                        Please do advise on whether this works for you and also give us an idea about how you’d like or expect it to work properly. Thanks!

                                      • Red Gate Support and Upgrades Messages has stopped working.

                                        After my latest install I get the following message everytime start VS2010 or Microsoft Sql Server Management Studio
                                        "Red Gate Support and Upgrades Messages has stopped working."

                                        Problem Details:

                                        Description:
                                        Stopped working

                                        Problem signature:
                                        Problem Event Name: APPCRASH
                                        Application Name: RedGate.IPNService.exe
                                        Application Version: 1.0.0.262
                                        Application Timestamp: 4f295c0d
                                        Fault Module Name: mscorwks.dll
                                        Fault Module Version: 2.0.50727.5448
                                        Fault Module Timestamp: 4e153960
                                        Exception Code: c0000005
                                        Exception Offset: 0000000000151749
                                        OS Version: 6.1.7601.2.1.0.1296.17
                                        Locale ID: 1033

                                        Read our privacy statement online:
                                        http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

                                        If the online privacy statement is not available, please read our privacy statement offline:
                                        C:\Windows\system32\en-US\erofflps.txt

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Installation problem

                                          I installed SQLDeveloper bundle using an admin account. I checked the "install for all users" option. Under admin account, SQL Connect shows up in VS2010. But I have to use another axccount for "real-life" tasks, and there SQL Connect dows not show up. Seems it asn't installed correctly in VS2010.

                                          6 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          SQL Connect (for Visual Studio)

                                          Feedback and Knowledge Base