[cisco-voip] Help wanted on Callmanager 3.3.5 SQL query (URGENT!!!)

[Erik Goppel]

Justin,

I don`t see how you would do a DMA from CCM 3.3.5 to 6 without upgrading to
4 first.
And in addition to that, DMA SUCKS , and does not work 9 out of 10 times!!!
(by the way this is a migration to version 6.1)
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.
people using extension mobility can log into the new system and be called
from the old system through the trunk and back.
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.
Now we have tested this setup quite intensive, and we just can`t do without
having to set
the cfwna. seeing that BAT does not do this in ccm 3.3.5
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.
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.
Maybe updating the sql database using a csv file for reference, or just
opening the database and changing it manually.

So if anyone else can help out here, i would be helped greatly.

Thanks,

erik

On Tue, Jul 15, 2008 at 6:55 PM, Justin Steinberg <jsteinberg at gmail.com>
wrote:

> why not DMA upgrade to CM6 and then use the new and improved CM6 BAT to do
> this?  that is what i do.
>
>   On Tue, Jul 15, 2008 at 9:31 AM, Erik Goppel <egoppel at gmail.com> wrote:
>
>>   Hi,
>>
>>
>>
>> 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.
>>
>> BAT does not cover this functionality in this version, so we need to do
>> some SQL stuff here.
>>
>>
>>
>> What we need is to set the CFWNA for the line, for example:
>>
>> DN 1000 needs to have the CFWNA set to 1#1000
>>
>> DN 1001 needs to have the CFWNA set to 1#1001
>>
>> DN 1002 needs to have the CFWNA set to 1#1002
>>
>> ,etc………
>>
>>
>>
>> Can ayone provide my with some SQL help here to accomplish this?
>>
>> We need to do this for around 8000 DN`s, and our migration starts this
>> weekend.
>>
>>
>>
>>
>> Many thanks in advance,
>>
>> Erik
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080715/7c84de7e/attachment.html>