<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>We used to do something like this and take advantage of the
database applications on the CallManager servers. However, since they introduced
the concept of the shared key between the servers, we were not able to get this
working again. No amount of troubleshooting with our local SQL expert was able
to help. Eventually we had to drop the idea of using the push/pull subscription
and use export/import scripts to replicate the table on the other server. If
your database is not that large and doesn't see that many changes, you could
probably get away with running the script every hour.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>That being said, the TAC does not like you adding your own
database on CallManager servers and may infact as you to delete it if they see
any problems arise. So were were told. </FONT></DIV>
<DIV> </DIV>
<DIV>--------------------------------------------------------------------------------<BR>Lelio
Fulgenzi, B.A.<BR>Network Analyst (CCS) * University of Guelph * Guelph, Ontario
N1G 2W1<BR>(519) 824-4120 x56354 (519) 767-1060 FAX
(JNHN)<BR>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<BR>"I had a coffee and Coke at lunch today...and now, I've got more jitter than
an<BR>IP phone on a long haul 10base2
connection"
LFJ</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ciscozest@gmail.com href="mailto:ciscozest@gmail.com">Robin H</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, December 09, 2005 7:42
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [cisco-voip] Automatic Sql DB
copied from Subscriber to Publisher</DIV>
<DIV><BR></DIV>I need to setup two IVR servers and I plan to store a
special-time database (a new table) on CallManager Servers (using Sql).
Normally I only create the script to query DB from single server ie:
subscriber. But if the subscriber server down, the ivr won't able to give
correct prompts. Is there a way I can make that sql db/table to be copied over
to another server so that I still have redundancy. Thank you.
<P>
<HR>
<P></P>_______________________________________________<BR>cisco-voip mailing
list<BR>cisco-voip@puck.nether.net<BR>https://puck.nether.net/mailman/listinfo/cisco-voip<BR></BLOCKQUOTE></BODY></HTML>