Thanks Sean:
That is a neat solution. Your assumptions fit the situation nicely. I really
appreciate your input!
Scott Forler
> -----Original Message-----
> From: Sean Brown [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 09, 2000 9:24 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Updating remote server databases
>
>
> 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.
------------------------------------------------------------------------------
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.
