Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


HOW TO: Upgrade from old PowerCenter Repository Database to New Database

To upgrade from old PowerCenter Repository Database to a new database, do the following:

  • Login to Administration Console.
  • Stop all Integration Services in the repository.
  • Backup the repository.
  • Stop the Repository Service.
  • Configure the Repository Service to connect to the new database (Properties > Database Properties).
    Update the connect string, database type, database username, and database password (ConnectString, DatabaseType, DBUser, and DBPassword).
  • Enable the Repository Services in Exclusive mode.
  • Restore the repository in the new database.
  • Restart the Repository Service in Normal mode.
  • Start all Integration Services in the repository.

More Information
Take the backup of the repository and domain before upgrading.


Domain back up can be done by the following command:


./ BackupDomain -da <DB_Host:Port> -du <DB_username>-dp <Db_Password>-dt <DB_type>-ds <DB_Servicename>-bf <Backupfilename.mrep> -f -dn <Domain_Name>


Repository backup can be done from the admin console,

Manage >> Services and Nodes >> Actions >> Repository Contents >> Back up

Applies To
Product: PowerCenter
Problem Type: Configuration; Connectivity; Product Feature
User Type: Administrator
Project Phase: Configure; Implement
Product Version:
Operating System:
Other Software:
Last Modified Date:5/28/2020 10:08 PMID:617266
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)