SQL Test forum

Welcome to the SQL Test feature suggestion list. Find out more information about SQL Test at http://www.red-gate.com/products/sql-development/sql-test/.

If you have any questions, need help or have found a bug in SQL Test, please visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=161.

How can we improve SQL Test?

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.

  1. reduce the footprint

    The install requires that you create schema, tables, procedures, functions etc in each database you want to test. I don't really like the idea of having 'foreign' objects in my databases. Could this work from one place? I.e. A single tSQLt database?

    123 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…)
    • Integrate "SQL Data Generator"

      Allow the use a "SQL Data Generator" to create test data needed for a test

      39 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…)
      • Automatically generate unit tests.

        It would be really nice if you could update the SQL Test tool to generate unit tests similar to how NUnit integration with Visual Studio can automatically generate its tests.
        Picture generating unit tests for every function and proc in a database where the unit test generated would create code that would automatically generate all the parameters needed and populate them with default values/nulls. The first run of the test would of course fail...then you start to update each test to suit the objective of the test.

        36 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  ·  Admin →
        • Code coverage

          I would assume this to be non-trivial, but in learning about testing with application code, I find code coverage tools invaluable.

          33 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…)
          • Add the capability to create a "logical folder" on test hierarchy

            It could be useful to add a capab "create folder" (like "solution folder" in Visual Studio) which allows us to logically separate tests. This can be used for the "Run Test" command.

            28 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  ·  Admin →
            • Allow copying text from SQL Test Messages window

              It appears that there is an issue in SSMS (I am on SQL 2012 RTM, US English) that prevents you from copying text out of the SQL Test Messages window unless all SQL editor windows are saved to disk. For example, if you run some tests, then highlight the text in the SQL Test Messages window, and do either CTRL+C or Edit... Copy, SSMS will give you a scary error message if you haven't actually saved all of your query windows to disk files: "Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project. You…

              27 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…)
              • Show setup in SQL Test window

                I've created a Setup procedure but it doesn't show up in the SQL Test window. So it's not clear for any schema whether there is an associated SetUp. Given that it must have the same schema as it's tests could it be included in the window

                21 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…)
                • Need a way to easily disable tests

                  There are tests (especially SQLCop tests) that I'd like to be able to disable easily so they don't automatically get run when you execute tSQLt.RunAll.

                  I don't want to delete the test, because there's value in knowing the test exists. You may not be able to fix *all* SQLCop issues right away, but you don't want the build to fail until you have time to fix it. There may be a user story to fix the issue, and you'd like to disable the test until the issue is fixed.

                  You should be able to disable the test by either
                  *…

                  20 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…)
                  • One test DB per Server vs adding tests to each DB

                    What are the Pros and Cons for having a test DB vs running tests on each individual DB.

                    19 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  ·  Admin →
                    • Allow the developer to control the order in which tests are executed.

                      In the SQL Test UI it would be extremely useful to be able to control the order in which tests are executed. For example being able to click and drag a test in the test hierarchy to revise order.

                      This is particularly useful in a scenario where you want to "build up" test scenarios. For example, execute all tests for "core" modules first, followed by all tests which utilise those modules and so on.

                      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…)
                      • Can you provide a right click menu option for scripting out all (or individual) tests

                        Context menu option on all nodes in the SQL Test panel - with the following options:
                        a. on the db node - "Script all tests" (scripts every test, and all classes)
                        b. on a test class node - "Script all tests" (scripts all tests that belong to that class, and the class)
                        c. on an individual test - "Script test"

                        16 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…)
                        • Give better access to setup routines for test classes

                          tSQLt allows you to have class-specific set up SPs (called setup in the class schema). However I can't find an option to create these directly within SSMS. Perhaps a right click on the class to allow you to edit / create a setup script, as well as some way of visualising that a setup script exists for a given class within the SQL Test window.

                          15 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…)
                          • 14 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…)
                            • Test Results Output to File or Table

                              Output to the Test window can be fine, depending on the situation. However, an output from a full test run to a text file or to a table in a database so that you know, and can compare, one test run to another, is absolutely necessary. As you start expanding to enterprise level of testing, you need to be able to search and sift through the test results. Having them in a window that you have to copy and paste from is not automation.

                              14 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…)
                              • Add ability to edit template text.

                                Basically, my OCD nature of coding means that the template text doesn't match exactly with what I'd like to see in the comments of my tests. In my case, I want tabs before the comments (not 2 spaces) and don't care about the rest of the header text (the instructions for each section). I'd like to ability to massage the template text into exactly what I want. I'm guessing this is currently generated in CLR code. Is there a way to store this information in the database somewhere so that it's editable?

                                14 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…)
                                • Table fakes to optionally include triggers

                                  Table fakes don't currently include triggers, which means that we can't use them to test trigger functions.

                                  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  ·  Admin →
                                  • Don't require installing objects in your database for unit testing

                                    I have to remove the objects it creates on my database before they go to production. QA can't run these at all as they are not allowed to create/alter any database objects.

                                    8 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…)
                                    • I'm a single DBA/ Dev shop, with only 1 server, with a few dev dbs. Why do I NEED this product?

                                      What is SQL Test offering me? I can't find any documentation on the site for use cases or anything for that matter. Why am I using this, what would be the use processes? Is this a place to store QA tests to run against a db?

                                      8 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…)
                                      • Opensource this product

                                        Seems like this is no longer being maintained and there's been no innovation for ages. Why not open source this and contributors can add the things they need resulting in a better product all round. Since the tSQLt framework is opensource anyway, why not add the UI part to the project.

                                        8 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…)
                                        • have a filter on the database being worked on

                                          We have many customer databases, all of a similar schema, all with tSQLt installed. A typical developer machine may have 8-10 of these databases on.

                                          It is very hard to see which database to work on in the SQLTest as the tree view just expands them all.

                                          8 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  ·  Admin →
                                          ← Previous 1 3 4 5
                                          • Don't see your idea?

                                          SQL Test forum

                                          Feedback and Knowledge Base