I’ve got a poor neglected XI R1 BOE install, that I’ve never had time to upgrade (cause it looks like I’d be pretty much having to start over with a new server). Now my DBA wants to upgrade the sql server that the cms is on. I’ve got a couple questions and since R1 is eof, I assume SAP won’t give me the time of day.
Has anyone run a XIR1 CMS on sql 2005 or in compatibility mode?
Its not on the platform list (but i think R1 was released before sql 2005 was available) Most applications I support work fine with either, even if they were built before 2005’s release.
In general, can we upgrade CMS dbs independent of BOE? The documents I’ve seen make it sound like you have to create a new db, and use the ccm to ‘copy data from another data source’. What would happen if we just upgrade the sql server in place?
Hi Zann,
We had up until approximately a year ago an installation of R1 that was running happily on SQL 2005 and from memory the CMS DB was created in SQL 2005 with DB standard settings so you shouldn’t need the compatibility mode.
As long as the ODBC DSN retains the same name, the upgrade to 2005 should be transparent to BOE.
Of course, before the upgrade takes place you should take the CMS down, get a DB backup done within SQL 2000 and backup your filestore etc then when the DB is back up in 2005 the CMS should connect to it upon startup.
THANK YOU SO MUCH for your reply. Its really helpful to know someone else’s real life experience.
We do have a test server and prod, so I will be able to test it first. And I’ve learned over the years, you can never have too many backups, so yes there will be a backup of the db.
(BOB member since 2008-09-26)