Importing resources – clean up repository before importing

When you migrate runtime repository data from one environment to another (e.g. from the Test repository to the Production repository), you can run the Repository Migration Tool in MIGRATE mode.

When you import resources to a runtime repository, you import the resources from the zip file exported from the source repository. You can specify whether to include resources in all areas (Composer, CompositionCenter, and Security), or in specific areas only.

Note:

You must always include the Security area.

In this mode, all security data and resources in the selected areas (Composer and/or CompositionCenter) are removed from the repository before data is imported from the zip file.

MSSQL examples

Example 7

Importing data to all areas

strs-migrate.bat -d MSSQL -m MIGRATE -n strsDataSP3 -o 1433 -p myPwd -s WMF3K55 -u sa -z C:\strs_data\myDb.zip

 

Example 8

Importing data to the Security and CompositionCenter areas

strs-migrate.bat -a Security|CompositionCenter -d MSSQL -m MIGRATE -n strsDataSP3 -o 1433 -p myPwd -s WMF3K55 -u sa -z C:\strs_data\myDb.zip

 

Oracle examples

Example 9

Importing data to all areas

strs-migrate.bat -d ORACLE -i abc321 -m MIGRATE -n strsDataSP3 -o 1521 -p myPwd -s salma -u sys -z C:\strs_data\myDb.zip

 

Example 10

Importing data to the Security and CompositionCenter areas

strs-migrate.bat -a Security|CompositionCenter -d ORACLE -i abc321 -m MIGRATE -n strsDataSP3 -o 1521 -p myPwd -s salma -u sys -z C:\strs_data\myDb.zip

 

Forcing data into the runtime repository

By default, Repository Migration Tool will only import rows with primary keys that do not already exist in the runtime repository. This means that only new rows may be inserted, and no data will be overwritten. If you want to overwrite data in the runtime repository, you can use the -f (--force) parameter.

Example 11

Forcing data into a runtime repository (MSSQL)

strs-migrate.bat -d MSSQL -f -m MIGRATE -n strsDataSP3 -o 1433 
-p myPwd -s WMF3K55 -u sa -z C:\strs_data\myDb.zip

 

Example 12

Forcing data into a runtime repository (Oracle)

strs-migrate.bat -d ORACLE -f -i abc321 -m MIGRATE -n strsDataSP3 
-o 1521 -p myPwd -s salma -u sys -z C:\strs_data\myDb.zip