[cisco-voip] Historical Reporting Migration

[Rasim Duric]

First of all no simple solution, copy and paste won't work...

 

I had the same requirement when I upgraded from IPCCX 3.5 to 4.0. I
installed 4.0(5) HA on the two new servers and left the old server (3.5)
running for several months just for the Historical reporting. My clients
would connect to the old server if they needed the data before switching
over to 4.5. Since then, we decommissioned the server but I'm still
keeping the old mirrored disk and in case of an emergency (very remote
possibility) we could access the old data too.

 

Another option would be to export your historical 4.x data using the SQL
Server Enterprise Manager to an external DB server for reference.

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_tech_note0
9186a00804a5ddf.shtml

 

 

Rasim Duric

Network Analyst (CCS)

University of Guelph

Guelph, N1G 2W1, ON

519-824-4120x53146

rduric at uoguelph.ca

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Joris Arts
Sent: June-11-08 5:58 AM
To: 'Ratko Dodevski'; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Historical Reporting Migration

 

Hi Ratko,

 

I don't think this is a real option: Upgrade from UCCX (ipcc express) 4.x
to 5 is a new install and does not offer the possibility of migrating
historical data from 4.x to 5.
The database scheme is entirely different.
I heard some claims that it should be possible to extract the data from
the old SQL database and merge with the data in the new database, however
this process sounds not like an easy thing to do.

 

Hope this helps, I would be interested in hearing other opinions.

 

Joris Arts

Speechworks Consultancy

Looiersgracht 78

1016VT Amsterdam

Phone:  +31 (0) 20 6151100

Mobile: +31 (0) 652529442

www.speechworks.nl

 

 

  _____  

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Ratko Dodevski
Sent: woensdag 11 juni 2008 11:25
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Historical Reporting Migration

 

I've allredy set this topic but there were no replays, so sorry but I'll
try again....

This is my question, After I install *IPCC Express 5*, can I just copy 
and paste 
db_cra 
db_cra_repository 
FCRasSvr 
DBs (I think this are the ones that contain Historical Reporting data)
onto 
new server? It's very important for my customer to have the historical
reporting data, and I'm 

not quite sure how to migrate it.
I'm upgrading from *IPCC Express 4* 

 

Ratko

Checked by AVG.
Version: 8.0.100 / Virus Database: 270.2.0/1495 - Release Date: 6/10/2008
5:11 PM

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080611/7a999ebd/attachment-0001.html>