Re: Replication newbie question(s)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I actually have a couple of databases, each about 30 Meg. But, the main
thing is that this app is for a client that is VERY non-technical so I do
not want them doing ftp's nor terminal server type connections. Also, I do
not want them to have any ability to remote in to the web server since it is
a production server with several other clients running on the same box.

I have actually been using a class I wrote a couple of years ago using
wininet and can selectively synchronize tables programically using XML to
securely transfer differential data over http. I plan to port this into a
service that can do periodic remote data synchronizations. It uses SSL so
the data is secure in transit. If there is any interest, maybe I'll post the
sources.

Swheeler


"jacksonmacd" <jackMACmacdo0nald@xxxxxxxxx> wrote in message
news:dqohp1lir7i6sc53062cja19d5tdncfg08@xxxxxxxxxx
> It's true that the replication transfer would be incremental if you
> implemented indirect sync. Probably the same with Internet sync, but
> as David points out, it's an extra layer (or several...) of
> complexity. I've only tried it once, and gave up in frustration.
>
> What constitutes "quite large"?
>
> On Wed, 7 Dec 2005 23:18:00 -0500, "SteveW" <swheeler@xxxxxxxxxxxxxx>
> wrote:
>
>>I could. But, the file can be quite large and the differential changes are
>>much smaller. I am kind of assuming that a replication will be a
>>differential and so generate much less traffic. I could write some logic
>>that would dump the daily changes to xml and do an insert on the "shadow"
>>side, I am just trying to minimise coding. Right now I do an export to CSV
>>and a manual download and import but it is error prone and requires some
>>labor on the part of the user.
>>
>>
>>
>>"jacksonmacd" <jackMACmacdo0nald@xxxxxxxxx> wrote in message
>>news:8b7fp150l97b5ov0vqg0l1sc1asjcimnib@xxxxxxxxxx
>>> If you are using the shadow only for reporting, why not forgo
>>> replication entirely, and simply copy the file once per day?
>>>
>>> On Wed, 7 Dec 2005 14:48:38 -0500, "SteveW" <swheeler@xxxxxxxxxxxxxx>
>>> wrote:
>>>
>>>>Hi -
>>>>I originally posted to public.access, but this sound like the right
>>>>place
>>>>for my question.
>>>>
>>>>This has already been addressed, sort of, but I could not find exactly
>>>>what
>>>>I am looking for.
>>>>
>>>>I have a low traffic web site with an access 2003 db behind it. I now
>>>>need
>>>>to somehow
>>>>synchronize the live production data to a "shadow" database via http and
>>>>the
>>>>internet. The shadow will be used for reporting and only needs to be
>>>>synchronized with the master once a day. I do not have Replication
>>>>Manager
>>>>and do not know how / where to get it. I am
>>>>interested in using something like JRO to set up a scheduled daily
>>>>synchronization
>>>>or replication across the web using http. Any suggestions on how to best
>>>>do
>>>>this? I can roll my own with say wininet and c++ or vb but if I want to
>>>>minimize my coding effort.
>>>>
>>>>Also, all the MS documentation seem to imply Replication Manager is
>>>>necessary for inet synchronization - is this necessary? My web
>>>>server is 2K server with IIS 5.
>>>>Thanks
>>>>SWheeler
>>>>
>>>
>>> **********************
>>> jackmacMACdonald@xxxxxxxxxxxxxx
>>> remove uppercase letters for true email
>>> http://www.geocities.com/jacksonmacd/ for info on MS Access security
>>
>
> **********************
> jackmacMACdonald@xxxxxxxxxxxxxx
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security


.

Relevant Pages

  • Re: How can implement these simple scenario
    ... > Client X wants specific data be download to use/modify offline. ... > changes will then be merged back with the server. ... transactional replication or merge. ... > How do I poll the merge agent on the client to know how many transaction ...
    (microsoft.public.sqlserver.replication)
  • RE: server/connectcomputer from remote offices
    ... I have a replica w2k3 std server config'd as a dc in location B ... I have a number of client workstations in Location B ... We can connect the workstations in Location B to the sbs domain with no ... I have enabled replication of the clients share ...
    (microsoft.public.windows.server.sbs)
  • Re: Help with these scenarios
    ... Looking for a SQL Server replication book? ... > Client X wants specific data be download to use/modify offline. ... > download locally (pull, on demand) and disconnect. ...
    (microsoft.public.sqlserver.replication)
  • passwd on Solaris and iPlanet LDAP single master with replicas
    ... We have a single master LDAP server ... Replication works. ... According to the system administration guide the consumer server does ... The client must follow the referral ...
    (comp.unix.solaris)
  • passwd on Solaris and iPlanet LDAP single master with replicas
    ... We have a single master LDAP server ... Replication works. ... According to the system administration guide the consumer server does ... The client must follow the referral ...
    (comp.sys.sun.admin)