I'm going to refer to the source "Internet-Connected server/application" as
MainServer and the one to be updated as RemoteServer. I assume you can't use
MS-SQL Server Database Replication services for some reason. I'm assuming
also that you have some means of taking the data from MainServer and
exposing it to RemoteServer (Either directly or manually). More Assumptions:
Same DB servers, same schema. for some reason you can't create a datasource
on MainServer to reach RemoteServer
Scenario: MainServer contains content that is hosted on a secure intranet.
The Database cannot be accessed by any external system. There is some
machine on the Intranet that can be exposed to the Internet via HTTP or FTP.
MainServer: Create scheduled task to expose each of the server's tables as a
WDDX or XML document. For each table create a file that represents the
results of "SELECT * FROM TableX". Name the file after the table e.g.
Tablex.txt Create a file called Tablex-Length.txt that contains the
character count for the file Tablex.txt. Wherever these files are exposed to
Remoteserver they should be the only "versions" of the tables (this is just
a drop box with the most current table data in it).
RemoteServer: via a scheduled task, retrieves the table data it needs, and
checks each file against the character count in the corresponding
Tablex-Length file. (Idea is to make sure that you've got all the content
you need. Drop the table in RemoteServer, Load RemoteServer with data
retrieved from WDDX/XML document.
this is a general platform independent approach in a simple form. There are
a number of things that could go wrong, and it is jut one such approach. But
I have used this before to help myself out of a few jams.
-Sean
___________________________________________
Sean Brown <[EMAIL PROTECTED]>
http://www.westcar.com/
"Either way you get your dog back"
-Anonymous
___________________________________________
-----Original Message-----
From: Scott Forler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 09, 2000 7:10 PM
To: [EMAIL PROTECTED]
Subject: RE: Updating remote server databases
Hi Sean:
The external Web site is "Read-only".
Scott
>
>
> Is the external Web site "Read-only" or are you facing transactional
> e-commerce type issues?
>
>
> Hello All!
>
> I am looking for ideas and direction for automatically updating a database
> on a remote web server from another Internet-connected server/application.
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
