Options

Add database fails for older database that has SQLTest already installed

jrjones1956jrjones1956 Posts: 13 Bronze 1
in SQL Test
I have a SQL Server 2012 database that at one time was set up to work with SQLTest version 1.0.xxx. However, life intervened, and the development effort did not include SQLTest for about three years. Now I have upgraded SQLTest to the latest release (3.0.2.400) and want to start again on my database, but it still includes the tSQLt schema, tables, and views (no stored procedures). When I try to add the database to SQLTest, the process errors out during the "Installing Test Framework" step with this message:  There is already an object named 'tSQLt' in the database. CREATE SCHEMA failed due to previous errors. What can I do?
Tagged:
· Share on Twitter

Best Answer

  • Options
    Rob CRob C Posts: 419 Gold 2
    Answer ✓
    Hi,

    I'd suggest manually uninstalling the tSQLt framework on your database by running EXEC tSQLt.Uninstall;

    Once you've manually uninstalled it, you should then be able to add the database to SQL Test.
    Software Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.