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