About the staging database change management

更新: 2009-04-30

This topic describes tasks that you can perform to verify that the data in the staging database is reliable and ready to load to the application database. The specific tasks that you perform depend on your specific needs. You might want to do one or more of the following tasks:

  • Create a new staging database. This might occur after you upgrade to another version of 规划服务器. See Create the staging database.

  • Attach and detach an existing staging database. See Attach or detach an existing staging database for more information:

  • Refresh stored procedures and functions in the staging database to match those of a more current version of 规划服务器 by using the 规划命令实用工具.


    The Refresh command does not copy dimension or model structures of a different application build to the staging database.

During synchronization, the database is automatically updated after one or more dimensions, hierarchies, or models are deleted in 规划业务建模器.

PPSCmd Command Utility Refresh Command

You might decide to restore an older staging database so that you can use it to load data to a more current version of 规划服务器. The RefreshStaging command of the 规划命令实用工具 will restore stored procedures and functions. To learn how to script by using the 规划命令实用工具, see Scriptable data integration.

Database Cleanup

The next time that you synchronize all models after a model, dimension, or hierarchy is deleted, stored procedures will delete the following model tables:

  • related dimension (D_)

  • hierarchy (H_)

  • measure group (MG_)

  • annotation (A_)

  • Nested set (NS_) tables in the staging database

Additionally, related business validation stored procedures are deleted and the foreign key table is updated.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for PerformancePoint Planning Server.