Artículo
06/14/2010

About the staging database change management

Actualizado: 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 Planning Server. 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 Planning Server by using the Herramienta de comando de planeación.

Nota

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 Planning Business Modeler.

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 Planning Server. The RefreshStaging command of the Herramienta de comando de planeación will restore stored procedures and functions. To learn how to script by using the Herramienta de comando de planeación, 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: