Hello Roger, If you HAVE to move up to MS-SQL 2008, it MAY be possible to downgrade the database compatibility levels for those databases that need to be on SQL Server version 2000. The reason I used the word MAY, is that I haven't as yet worked that much on MS-SQL 2008 so am not sure if it would support the stored proceedure that used to be available with earlier versions of MS-SQL servers, that could manipulate the compatibility level of the database. The stored proceedure name is sp_dbcmptlevel and its usage is EXEC sp_dbcmptlevel <database name>, <compatibility level number>; GO The compatibility level numbers are: 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL Server 2008
So lets say the other system that uses SQL Server 2000 and its database name is Accounting, after upgrading the MS-SQL server to 2008, run this statement: EXEC sp_dbcmptlevel Accounting, 80; GO Depending on the size of your database, this will take a few minutes to maybe a few hours to run.. I have used this successfully to run the AR System on a higher version of MS-SQL than the supported version with no problems in the past.. I'd suggest trying this on a test system and having the 'other' application teams to test their systems after the switch to a higher version database, and downgrading their compatibility levels to suit their needs.. Cheers Joe ________________________________ From: Ian Trimnell <[email protected]> To: [email protected] Sent: Friday, August 14, 2009 10:23:58 AM Subject: Re: Upgrade Suggestions ** Nall, Roger wrote: ** ARS 7.1 patch4 >Win 2003 >SQL 2000 > >We are contemplating making the leap to 7.5. Our issue is around having to >upgrade SQL at the same time. Due to constraints of other applications that >share the same database server we have to stay on SQL 2000 or move to SQL >2008. > >In order to keep from having to upgrade both Remedy and SQL at the same time >we are looking at either upgrading Remedy to 7.5 against a SQL 2000 database >or moving the ARsystem database to 2008 and continue to use ARS 7.1. Either >solution would only last for a few weeks before we would get to a final >7.5/SQL 2008 configuration. > >I am looking to see if anyone is either 7.1 against SQL 2008 or 7.5 against >SQL 2000. > >Thanks, > >Roger Nall >Manager, SA Remedy >Desk Phone: 972-464-3712 >Mobile: 973-652-6723 Roger, According to my readings of the compatibility matrix, and with my own experiences during beta testing, 7.5 has to have SQL 2005 or higher. It will not work with SQL 2000. We were running our 7.0.1 server on Win2000 with SQL 2000 and had to upgrade both server and SQL when we upgraded. Hope this helps, Ian ________________________________ Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support & Development, Training & Support Services, Academic & Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741 web: http://www.open.ac.uk/ The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
