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

[Justin Steinberg]

right.  you would have to upgrade to 4.1 first.  I've just been either
pulling a drive from the or using a bars backup and restoring the customer
environment in the lab and upgrading to 4.1 where I then run DMA.

What kind of DMA trouble are you having?  I have not really had any trouble
with DMA at all - it has been very good for me.  IT sure beats having to
reconfigure an entire cluster by hand.  Especially when you consider in fast
dials/address book/AC speed dials, etc.

I can understand the split cluster thing for phased migration, although it
does require quite a bit of planning to make sure it goes smoothly.  And
with the phased cutovers, you're right you still have your original problem
which is no built-in BAT capabilities to update cfwdall css....

On Tue, Jul 15, 2008 at 1:27 PM, Erik Goppel <egoppel at gmail.com> wrote:

> 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/4f2873d6/attachment-0001.html>