Copy the Production Data to the Test Environment - Replicating Perceptive Content to a Test Environment - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external - Perceptive-Content/Replicating-Perceptive-Content-to-a-Test-Environment/Foundation-24.1/Replicating-Perceptive-Content-to-a-Test-Environment/Replicating-Perceptive-Content-from-Production-to-a-Test-Environment/Preparation-Worksheet/Copy-the-Production-Data-to-the-Test-Environment

This procedure assumes that your Database Administrator (DBA) performs the steps necessary to copy the database data from the production server to the test server using tools that are appropriate for your DBMS. The Perceptive Content Administrator performs the remaining steps.

On the test server machine, install the Perceptive Content Server that matches your production environment. Follow the instructions in the Perceptive Content Installation Guide to install the Perceptive Content Server. During this step, skip all instructions to create the database or license the product.
On the test server machine, install any agents that are installed in your production environment.
Stop Perceptive Content Server and all agents on the production and test servers to ensure data consistency while copying data.
For your DBMS, complete the following steps.
1. Copy the production database to the test database.
2. On the test database only, delete the following records to remove the production server license information. For SQL, execute as user INUSER. Executing DELETE statements against the Perceptive Content database can negatively impact functionality.
  Important You should create and verify a backup of the INOW database prior to deleting the records.
```
IN_SC_CONNECTION 
IN_SC_AGENT_SESSION 
IN_SERVICE_SESSION 
IN_SC_CLIENT_SESSION 
IN_SC_SESSION 
IN_LIC_MON 
IN_LIC_NAME 
IN_LIC_OVERDRAFT 
IN_LIC_REGISTERED_HW_NODE 
IN_LIC_SERVER_INFO 
IN_LIC_TOKEN 
IN_LIC_TOKEN_COUNT 
IN_LIC_TP 
IN_LIC 
IN_APP_KEY 
IN_SERVICE_REGISTRATION 
IN_TIMING_PARAM 
IN_TIMING_DATA 
IN_TIMING_SUMMARY 
IN_TIMING_HISTORY 
IN_NODE 
```
3. Ensure that the inuser account is created in the test database copied in the previous steps. For your reference, information about creating the inuser account for your DBMS is provided in the Perceptive Content Installation Guide.
On the production server, navigate to the inserver directory and then copy the following folders to the inserver directory on the test server, overwriting the existing directories. If your system does not contain a listed folder, it is not part of your system, and you can ignore that directory.

Directory to Copy	Description
audit	Required if you use auditing.
etc	Required but do not copy the in_hwfp file. In the [drive:]\inserver\etc directory, use a text editor (such as Notepad) to open the inow.ini file and change the value for the odbc.dsn setting to the test server database.
import	Required if you use Import Agent
job	Required
learnmode	Required if you use HyperLearn
osm_0#.0000#	Required
script	Required
user	Required
workflow	Required
worksheet	Required

Start the server and license Perceptive Content and any agents you are using in the test environment. For more information about licensing, refer to the Perceptive Content Installation Guide.
Ensure that you remove on-access virus scans from the inserver directory and all subdirectories. Also, remove on-access virus scan from any directory that you moved outside of the default directory, including the database and OSM directories.