MicroStrategy ONE

The Project Duplication Wizard

You should always use the Project Duplication Wizard to duplicate your projects. This ensures that all project objects are duplicated properly, and that the new project's schema is identical to the source project's schema.

To duplicate a project:

You must have the Bypass All Object Security Access Checks privilege for that project.

You must be a member of the System Administrator group for the target project source.

You must have the Create Schema Objects privilege for the target project source.

The following high-level procedure provides an overview of what the Project Duplication Wizard does. For an explanation of the information required at any given page in the wizard, see the Help (from the wizard, click Help, or press F1).

High-Level Steps to Duplicate a Project with the Project Duplication Wizard

  1. From Object Manager select the Project menu (or from Developer select the Schema menu), then select Duplicate Project.
  2. Specify the project source and project information that you are copying from (the source).
  3. Specify the project source and project information that you are copying to (the destination).
  4. Indicate what types of objects to copy.
  5. Specify whether to keep or merge configuration object properties if these already exist in the destination project source. For example, if properties such as password expiration and so on are different by default between the project sources, which set of properties do you want to use?
  6. Specify whether you want to see the event messages as they happen and, if so, what types. Also specify whether to create log files and, if so, what types of events to log, and where to locate the log files. By default Project Duplicator shows you error messages as they occur, and logs most events to a text file. This log file is created by default in C:\Program Files (x86)\Common Files\MicroStrategy\.

Scheduling Project Duplication

At the end of the Project Duplication Wizard, you are given the option of saving your settings in an XML file. You can load the settings from this file later to speed up the project duplication process. The settings can be loaded at the beginning of the Project Duplication Wizard.

You can also use the settings file to run the wizard in command-line mode. The Project Duplication Wizard command line interface enables you to duplicate a project without having to load the graphical interface, or to schedule a duplication to run at a specific time. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. You can create an XML settings file, and then use the Windows AT command or the Unix scheduler to schedule the duplication to take place at night.

To Duplicate a Project from the Command Line

After saving the settings from the Project Duplication Wizard, invoke the Project Duplication Wizard executable ProjectDuplicate.exe. By default this executable is located in C:\Program Files (x86)\Common Files\MicroStrategy.

The syntax is:

ProjectDuplicate.exe -f Path\XMLFilename [-sp SourcePassword] [-dp DestinationPassword] [-sup] [-md] [-dn OverwriteName]

Where:

  • Path is the path to the saved XML settings file.
  • XMLFilename is the name of the saved XML settings file.
  • SourcePassword is the password for the source project's project source.
  • TargetPassword is the password for the destination project's project source.
  • -sup indicates that feedback messages will be suppressed (silent mode).
  • -md indicates that the metadata of the destination project source will be updated if it is older than the source project source's metadata.
  • -dn OverwriteName specifies the name of the destination project. This overrides the name specified in the XML settings file.

For information on the syntax for the Windows AT command or a UNIX scheduler, see the documentation for your operating system.