Move contact center database from MSDE to SQL Server

(1)

Voxtron Knowledge Base

Voxtron Benelux – Uilenstraat 155 – Sint-Niklaas – Belgium +32 3 7604020 – http://www.voxtron.com

Page 1 of 7

Voxtron Knowledge Base

Move contact center database from MSDE

to SQL Server

KB number KB0052

History 19/12/2008 V1.0 By Thomas De Smet, adapted from Marc Bau

C

ONTENTS

CONTENTS ... 1

DESCRIPTION ... 1

SOLUTION ... 1

REQUIREMENTS ... 7

REFERENCES ... ERROR! BOOKMARK NOT DEFINED. APPLIES TO ... 7

KEYWORDS ... 7

D

ESCRIPTION

This document describes the steps to move an existing contact center database from the build-in MSDE Server to a SQL Server 2005. This is not an upgrade, so the move will be between databases of the same agenTel version (e.g. 6.0 to 6.0). Otherwise, you should use the upgrade procedure as described in the reference manual of agenTel.

Note: You cannot move the database to a SQL Server 2005 Express because this version doesn’t have a SQL Server Agent service to run jobs. SQL Server jobs are scripts that are scheduled to run at a specific date and time. AgenTel uses these jobs to schedule the automatic creation of statistic reports.

S

OLUTION

Step 1: Install new contact center database

Use the agenTel database only setup to install a new contact center database on your destination SQL Server 2005.

(2)

Move contact center database from MSDE to SQL Server

KB0052

Voxtron Benelux NV – Uilenstraat 155 – 9100 Sint-Niklaas – Belgium +32 3 7604020 - http://www.voxtron.com

Page 2 of 7

Step 2: Backup and restore database

Take a complete backup from the contact center database on the MSDE server (source database server) to export your existing data and restore the contact center database to the new SQL Server 2005 (destination database server). Be sure that the databases are not used during the backup and restore process so that the backup will contain all the changes

(complete data). After the restore, the database on the destination service will have the same size as the database on the source server. If you want to reduce the size, you must either reduce the source database before you perform the backup, or reduce the destination database after the restore is completed. For detailed information about „database shrinking‟

refer to the „Creating and Maintaining Databases” in SQL Server books online. Backup the contact center database from the source server

(3)

KB0052

Page 3 of 7 Restore the backup to the destination database server

(4)

KB0052

(5)

KB0052

Page 5 of 7

Step 3: Export and Import jobs

Step 3 is optional and should only be executed when you have defined scheduled reports. You have to generate a script file for all the jobs on the source server, and then run this script file on the destination server to import the jobs.

(6)

KB0052

Page 6 of 7

2.

Run the script file on the destination server to import the jobs.

After you have run the script, the jobs are added under SQL Server Agent\Jobs

Step 4: agenTel configuration

Contact center service

The contact center service uses a system DSN “agenTel60” to connect to the contact center database. Change the DSN to connect to the destination SQL server and change the user

(7)

KB0052

Page 7 of 7 credentials. Verify the database settings for the contact center service in the agenTel

configuration client and change the necessary parameters; name of the DSN (if changed), login name and password.

Campaign management

Check the <connectionStrings> in the Web.config of the campaign management website and modify the settings according the new connection settings for the destination SQL server. The web.config file can be found in the installation folder of agenTel (e.g. C:\Program

Files\Voxtron\agenTel60\Websites\CampaignManagement).

Fax center

Check the <connectionStrings> in the Web.config of the fax center website and modify the settings according the new connection settings for the destination SQL server. The web.config file can be found in the installation folder of agenTel (e.g. C:\Program

Files\Voxtron\agenTel60\Websites\FaxArchivingWebsite).

VPC

This topic is only applicable from agenTel 6.1 onwards. The virtual port connector service uses a system DSN “agenTel60” to connect to the VPC database. Change the DSN to connect to the destination SQL server and change the user credentials. Verify the database settings for the virtual port connector service in the agenTel configuration client and change the necessary parameters; name of the DSN (if changed), login name and password.

Administration center

This topic is only applicable from agenTel 6.1 onwards. Check the <connectionStrings> in the Web.config of the virtual port connector module in the administration center and modify the settings according the new connection settings for the destination SQL server. The web.config file can be found in the installation folder of the administration center (e.g. C:\Programs Files\Voxtron\Administration Center\Modules\VPC60).