ATS : Test Explorer - FAQ

How should I create DB backup?

You may use MsSQL Management Studio. Right click on DB name on the left. Then choose Tasks->Backup ... On the dialog you may check and change destination of the file. Also you may enable compression in Backup options section.



How should I restore DB?

There are 2 options.

  • From DB files taken from existing DB
    In such case you have existing MDF file and LOG file with same name. In SQL Management Studio right click on Databases and choose Attach.
  • From DB backup (BAK file). Here you should initially create new TestExplorer DB. Then right click it, choose Tasks → Restore → Database

In both cases mentioned above you may need to re-associate AtsUser (check your user name) in DB file to the AtsUser created in SQL Server. This is needed when you restore DB to another SQL Server installation. Open query editor in SQL Server Management Studio - right click on DB and then select "New Query". Then paste and execute this statement:

EXEC sp_change_users_login 'update_one', 'AtsUser', 'AtsUser'

 


How to remove database from the list of known databases?

TestExplorer automatically remembers new databases when they are entered in home page. This way you may easily browse it without need to type it again and again.

Currently if you want to drop some DB or remove it from the list you should directly remove the corresponding line from the WEB-INF/classes/databases.txt file. 



Go to parent page

Go to Table of Contents