Copying Database Records

The Database Maintenance utility can make a duplicate copy of a database by copying records from one database to another database. For example, if a site uses Microsoft Access as the Silk Test Workbench asset repository, and the desire is to store Silk Test Workbench data in an Oracle database, use the Database Maintenance utility to copy the data stored in the Access database to the Oracle database. When the copy utility is used, all Silk Test Workbench data is automatically copied to a format that is readable by the target database.

Copy operations not should be performed on network databases. Instead, copy the database to a local workstation, perform the copy function, then copy the database back to the network location. This ensures that network disruptions and interruptions do not interfere with the copy task.

Ensure that users are not connected to the database.
Start the Database Maintenance utility and open the database to be copied.
Click the Copy toolbar button. The Copy Destinations dialog box opens.
Select the type of database from which to copy, and then click OK.
- To copy an Access database:
  1. In the DSN text box, click Browse and select the DSN of the database to copy. The path and name of the database appears in the Access text box.
  2. Click Copy. The Copy Table Status dialog box opens and displays the progress of the database copy operation.
- To copy a Microsoft SQL Server database:
  1. Type the name of the Microsoft SQL Server data source or click Browse to select a data source name. The owner name defaults to dbo.
  2. Type the user ID. The user must have dbo privileges.
  3. Type the password for the Silk Test Workbench database instance on the database server. This User ID and password is used to attempt a connection to the Silk Test Workbench database instance on the database server.
  4. Click Copy. If the owner name, user ID, and password are accepted by the database server, the Data Source Creation Status dialog box opens and displays the progress of the database copy operation.
- To copy an Oracle database:
  1. Type the name of the new Oracle data source or click Browse to select an existing data source name. The Schema and User ID text boxes have a default of System, therefore only a system administrator or someone with knowledge of the appropriate password can perform maintenance if the default settings are used.
  2. Click Copy. If the schema name, user ID, and password are accepted by the database server, the Data Source Creation Status dialog box opens and displays the progress of the copy operation. The Database Maintenance utility begins populating the Silk Test Workbench database instance with the necessary Silk Test Workbench tables.