Re: Homegrown synchronization

So it looks like the plan is becoming finalized:

The main remaining issue is:

1) Send complete databases for updating of remote and server backend
files
2) Send incremental up to the server and complete down from the server
3) Send incremental updates both ways. Incremental update from the
server is
difficult to determine because there is no baseline database (other
than perhaps
a backup copy of the production backend).

It seems that from a speed point of view, incremental is the way to go.
From a
data latency point of view, full or complete is the way to go. Right
now it's
full database downloaded from the server to the remote PC and
incremental update uploaded
to the server.

While 1) has its appeal, I am concerned about speed. Zipping up the
files helps (factor of 8 to 10 reduction in size) but
I'm just not sure. I also have to consider that the decision that will
be made needs
to be made as a strategic plan and not a "one-off" for this group of
users.

.

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)