Options

ReadyRoll tSQLt Unit Test SQL Azure database

dawidpdawidp Posts: 2
in ReadyRoll
I can't seem to deploy tSQLt framework to SQL Azure database - 0001_Install_tSQLt.sql script from the tutorial: https://documentation.red-gate.com/display/RR1/Tutorial:+Running+tests+in+Readyroll+with+tSQLt+Adapter because SQL Azure doesn't seem to support EXEC sp_configure 'clr enabled', 1;RECONFIGURE; configuration anymore.

Any recommendations on running Unit Tests in SQL Azure?
Tagged:
· Share on Twitter

Comments

  • Options
    AdamBAdamB Posts: 22 Bronze 4
    I'm afraid Azure indeed no longer supports CLR integration, which tSQLt requires to run, so at the moment there is no way to run Unit Tests with tSQLt on Azure.
    Adam Bowden,
    Software Engineer, RedGate Software
    · Share on Twitter
  • Options
    MGibsonMGibson Posts: 15 Bronze 2
    If we have tSQLt in our in premise SQL Server database how do we move these to Azure?
    Do we have to remove them?
    If so how do we run our database unit tests, and we have a lot of them, on Azure DB?
    · Share on Twitter
  • Options
    AdamBAdamB Posts: 22 Bronze 4
    edited July 26, 2018 11:41AM
    It looks as though tSQLt tests can now be run on Azure. However, the statement EXEC sp_configure 'clr enabled', 1;RECONFIGURE; is not supported on Azure - if you want to run database unit tests on Azure, you will need to ensure that your scripts don't contain this. There is an issue in the tSQLt repoing about updating their documentation to clarify things.
    Adam Bowden,
    Software Engineer, RedGate Software
    · Share on Twitter
Sign In or Register to comment.