Add database fails for older database that has SQLTest already installed
jrjones1956
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:
Best Answer
-
Rob C
Posts: 419 Gold 2
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
