<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:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns1="http://schemas.microsoft.com/office/2004/12/omml">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--a:link
{mso-style-priority:99;}
span.MSOHYPERLINK
{mso-style-priority:99;}
a:visited
{mso-style-priority:99;}
span.MSOHYPERLINKFOLLOWED
{mso-style-priority:99;}
p
{mso-style-priority:99;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Calibri;}
@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";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{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";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle19
{mso-style-type:personal;
font-family:Calibri;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@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-GB link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thanks for shown interest…. Yes I’ve
read this before and I have it on my mind, but… I’m not quite sure
will it work. As Joris said 4x is very different from 5 and it seems like there
is nothing on cisco site about this kind of data migration. Also I don’t
know exactly how to import the historical reporting data in UPCCX 5. I found
some commands for importing, but I’m not quite sure. This is what chapter
13 from Cisco Customer Response Solutions Administration Guide, Release 5.0(1)
says:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>You can import the data from these files
into the historical database by running <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>the osql command for all data files in the
wfavvid\SQLData directory.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The syntax for the osql command is:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>osql -E -S <server>\CRSSQL -i
<datafilename><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Do you think that this would do the
thing????? I’m hoping that someone would try this before me, and let me
know :)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Ratko.<o:p></o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
Rasim Duric [mailto:rduric@uoguelph.ca] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, June 11, 2008
4:01 PM<br>
<b><span style='font-weight:bold'>To:</span></b> 'Joris Arts'; 'Ratko
Dodevski'; cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [cisco-voip]
Historical Reporting Migration</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>First of all no
simple solution, copy and paste won’t work...<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;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></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;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></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;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></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Rasim Duric<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>Network Analyst
(CCS)<o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:PlaceType w:st="on"><font size=2
color="#1f497d" face=Calibri><span lang=EN-CA style='font-size:11.0pt;
font-family:Calibri;color:#1F497D'>University</span></font></st1:PlaceType><font
size=2 color="#1f497d" face=Calibri><span lang=EN-CA style='font-size:11.0pt;
font-family:Calibri;color:#1F497D'> of <st1:PlaceName w:st="on">Guelph</st1:PlaceName></span></font></st1:place><font
size=2 color="#1f497d" face=Calibri><span lang=EN-CA style='font-size:11.0pt;
font-family:Calibri;color:#1F497D'><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=2
color="#1f497d" face=Calibri><span lang=EN-CA style='font-size:11.0pt;
font-family:Calibri;color:#1F497D'>Guelph</span></font></st1:City><font
size=2 color="#1f497d" face=Calibri><span lang=EN-CA style='font-size:11.0pt;
font-family:Calibri;color:#1F497D'>, <st1:PostalCode w:st="on">N1G 2W1</st1:PostalCode>,
<st1:State w:st="on">ON</st1:State></span></font></st1:place><font size=2
color="#1f497d" face=Calibri><span lang=EN-CA style='font-size:11.0pt;
font-family:Calibri;color:#1F497D'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>519-824-4120x53146<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'>rduric@uoguelph.ca<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 color="#1f497d" face=Calibri><span lang=EN-CA
style='font-size:11.0pt;font-family:Calibri;color:#1F497D'><o:p> </o:p></span></font></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Joris Arts<br>
<b><span style='font-weight:bold'>Sent:</span></b> June-11-08 5:58 AM<br>
<b><span style='font-weight:bold'>To:</span></b> 'Ratko Dodevski';
cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [cisco-voip] Historical
Reporting Migration<o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-CA
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=NL
style='font-size:10.0pt;font-family:Arial;color:navy'>Hi Ratko,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=NL
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;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></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hope this helps, I would be interested in
hearing other opinions.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Joris Arts</span></font><font color=navy><span
style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Speechworks Consultancy</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Looiersgracht 78</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=NL
style='font-size:10.0pt;font-family:Arial;color:navy'>1016VT Amsterdam</span></font><font
color=navy><span lang=NL style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=NL
style='font-size:10.0pt;font-family:Arial;color:navy'>Phone: +31 (0) 20
6151100</span></font><font color=navy><span lang=NL style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=NL
style='font-size:10.0pt;font-family:Arial;color:navy'>Mobile: +31
(0) 652529442</span></font><font color=navy><span lang=NL
style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=NL
style='font-size:10.0pt;font-family:Arial;color:navy'><a
href="http://www.speechworks.nl">www.speechworks.nl</a></span></font><font
color=navy><span lang=NL style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
lang=NL style='font-size:12.0pt;color:navy'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Times New Roman"><span
lang=NL style='font-size:12.0pt;color:navy'> </span></font><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Ratko Dodevski<br>
<b><span style='font-weight:bold'>Sent:</span></b> woensdag 11 juni 2008 11:25<br>
<b><span style='font-weight:bold'>To:</span></b> cisco-voip@puck.nether.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [cisco-voip] Historical
Reporting Migration</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=NL
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face=Verdana><span lang=NL style='font-size:
12.0pt;font-family:Verdana'>I've allredy set this topic but there were no
replays, so sorry but I'll try again....</span></font><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face=Verdana><span lang=NL style='font-size:
12.0pt;font-family:Verdana'>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></font><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face=Verdana><span lang=NL style='font-size:
12.0pt;font-family:Verdana'>not quite sure how to migrate it.<br>
I'm upgrading from *IPCC Express 4* </span></font><span lang=NL><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=NL
style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face=Verdana><span lang=NL style='font-size:
12.0pt;font-family:Verdana'>Ratko</span></font><span lang=NL><o:p></o:p></span></p>
</div>
<p><font size=2 face=Arial><span lang=NL style='font-size:10.0pt;font-family:
Arial'>Checked by AVG.<br>
Version: 8.0.100 / Virus Database: 270.2.0/1495 - Release Date: 6/10/2008 5:11
PM</span></font><span lang=NL><o:p></o:p></span></p>
</div>
</body>
</html>