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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
