On May 30, 2008 Microsoft released a data migration tool for PerformancePoint Planning (free download). Although it was possible to migrate a Planning application using PPSCMD, it was only possible to migrate the application objects (dimensions, models, security etc.). The fact and reference data had to be migrated manually. For example once you have set up your test or dev environment you may want to migrate the fact and reference data to the production server. Below is a link to the download and the documentation.
- PerformancePoint Server 2007 Planning Data Migration Tool
- Data Migration Tool Overview
- Migrating Planning Data from a Test Environment
I am not sure what level of preparation is required with the new tool. Hopefully it is as simple as taking a backup of the StagingDb from the Source Application and restoring the database in the Destination environment. Once the database is restored in the new environment you can register it with the new application. At this point the tool can take care of the migration. Make sure you review the Migrating Planning Data from a Test Environment on the Tech Net site before trying out the tool.
I should get an opportunity in the next couple of months on my current project to try the tool out.
Troy
performance point
business intelligence
sql server 2005
2 comments:
Hi, I've one question and excuse me if I'm being dummy but this Tool shouldn't have Source Planning Server address and Destination Server address? I mean, suppose I'm a App Model already tested on my laptop (dev env.) and I want to migrate it into Client's production Environment, this tool should have a box for me to specify the Source System (my laptop) and the Destination System (client's Server). I'm just confused, witch server address is now available in the Data Migration Tool? Many thanks (Bruno Ferreira b23ferreira@hotmail.com)
Hi Bruno,
This is a good question.
Although the data migration tool does simplify the data migration process you still have to manually back up you staging db from one server (e.g. dev) and then restore the database in the other server environment (e.g. production). Check out this post from the Microsoft PerformancePoint Team:
http://blogs.msdn.com/performancepoint/archive/2008/06/02/performancepoint-server-2007-planning-data-migration-tool.aspx
Troy
Post a Comment