Thanks for sharing your exp Jason Sounds like a plan !
Thanks & Regards Himanshu > On Mar 12, 2014, at 3:17 PM, Jason Miller <[email protected]> wrote: > > ** > Either way should work pretty easy. In the Remedy world a SQL upgrade seems > to be one of the easiest/least painful upgrades encountered. Largely Remedy > doesn't care about the SQL version. AR System more or less uses standard > DBMS functionality and doesn't get into using the more advanced features > where you might really notice a chance between SQL versions. > > We are switching our SQL 2005 DB server(s) for 2012 servers right now. We > just started with our test environment last week. I need to test a little > more (more so validating all of our db linked servers still work) but so far > it is looking good. The DBAs built a new SQL 2012 and restored a db backup > of the 2005 db. All I did was change the db server reference in the ar.cfg > file and the system started right up. > > Besides what I mentioned above we haven't upgraded a system from of 2005 > system to 2012 but we have done 2008 to 2012 and AR System never knew the > difference. I suspect you would see similar results with 2005 to 2012. > > Jason > > >> On Wed, Mar 12, 2014 at 6:48 AM, Himanshu <[email protected]> wrote: >> Hi >> >> Our Current env details are >> >> ARS & ITSM 7.6.04 SP2 >> Win 2003 >> MS SQL 2005 >> >> We are planning to migrate our DB SQL 2005 to SQL 2012 >> >> Please advise if anyone of you have used following method and suggest which >> one will be better >> >> 1) In place upgrade of SQL 2005 to SQL 2012 and than migrate upgraded DB >> 2012 to new DB Server SQL 2012 ( old DB box needs to retire). >> >> 2) Install DB SQL 2012 on new server and than take a backup of Remedy SQL >> 2005 DB and restore on New SQL 2012. >> >> Please share your exp and timeline on DB and OS upgrade with migration to >> new underline infrastructure. >> >> >> Thanks & Regards >> Himanshu Kohli >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
