We are currently updating remote database servers from Orange County, CA to
PSI in Virginia. We are going through the internet. I do not recommend
this approach if your databases are large. Going through the internet is
slow, sometimes time outs, and gets corrupt If a router goes down
somewhere, you out of luck.
I have recommended a Private Virtual Circuit to upper management, but the
cost was too much. I have to deal with what I have.
SQL does a great job of remote updating, but I recommend a infrastructure
to support it.
Jacob
At 10:57 AM 5/9/00 -0500, you wrote:
>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.
>
>All of the CF sites I have developed so far have been pretty straight
>forward from a database creation perspective. Data is entered into the web
>server database through a CF form on the same server. However, we are seeing
>more need to display information on the Web that has been created somewhere
>else.
>
>For example, ABC Corp. has an custom application on their internal system
>that is used by their employees to enter customer information. They would
>like to make this information available to their customers via the Web. For
>cost and administration reasons they want to use an external shared server
>to run the Web application. On their internal system they can put the
>information in just about any format (native format is DB4) and are
>flexible. We can use Access or MSQL on the shared NT web server. Response
>time is an issue but the volume of accesses will be low.
>
>My question is: What options (benefits/drawbacks) are there for
>automatically uploading the information from the internal server to the
>external Web server database through the Internet? In your opinion, what is
>the best way?
>
>Thanks,
>
>Scott Forler
>
>
>PrairieWeb Internet Marketing, Inc.
>Web Development and Marketing
>
>------------------------------------------------------------------------------
>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.
