Attaching and Detaching a Database
Attaching and Detaching a Database on Clisp Studio
Clisp Studio allows for Databases to be attached and detached whenever necessary.
This Blog can be downloaded as a support document - SUP0078
Detaching a Database
Occasionally you may be required to detach a database in order to restore a database from a previous backup. To detach a database, open Clisp Studio, select the Files > Database Connection
Figure 1 - Files Menu
The Database Connection window will appear. Select the database you wish to detach.
Figure 2 - Select the Database
Once you have selected the database you want to detach, expand the Options drop down menu and select Detach this Database, see Figure 3.
Figure 3 - Detaching a Database
The Database will now be detached and no longer be visible in the database selection.
Attaching a Database
If a database is not available in the database selection menu, it can be reattached, providing you have created the database on the same PC.
Open the Database Connection window (see Figure 1).
Click on the Options drop down menu and select Attach an existing Database
Figure 4 - Database connection (attach an existing database)
A file explorer window will appear (see Figure 5).
Navigate to the location:
Computer > C: Drive > Program Files > Microsoft SQL Server > MSQL10_50.SQLEXPRESS (this may vary) > MSSQL > DATA
NOTE: Databases will be saved in .mdf format.
Select the database you want to open.
Figure 5 - Database location
The Database is now attached, click Select to open the database.
Figure 6 - Database Connections selecting a database
Identifying the Database that is open
To identify the database that is currently open, open the Test Explorer. (see Figure 7 below)
Figure 7 - Opening Test Explorer
The Database that is currently open will be displayed at the bottom of the Test Explorer, see Figure 8.
Figure 8 - Test Explorer