SQL Connect

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. Other Collation Support

    We use a collation of Latin1_General_BIN. Because of this SQL Connect thinks that everything in the database has changed. This doesn't help for incremental deploys. The SSDT project is set right and so is the database I am pointing too.

    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 →
    • snapshot

      It would be nice if you could right click the project and have a context menu option to create snapshot, which would be added to Snapshots folder in the project. This would allow to create a snapshot, perform changes, create another snapshot, and then use SQL Compare to generate an update script using the snapshots. On a shared database, this would trap only my changes and the script could then be delivered as part of the build process.

      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  ·  feature  ·  Flag idea as inappropriate…  ·  Admin →
      • SQL connect throws event log errors even when not used and cannot be deactivated alone!

        I should be able to deactivate just SQL Connect to stop it from throwing event log errors, but I can't.

        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 →
        • The ability to add a parameter or rename a function and have it update all the function references everywhere in the database

          Whenever you have to change a function (add a parameter for example) you are forced to go to each object that uses it and right-click MODIFY and then look for all calls of that function and add the parameter to each call.
          It would be great to have a feature that automatically searched and replaced the code to change the function signature in all objects that use it.

          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  ·  feature  ·  Flag idea as inappropriate…  ·  Admin →
          • A right-click Go To Definition while viewing TSQL would be great

            The most time-consuming task for a sql developer is navigating forward and backward through sql functions and stored procedures.
            Right now, I am forced to use Object Explorer and scroll through pages and pages up or down everytime I need to edit an object.
            So a right-click in my Query Window that gives me a Go To Definition and automatically displays a new window with that object in a MODIFY view, or navigates the explorer to that object, would be awesome.

            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  ·  feature  ·  Flag idea as inappropriate…  ·  Admin →
            • New project options

              Have 3 SQL Connect options for New project instead of 2
              1. Create new empty project (will create database for you)
              2. Create project from existing database
              3. Create project form existing datase-project

              That would be less confusing for new users.

              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 →
              • 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…)
                      2 comments  ·  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.

                          25 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"

                                  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…)
                                    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…

                                        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…)
                                          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 →
                                          ← Previous 1 3
                                          • Don't see your idea?

                                          SQL Connect

                                          Feedback and Knowledge Base