You should be able to upgrade the SRM database to 9.0 w/o losing data so long as the "separate servers" are not a different OS from what I understand. That is supported.
My recommendation is to make a copy of the SRM database ~/mysql/data/reporting/*, do an install of 9.0.0, copy over the saved database into the new 9.0.0 ~/mysql/data/reporting/ directory, and then do an install of the latest 9.1.x hotfix. The latest hotfix/minor rev has to do a migration of the database to the new mysql version, though, so make sure you have at least double the space of the largest file under ~/mysql/data/reporting/ directory as it creates a tmp file while migrating. This is the way I did it, but you may be able to skip the 9.0.0 installation somehow that somebody might be able to chime in on. Brad -----Original Message----- From: Page, Jonathan [mailto:[email protected]] Sent: Tuesday, September 01, 2009 8:30 AM To: spectrum Subject: [spectrum] 8.1 to 9.0 DDMdb Question I working on upgrading my Spectrum 8.1 servers to 9.0 which will be on separate servers. I have come to the conclusion there is no CA supported way of moving over my Reporting database from 8.1 Report Manager to 9.0. I was looking on increasing the size of my DDmdb to 4 GB and increase my event history to 90 days and remove my stat history. The information on how to do this was provided by CA. When I obtain 90 days of data I was going to import the DDmdb into the new server and install Spectrum 9.0 on top of the database. I was told the 9.0 already has a capacity of 4 gigs for its DDmdb so it should move over smoothly. Has anyone had issues with increasing the size of the DDmdb to 4 GB in 8.1 and migrating this over to 9.0? Thanks for any advice or suggestions you can provide me. --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
