Hi,
You could also use DSO, the API or RRR|Chive (free tool) to keep the
servers up to date.
If you use RRR|Chive, you would first index the Modify-Date-field on the
forms that needs replication, and then create a config file that looks
something like this:
source_server = production
source_user = Demo
source_password =
target_server = report
target_user = Demo
target_password =
multipleforms = \
SHARE:Company, \
SHARE:Account, \
SPRT:Product_Owned, \
SHARE:Person, \
SHARE:Contact_base, \
SHARE:Employee_base, \
SPRT:Issue
qual = '6' > $TIMESTAMP$ - 2*24*60*60
transfertype = SYNCTOTARGET
skipattachments = YES
logfile = rrrchive.log
loglevel = ERR
Run RRR|Chive every minute, hour or day depending on your needs. Most
reporting needs will probably not require todays data. If it does, you may
be able to direct these reports to the productions server directly.
The above config skips attachments and copy any record not already copied
that has been change during the last 2 days.
Once in a while you may also want to run a qual=(1=1) session once in a
while to remove any records that may have been deleted from the production
server.
Best Regards - Misi, RRR AB, http://rrr.se
> Some in our company want to use database replication to copy production
> to a report server. This means that we would have two separate
> instances of remedy on separate databases.
>
> I went through a little work of trying this a while back but we had
> trouble with performance and the database replication did not like the
> Request Id field as the unique identifier. I don't remember the
> specifics it has been a little while back.
>
> We need to have both servers up at all times for reporting needs and
> live production system.
>
> Has anybody ever done something like this?
> If so what platform and apps did you use to do the transfer?
>
> I just want to make sure that someone has done this before so that I
> know that it can be done.
>
> Darrel
>
> This email may contain material that is confidential, privileged, and/or
> attorney work product for the sole use of the intended recipient. Any
> review, reliance, or distribution by others or forwarding without express
> permission is strictly prohibited. If you are not the intended recipient,
> please contact the sender and delete all copies.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
