Not in production; we are still exploring different methods of getting our 
7.1/7.0.03 system migrated to 7.5/7.6.  I did not have any problems restoring 
or attaching the ARSystem db from SQL Server 2005 to 2008, but in the one test 
where I tried to return it to 2005 by exporting it, it tripled in size and 
refused to shrink.  My caution would be that while you can get from 2005 to 
2008 without much trouble, don't expect to be able to go back to 2005.

Christopher Strauss, Ph.D.
Call Tracking Administration Manager
University of North Texas Computing & IT Center
http://itsm.unt.edu/
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Louise Van Hine
Sent: Monday, May 03, 2010 10:04 AM
To: [email protected]
Subject: restoring DB from SQL 2005 to SQL 2008

**

Hi List,



Has anyone done a database refresh (restore) from a SQL 2005 instance under the 
covers to a SQL 2008 DB?  BMC is saying that this is not supported, but we have 
done this into our TEST and DEV systems and now have refreshed our DEV with 
production which is still on SQL 2005, and are about to perform the ARS upgrade 
to 7.5 and then ITSM from 7.0.3. to 7.6.



Has anyone done this in a production environment?  So far everything looks 
okay, our CMDB relationship viewer is happy, our consoles are happy, we had a 
bit of a glitch with initially connecting but that was because the 
configuration had a connection setting wrong initially - that got corrected and 
regression tests seem to be passing.



Many thanks for any and all comments,



Louise van Hine

Independent Consultant

[email protected]<mailto:[email protected]>

360-201-7580

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Reply via email to