RE: GP and management reporter upgade
Hi,
12GB definitely seems a large size for an MR database, and it's likely that it holds several thousands of report generations.
The big question remains (as in every upgrade process): How much data are you willing to forgo and lose vs. the time it takes to tackle the upgrade.
One of the simpliest and most straightforward upgrade is to export all the definitions from the old CU12 setup and then import them into a fresh built CU16 environment.
You're simply going to lose the history of all generated reports, which most of the companies don't care anyway, and you'll have to re-do the user security around the companies and report library.
If you still plan to go the upgrade route (and I agree that 2+ hours is not normal, unless you have some bottlenecks on your SQL server), then you should try to slim down the amount of historical data from the existing MR Cu12 before trying to upgrade.
I recently did an upgrade for a client in the same situation, with a CU14 or CU15 setup, and 12GB of data in MR, which turned out to be all the report generation for the last 4-5 years..
After removing 80% of the historical reports, the size went down to 2-3GB and the upgrade was done in no time.
Be aware that there are much larger MR databases out there (I've seen up to 50+GB), but that isn't the norm. IMHO MR wasn't designed to handle that much of historical data and there are some design flaws in it, like the lack of a built-in policy for report retention, which would allow for an automatic deletion of old reports if that is needed. Instead, you have to manually open each single report to lookup the history and select the version you don't want to keep.. a rather mudane process.
Share
Report
267
All responses (
Answers (
