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 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.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.netARSlist:
> "Where the Answers Are"
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"