Migrating an existing FDM app from MSSQL repository to Oracle repository
edited Jan 29, 2013 8:05AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 1 commentAnswered
Hi, I am in the process of migrating and FDM application based on 11.1.2.1 with MSSQL as repository to 11.1.2.2 and Oracle 11g as repository.
I know this process is not supported officially.
So, I tried to migrate the mssql schema with the help of Oracle SQL Developer (migration feature) to an Oracle DB.
After I did that, I tried to upgrade the FDM schema to the new version.
During that process I got several errors concerning several tables missing the allow null property on several columns.
For example, TCTRLMETADATA,TSECOBJECTITEMS_LOCALE, etc.
It seems that MSSQL schema defines the columns with not allowing nulls in all tables while Oracle schema allows nulls on several columns on many tables.
I know this process is not supported officially.
So, I tried to migrate the mssql schema with the help of Oracle SQL Developer (migration feature) to an Oracle DB.
After I did that, I tried to upgrade the FDM schema to the new version.
During that process I got several errors concerning several tables missing the allow null property on several columns.
For example, TCTRLMETADATA,TSECOBJECTITEMS_LOCALE, etc.
It seems that MSSQL schema defines the columns with not allowing nulls in all tables while Oracle schema allows nulls on several columns on many tables.
0