Jim,
Do both sites run ColdFusion? One possibility that I've been kicking around
is using CF's WDDX to exchange data between servers via CFHTTP calls.... I
think this model would work:
1) "Extranet" server receives new listing from local LAN users.
2) Listing is inserted into local LAN database
3) Build new listing into an XML packet with CF's WDDX
4) Transfer new listing to a special Web page on Public site via
CFHTTP, which deserializes the XML and inserts the listing into the public
system database.
(include some try/catches to make sure the handshake operates properly)
Now, this sounds a heck of a lot easier than SQL Replication, and if you
only need to basically keep a handful of table up to date, this is the way
to go.
HOWEVER, I haven't yet done this myself. This is just a theory, so I can't
guarantee my understanding of WDDX/XML is perfect.
If you do wind up doing this, let me know... I'd love to hear how it works out.
Brian
At 9:10 PM -0700 2/23/01, Jim McAtee wrote:
> >I've got the following situation:
> >
> >A real-estate company wants us to develop a suite of browser based
> >applications for managing listings, client contact management, billing,
etc.
<snip>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
