Guys,
We have a SQL Server 7 implementation with three CF servers using it as a
database server.
The problem is that it's falling over regularly (and the technical guys
can't figure it out).
That's not the problem though. We are now setting up a second SQL Server 7
for use as a failover. It will replicate all of the data. My boss wants to
know if it is possible for CF to use one or other of the database servers
depending on what is up!
So the idea is:
For each query - check which server is up and choose one to use (assuming we
can replicate all data)
This doesn't make very much sense to me (it's not my idea, I just got asked
to ask the list) as I would do it differently anyway!
So situation (again)
2 SQL servers
Q: can we replicate the data so they effectively are the same?
2 CF Server
Q: without having to change EVERY <cfquery> can we make something that will
use one or other to retrieve data depending on which one is up.
Is this possible?
Paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
