The Repository Copy tool enables you to copy the IBM Tivoli Storage Resource Manager repository from one RDBMS instance to another. For example, you can use this tool to copy a repository from an SQL Server instance to an Oracle instance, or from a Cloudscape database to a UDB instance.
A typical scenario for using this tool is if you want to copy a repository from a test environment to a production environment.
To start the Repository Copy tool, perform these steps:
Go to the server/tools subdirectory located in the Install directory.
Execute the repocopy.bat file. A window displays asking you What would you like to do.
Select one of the following options:
Export data from repository tables. Select this option to export data from an existing repository into a comma-delimited file. You must perform an export before you can import repository data to a different Instance/Server. See Exporting Repository Data for more information.
Import data into repository tables. Select this option when you want to import data from an existing comma-delimited file. You must have exported data from an existing repository before you can use this option. See Importing Repository Data for more information.
Click Next. For exports, IBM Tivoli Storage Resource Manager processes the repository table and places its data into a comma delimited file. For imports, data is imported from an existing comma-delimited file.