Thanks to everyone that responded ... there was some very useful information!
Susan On Fri, May 15, 2009 at 9:15 AM, Guillaume Rheault <guilla...@dcshq.com>wrote: > ** > > I am in favor too of the database copy from production to test and even > development. > Copying a database between servers with Oracle is simple, your DBA should > not have any problem with that. > > The other reason why I think that having a copy of production in dev and > test is to make sure that the application performs well with large amounts > of data, which means among other things that the appropriate indexes are > providing the expected performance benefits. > > I am not a big fan of Migrator, I rather use the Admin tool (and now the > Developer Studio) to migrate workflow. However, I have found that Migrator > is useful tool to compare environments and produce difference reports. > > -Guillaume > > -----Original Message----- > From: Action Request System discussion list(ARSList) on behalf of Nicky > Madjarov > Sent: Fri 05/15/09 9:07 AM > To: arslist@ARSLIST.ORG > 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 <http://www.speedupars.com/> > ----- Original Message ----- > From: Susan Palmer > Newsgroups: public.remedy.arsystem.general > To: arslist@ARSLIST.ORG > 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 > > > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > > _Platinum Sponsor: rmisoluti...@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"