tSQLt migration fails when using user-defined data Types in a test stored procedure
ReQueZaFax
Posts: 1 New member
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.
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
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools