<div dir="ltr"><div>Justin,</div>
<div> </div>
<div>I don`t see how you would do a DMA from CCM 3.3.5 to 6 without upgrading to 4 first.</div>
<div>And in addition to that, DMA SUCKS , and does not work 9 out of 10 times!!!</div>
<div>(by the way this is a migration to version 6.1)</div>
<div>Besides that, our customer needs to have a phased cutover and introduction of new features, and seeing that a variety of dn`s need to be migrated dynamically from the old cluster to the new cluster, we`ve set up a intercluster trunk between the systems.</div>
<div>people using extension mobility can log into the new system and be called from the old system through the trunk and back.</div>
<div>The only thing that needs to be set in ccm 3.3.5 for this to work, is the cfwna on the dn in the old cluster, in the new cluster you would use a cfwd not registered.</div>
<div>Now we have tested this setup quite intensive, and we just can`t do without having to set <br>the cfwna. seeing that BAT does not do this in ccm 3.3.5<br>so in order to modify 8000 dn`s without having to delete ,update and re-insert the UDP`s and phones and vg248`s,etc...in a live environment, we would rather use a sql update for that.</div>
<div>Now i know how to set the values, however i am not a sql king, and would like to have some help frome someoine, who has a good solution for this.</div>
<div>Maybe updating the sql database using a csv file for reference, or just opening the database and changing it manually.</div>
<div> </div>
<div>So if anyone else can help out here, i would be helped greatly.</div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div>erik</div>
<div> </div>
<div class="gmail_quote">On Tue, Jul 15, 2008 at 6:55 PM, Justin Steinberg <<a href="mailto:jsteinberg@gmail.com">jsteinberg@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div dir="ltr">why not DMA upgrade to CM6 and then use the new and improved CM6 BAT to do this? that is what i do.<br><br>
<div class="gmail_quote">
<div>
<div></div>
<div class="Wj3C7c">On Tue, Jul 15, 2008 at 9:31 AM, Erik Goppel <<a href="mailto:egoppel@gmail.com" target="_blank">egoppel@gmail.com</a>> wrote:<br></div></div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>
<div></div>
<div class="Wj3C7c">
<div dir="ltr"><span><font color="#008000">
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi,</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Currently we are facing a customer migration scenario, where we need to set the Call Forward No Answer of the lines in their old cluster to a specific value.</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">BAT does not cover this functionality in this version, so we need to do some SQL stuff here.</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">What we need is to set the CFWNA for the line, for example:</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1000 needs to have the CFWNA set to 1#1000</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1001 needs to have the CFWNA set to 1#1001</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1002 needs to have the CFWNA set to 1#1002</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">,etc………</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can ayone provide my with some SQL help here to accomplish this?</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We need to do this for around 8000 DN`s, and our migration starts this weekend.</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> </span></font></p>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Many thanks in advance,</span></font></div>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font> </div><font color="#888888">
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Erik</span></font></div></font></font></span></div><br></div></div>_______________________________________________<br>cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div></blockquote></div><br></div>