Cisco Cisco Agent Desktop 10.0 Installation Guide

Switching Data Stores

October 16, 2015

137

Switching Data Stores

If you are switching from flat files to SQL Server during an upgrade, you can back up 
the flat files and then import them into SQL Server using the Data Migration Tool. 

You must first verify that the following local user account and local account group have 
been created by PostInstall.exe:

■

CADSQLAdminUser

■

CADSQLAdminGroup

This allows the system to run the SQL queries CAD needs to create an FCRasSvr 
database and set up Recording and Statistics service replication.

The secure password associated with CADSQLAdminUser is hard coded and must 
never be changed. Verify that CADSQLAdminUser is part of the local 
CADSQLAdminGroup group and the local Administrators group.

Using the Data Migration Tool

The Data Migration Tool enables you to retain agent state and call data when 
switching from flat files to SQL Server database.

NOTE:  Migrating data can take several hours. Therefore, it is 
recommended that you run the Data Migration Tool during contact 
center down time. 

1. On the server that hosts the Recording and Statistics service (and in an HA 

environment, the primary server), navigate to the following folder:

C:\Program Files\Cisco\Desktop\bin\

2. Double-click FCRasDBMigrationTool.exe and follow the command prompts to 

run the Data Migration Tool.

NOTE:  In an HA environment, the data imported to the SQL Server 
database on the active server will be replicated on the standby 
server.

NOTE:  Do not attempt to run the Data Migration Tool at the same 
time on both sides in an HA system. Doing so might result in corrupt 
or missing data.