Move Tests Between Servers

Easy unit testing for databases in SQL Server Management Studio

Move Tests Between Servers

Postby beyond » Tue May 22, 2012 9:25 am

How do I move my tests between servers? I'm looking for a way to import/export into SQL Test.

We have our own source control software and I want to be able to save the tests here.

You always have a choice
Posts: 2
Joined: Tue May 22, 2012 9:22 am

Postby Brian Donahue » Wed May 23, 2012 4:31 pm

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.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am

Setting standard SQLCop tests by Default

Postby bradwist » Mon Jun 18, 2012 9:20 pm

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?

Posts: 2
Joined: Mon Jun 18, 2012 9:15 pm

Return to SQL Test

Who is online

Users browsing this forum: No registered users and 0 guests