tSQLt.AssertNotEquals and tSQLt.AssertLike Missing?

Easy unit testing for databases in SQL Server Management Studio

tSQLt.AssertNotEquals and tSQLt.AssertLike Missing?

Postby JackAce » Mon May 12, 2014 8:01 pm

I installed the tSQLt objects using SQL Test and I can't find AssertNotEquals or AssertLike anywhere. Is this a known issue? I have the latest SQL Test installed (, but I created the tSQLt objects a while back. Is there a way to make sure my local schema is up-to-date?

tSQLt assertion objects according to the tSQLt User Guide(http://tsqlt.org/user-guide/):

tSQLt objects created by SQL Test
Posts: 47
Joined: Fri Jul 08, 2011 10:00 pm

Postby JackAce » Mon May 12, 2014 9:58 pm

Looks like it may be related to this thread?

SQL Test is over a year behind tSQLt:
http://www.red-gate.com/MessageBoard/vi ... hp?t=18049
Posts: 47
Joined: Fri Jul 08, 2011 10:00 pm

Postby Manfred.Castro » Tue May 13, 2014 10:19 pm

Hi Jack,

SQL test 1.5 should include the latest tSQLt framework.

Were you using these databases with SQL Test 1.0?

If so, you will need to manually upgrade the tSQLt framework for these databases.

To upgrade the tSQLt framework you will need to uninstall and reinstall the tSQLt framework.

Please see the following page for details on upgrading the tSQLt framework.

http://documentation.red-gate.com/displ ... ease+notes

Manfred Castro
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 1:49 pm

Postby JackAce » Wed May 14, 2014 6:21 pm

I'm currently using SQL Test 1.5, but the tSQLt framework may have been installed with an earlier version of SQL Test.

I've uninstalled and reinstalled the framework. The objects show up now. Thanks.
Posts: 47
Joined: Fri Jul 08, 2011 10:00 pm

Return to SQL Test

Who is online

Users browsing this forum: No registered users and 0 guests