How do I determine Test Definitions in SilkCentral TestManager with a Data Source association?
In a large SilkCentral Test Manager (SCTM) project where there are Test Definitions which have a Data Source association, there may be Data Sources which are no longer used and are no longer required to continue to occupy memory in the Database.
In order to delete these unnecessary Data Sources, you would first have to remove any associations the Data Source may have with a Test Definition. In a large SCTM project, this would mean searching through an entire list of Test Definitions and checking which has a Data Source association; the reason for this is because there is currently no easy way to perform this action.
However, a workaround would be to run the following SQL query against your SCTM database which you can view using SQL Server Enterprise Manager or equivalent. The SQL query searches through all test definitions and retrieves any occurence of a Test Definition with a Data Source association and also returns the Test Container and the Project Name. From this result, much of the work of searching through every Test Definition is removed and you only need to go directly to the correct Test Definition.
// Borland Code VOzohili
Note: Once the Data Source has been identified, in order to remove its association to the Test Definition, you would have point this Test Definition to a different Data Source as it is currently not possible to delete a Data Source association from Test Plan view.