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

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:
https://documentation.red-gate.com/rr1/worked-examples/tutorial-running-tests-in-readyroll-with-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.
Tagged:

Answers

Sign In or Register to comment.