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

[Erik Goppel]

Justin,

we have had several bad experiences with DMA, resulting in not being able to
trust DMA as the resource to use in case of upgrades to 6.x
pulling drives or using bars, is exactly what we normally do, however in
this case not.

So if anyone still has some info for me regarding a good way to batch set
the cfwna in ccm 3.3.5 i would be helped greatly.

Thanks,

Erik





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

> 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/52fccb51/attachment-0001.html>