<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Benny,<br>
<br>
Creating new replication agreements, even in 4.x is dangerous.
Enabling replication on a table creates a new column on the table,
clearly changing the table schema. That schema change frequently
causes row insertion failures. If you use the existing ccm database
publication it is less risky, but still unsupported by Cisco
development or TAC.<br>
<br>
CM5.x and 6.x are appliances - you will have no visibility into the
informix database. You can do some basic queries with 'run sql...'
from CLI or by using 'thin AXL' which allows you to directly execute
SQL commands. You will certainly not be able to setup your own
replication agreement. Nor will you want to, Informix replication has
thus far been the achillies heel of our appliance.<br>
<br>
Your options:<br>
* thin AXL<br>
* 'run sql...." from CLI<br>
* import your nightly backup<br>
<br>
The nightly backup is actually just an export of the database into CSV
format. It is primed for import, text parsing, flat text search, etc.<br>
<br>
/Wes<br>
<br>
Benny Giebens wrote:
<blockquote
cite="mid:1BFA23C9ABCB94458CF57BD0A6BCCBB902F6B268@idefix.Helios-it.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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]-->
<div class="Section1">
<p class="MsoNormal">Dear all.<o:p></o:p></p>
<p class="MsoNormal">We now have a CCM 4.2 under windows server with
SQL 2000.<o:p></o:p></p>
<p class="MsoNormal">We have setup a transaction replication of the
ccm database
to another sql server. On that second server we do queries against the
database
to see who is where an what phones are active and other usefull stuff….<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Now we want to upgrade to ccm 6.0 on linux.<o:p></o:p></p>
<p class="MsoNormal">Anybody knows if the db structure stays the
same, and if
there is still some possibility to do replication to a second sql
server. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Even if the structure is not the same, is there
a way to
extract the data from the ccm 6.0 db to sql on another server on a
continuous
way?<o:p></o:p></p>
<p class="MsoNormal">We have a view where we can see what people are
logged into
extension mobility on witch phone, and this is something we need to do
in the
future…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">PS. We cannot wait to upgrade until a windows
version comes
out, because we want to have voicemail on exchange 2007 asap…<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thnx for any answers….<o:p></o:p></p>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
</body>
</html>