Re: intranet database communication with internet database

[Ian Skinner <iskinner@xxxxxxxxxxx>]

LeeBC wrote:
>  Hope this is kind of clear.
>
>  Thanks

Not really.

But I think you are asking can one CF server write data to two database 
servers?  The one you use internally on your Intranet and the one you 
use externally on your 'WWW' site.

Then the answer is of course yes, as long as your network allows the CF 
server to create a DNS to the second database server.  You can have a 
ColdFusion application write data to as many database servers as you 
desire to connect it two.  Each one would take its own <cfquery...> 
block, but other then that it is easy to do.

I.E.
<cfquery dsn="internal"...>
   INSERT INTO ...
</cfquery>

<cfquery dsn="www"...>
  INSERT INTO ...
</cfquery>

But this is by no means the only way to do this.  You could also have 
the databases take care of this themselves through replication or 
triggers or some other mechanism where data received by one database is 
pushed to the other.