One thing to keep in mind is that the Licenses are now stored in the database (since v7.1.0). Make sure that Production has ALL the server licenses listed (so when you restore to Test or Dev the system will not complain about licensing).
We have Dev, 2 Test, and Production systems and Migrator (All home grown apps. No BMC suites). We find we only need to do a prod refresh about once a year. Our release cycles are every other month as we give the users a 2 week UAT (User Acceptance Test) period in addition to our 2 week test cycle. Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Nicky Madjarov Sent: Friday, May 15, 2009 8:08 AM To: [email protected] Subject: Re: Adding a Test server to our Prod and Dev Environment - Best way to sync Test? Susan, The most effective way, in my opinion, is to restore a copy of the prod db, then masage the data and start the test ar services. It will have all the data from prod, well loaded system takes about 4-6 hours to restore, and then you do the data masaging, that can be scripted as sql and runs for less than a minute. It may sound extreme, but it is the only clean way to find how particular release will affect the production environment. Because this is labor/resource intensive operation you may consider establishing a release cycle, say 2x a month. This will help you to have everything well organized and properly planned. Of course, nothing is bullerproof. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com ----- Original Message ----- From: Susan Palmer <mailto:[email protected]> Newsgroups: public.remedy.arsystem.general To: [email protected] Sent: Thursday, May 14, 2009 10:38 PM Subject: Adding a Test server to our Prod and Dev Environment - Best way to sync Test? Hi Everyone, We are actually (finally) moving to a Sun Solaris 10 environment. Dev server is built and in use. Prod server almost done and will be in production the weekend of 5/30 !! We'll have a BIGIP to two prod servers, one active and one as a failover if needed. Two Oracle 10g databases using dataguard to keep insync. We even will have dev and prod Crystal Report Servers (not sure I see the value to a dev but it completes the picture). The next step is inserting a Test server(s) into the mix. It's almost overwhelming to go to such a 'full' environment. It brings with it some process changes that are challenging. I'd like some feedback on best methods you've come across. 1. How do you keep the Test server database reasonably current reflecting the Production database? Is there a way to do this without intervention to clean server names or manually migrate data? 2. Do any of you have a situation where the production operations group is responsible for moving all enhancements from Test to Production and they are not Remedy trained? We do have migrator but there are some inherent problems with using it when Forms you migrate have Audit or Archive forms. Not sure if this was just a windows problems but had several situations of corrupted data in the past. Any advice is welcome. Thanks, Susan ARS v7.0.1P2 Sun Solaris 10 Oracle 10gr2 Susan Palmer ShopperTrak RCT Corporation 200 W Monroe St 11th Floor Chicago, IL 60606 Office 312-529-5325 Cell 312-502-7687 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
