• Article

First-time application migration

Before an exported application can be imported into a destination system for the first time, an application entry must be created in the Planning Administration Console. The application must not be initialized because the migration import will perform the final steps of the creation and initialization.

Create an application entry for a first-time migration

Use the following procedure to create an application entry for a first-time migration.

Note

The label for the newly created application entry must be the same as label of the source application being migrated.

Create an application entry for a first-time migration

  1. Create an application entry in Planning Administration Console. For more information, click Help in the Create an Application dialog box.

  2. Select manual script execution. Four SQL scripts are created:

    • CreateAppDB.sql—creates the application database

    • CreateStagingDB.sql—creates the staging database

    • TypeLibMasterSchema.sql—Loads the initial schema into the application

    • UpdateApplicationsStatusScript.sql—updates the system from “DDL Scripts Prepared” to “DDL Scripts Executed.”

  3. You must run the first three SQL scripts on the SQL Server where the application database resides. Staging database creation is optional. The staging database creation script is provided even if no staging database name was provided in the application creation dialog.

    Note

    The database administrator for the system must perform these steps and run the SQL scripts in the order in which they are listed here.

  4. Run the fourth and final SQL script on the primary Planning Server computer that is running the PPSPlanningSystem database. Note that a SQL Server that has never been used for Planning Server must have some initial setup steps performed by the database administrator. See "Preparing a Computer for an Application Database" in the PerformancePoint Server 2007 Deployment Guide for more information.

  5. Verify that the application status is set to DDL Scripts Executed on the Applications page of the Planning Administration Console.

  6. After the application is in the “DDL Scripts Executed” state, you can perform the migration import.

Perform a migration import

The administrator who performs the migration import must be a global administrator in the target application. For incremental migrations (that is, not a first-time migration), the administrator must also be an application-wide modeler. Use the following procedure to perform a migration import.

Perform a migration import

  • At the command prompt, type:

    ppscmd.exe migrate /import /server http://webservices_server_name:portnumber <destination_folder> \ <application_label> .xml

See Also