Move Tests Between Servers

Comments

• Options

  Brian Donahue Posts: 6,590 Bronze 1

  May 23, 2012 11:31AM

  This is probably more of a tSQLt question, so it would be better to ask at the tSQLt forum. It does look like you can do it, though, by installing SQL Test on the new server (if you are going to a new server), add the database to SQL Test, and copy the schema and data to the new database.
  
  The tests you write are in a schema identified by the class name you give to SQL Test and the list of tests and results are stored in the tables and views inside the tSQLt schema for the database.
  
  I'd check with the tSQLt people before doing anything rash.

  0 · Share on Twitter
• Options

  bradwist Posts: 2

  June 18, 2012 4:20PM

  This is somewhat related to this question. When I add SQLCop static analysis tests to a database, it creates several tests by default. But there are many more SQLCop tests that exist.
  
  How do I create and manage the set of default tests I want installed everytime I add the tests to a database? I would like to be able to package these as part of a standard practice and provide to each of my developers to run as a set of tests.
  
  So the question is...
  
  where are these tests initially defined and how can I add more to this default set?
  
  And if I choose to create additional sets, perhaps under a different grouping, that are customized to our organization, how do I package them for distribution?
  
  Thanks.

  0 · Share on Twitter