Hi, I have done this many times myself using the following procedure: 1. Install a clean new version of the AR Server on your new machine 2. Export/import def-files 3. Use rrrChive to move all data from your old machine to the new machine 4. Test the new machine 5. Do a SYNC-operation using rrrChive 6. Set your old server in admin-only-mode and turn off escalations 7. Do another SYNC with rrrChive 8. Swithch your users to the new machine (change a dns-entry?)
The last two steps should take no more than 30 minutes or so if you plan well. This is the total time that your system needs to be offline from your users. It also gives you ample time to do thorough testing. Another benefit is that the time to revert back to the old machine if something goes wrong is zero. RRR|Chive download and configurator: https://www.rrr.se/cgi/rrrchive/main This config should should do the trick: source_server = production source_user = Demo source_password = target_server = newprod target_user = Demo target_password = target_disabledeletefltr = YES target_disablemergefltr = YES multipleforms = * splitsearch = YES transfertype = SYNCTOTARGET logfile = AUTO progressbar = YES Another good tool for finding data differences between the old and new System Forms are rrrDefFieldDiff: https://www.rrr.se/cgi/tools/main#rrrDefFieldDiff Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > ARS 7.1 patch4 > SQL2k > WIN2003 > > We are going to be upgrading to ARS 7.5 patch 7 and SQL 2008 at the same > time. All hardware will be new. I am looking for suggestions on how to > handle the change in ARS and SQL at the same time. Any help would be > appreciated. > > Thanks, > > Roger Nall > Manager, SA Business Intelligence/Remedy > Desk Phone: 972-464-3712 > Mobile: 973-652-6723 > > Helpful Links: > | Reports<http://bi.eng.t-mobile.com:8080/InfoViewApp> |SA_Suggestion > Box<http://saintake.t-mobile.com/> | SA_Trouble > Ticket<http://natweb.eng.t-mobile.com/sites/TTWeb/CreateTicket.aspx> | > > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"