Misi,
Thanks for your help on this. What I am trying to do is migrate from one
production database to another. We have an existing prod server that has a
broken installation. In order to install Asset Management we need to
perform a re-install into a new prod. The new installed db has additional
records in it that I do not want to be deleted when I migrate the data.
Here is an outline of what I am trying to do:
1. Take OLD PROD backup. Users still active.
2. rrrchive using COPY from OLD PROD backup 1 -- NEW PROD
(this is actually several steps breaking down into config vs data, takes a
few hours)
3. Take another OLD PROD backup. OLD PROD put into Admin only mode.
4. rrrchive using SYNCTOTARGET from OLD PROD backup 2 -- NEW PROD
(to migrate only updated records)
The goal of the last step is to capture data changes since the first
backup. This would require a production outage, but the down time will be
much smaller than if we were to copy all of the data.
I cannot just restore the old prod db to new prod because I am fixing the
install including workflow. This is the best solution I have come up with.
Any thoughts?
Again, thanks for your help.
Chuck Baldi
On Thu, Sep 3, 2009 at 9:29 AM, Misi Mladoniczky m...@rrr.se wrote:
Hi,
Up till now, there has been no way to do this. I have updated the tool in
accordance with your suggestion, to allow setting
syncmaxdeletedpercent=0, which disable the delete-operations.
Please note that the SYNCTOTARGET-setting will restore any inconsistent
records from the source to the target. Regardless of which one has been
modified after the last SYNC-operation.
If you add new records to source and target server, the
target-server-records will be overwritten.
The only thing you disable is the deletion of surplus records.
Please describe in some more detail what you want to do.
Is this how you want to do it:
1. PROD - TMP
2. Turn of PROD (admin-only-mode?)
3. Mess around with TMP-server
4. TMP - PROD
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
Hello,
Has anyone used rrrchive to synchronize one ARS database with another,
but
not delete records on the target database? I want to use SYNCTOTARGET to
get updated records, but I don't want to delete any records on the target
database.
I am trying to come up with a way to migrate a full ITSM production
install
and data to another database (needed to fix install errors.) I want to
use
SYNCTOTARGET so I can do most of my migration off-line and then do a
catch-up migration at the end of the day with only a small outage.
Any advice is appreciated.
Regards,
Chuck Baldi
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum
Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist:
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:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist:
Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
