What are the challenges you face when working across database platforms? Take the survey

tSQLt migration fails when using user-defined data Types in a test stored procedure

Completed the following tutorial to configure tSQLt with a database dependency so I can run tests via tSQLt adapter:

I tried to deploy but get the following error when running the test stored proc scripts:
Column, parameter, or variable #1: Cannot find data type dbo.IntegerListType.

dbo.IntegerListType is a user defined table type that is defined in the main database, not the test database but is needed inside the test procedure.


Sign In or Register to comment.