How can we help you today? How can we help you today?

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.
ReQueZaFax
0

Comments

1 comment

Sort by
  • Sergio R
    Did you set the target database in the test project to be the main database?
    Sergio R
    0

Add comment

Please sign in to leave a comment.