<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-CA link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>First of all no simple solution, copy and paste won’t
work...<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Another option would be to export your historical 4.x data using
the SQL Server Enterprise Manager to an external DB server for reference.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><a
href="http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_tech_note09186a00804a5ddf.shtml">http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_tech_note09186a00804a5ddf.shtml</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Rasim Duric<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Network Analyst (CCS)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>University of Guelph<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Guelph, N1G 2W1, ON<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>519-824-4120x53146<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>rduric@uoguelph.ca<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Joris Arts<br>
<b>Sent:</b> June-11-08 5:58 AM<br>
<b>To:</b> 'Ratko Dodevski'; cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] Historical Reporting Migration<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=NL style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Hi Ratko,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=NL style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>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.<br>
The database scheme is entirely different.<br>
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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Hope this helps, I would be interested in hearing other opinions.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Joris Arts</span><span lang=EN-GB style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Speechworks Consultancy</span><span lang=EN-GB style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Looiersgracht 78</span><span lang=EN-GB style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=NL style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>1016VT Amsterdam</span><span lang=NL style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=NL style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Phone: +31 (0) 20 6151100</span><span lang=NL
style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=NL style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Mobile: +31 (0) 652529442</span><span lang=NL
style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=NL style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><a href="http://www.speechworks.nl">www.speechworks.nl</a></span><span
lang=NL style='color:navy'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=NL style='color:navy'> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=NL style='color:navy'> </span><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-US>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b>Ratko Dodevski<br>
<b>Sent:</b> woensdag 11 juni 2008 11:25<br>
<b>To:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> [cisco-voip] Historical Reporting Migration</span><span
lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=NL><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span lang=NL style='font-family:"Verdana","sans-serif"'>I've
allredy set this topic but there were no replays, so sorry but I'll try
again....</span><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=NL style='font-family:"Verdana","sans-serif"'>This
is my question, After I install *IPCC Express 5*, can I just copy <br>
and paste <br>
db_cra <br>
db_cra_repository <br>
FCRasSvr <br>
DBs (I think this are the ones that contain Historical Reporting data) onto <br>
new server? It's very important for my customer to have the historical
reporting data, and I'm </span><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=NL style='font-family:"Verdana","sans-serif"'>not
quite sure how to migrate it.<br>
I'm upgrading from *IPCC Express 4* </span><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=NL> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=NL style='font-family:"Verdana","sans-serif"'>Ratko</span><span
lang=NL><o:p></o:p></span></p>
</div>
<p><span lang=NL style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Checked
by AVG.<br>
Version: 8.0.100 / Virus Database: 270.2.0/1495 - Release Date: 6/10/2008 5:11
PM</span><span lang=NL><o:p></o:p></span></p>
</div>
</body>
</html>