Create a new db schema with existing repository schema (with all db objects), using Infa9.1 try to create repository service pointing to new repositry schema by choosing option (which does not create repository objects) and then upgrade the repository.
Other option: Uninstall 9.1 version, install 8.6 version and restore the repository, once Informatica is good to use then Install 9.1 with upgrade option.
let me know for issues.
If helps pls mark as correct.
Edited by: Srini VEERAVALLI on Dec 31, 2012 12:57 PM
My old repository(Version 8.6) is in schema 'abc'.
Now I have created a repository(Version 9.1) 'with no content' in database schema 'def'.
Can I import the old repository(Version 8.6) in schema 'abc' to repository(Version 9.1) ('with no content') in database schema 'def' ?
I must create repository(Version 9.1) ('with no content') with same database schema name as 'abc' and then import old repository?
You need to create repository(Version 9.1) ('with no content') on same database schema 'abc'.
Once repository service is created->Look for Actions at top right on console
I appreciate if you mark my last message as correct.
Edited by: Srini VEERAVALLI on Jan 3, 2013 11:19 AM
Restore Contents operation on repository [REP_TEST91] started at 01/07/2013 11:08:25.
Restoring repository contents from file [C:\Informatica\9.1.0\server\infa_shared\Backup\DEV_INFA_REP_03JAN2013.rep].
domain name: DNE_INFA_TEST
Backup file repository version : 179 Current repository version : 181
File backup version : 10 Current backup version : 10
Backup file is valid : Yes
Backup file code page id : 106 Current code page id : 106
This backup file is from a different version of the Informatica Repository.
Unable to restore Repository.
Restore Contents operation on repository [REP_TEST91] ended at 01/07/2013 11:08:25. Elapsed time is 0:00:00.