Currently we are using Oracle 11g database for ARIS 7.2. Now we want to migrate the DB from Oracle to Postgresql. So is it possible to migrate? If Yes, can anyone help by providing the procedures.
2 Replies
-
Hello,
just a suggestion: Set up a second Business Server installation with the default database system (which is Postgresql). Backup your databases (to .adb files), filters etc. and restore them to the new Business server. But beware, that Postgresql is not recommended for production systems. Consider MS SQL 2008 Enterprise Ed. R2 or IBM DB2 UDB 9.5, if you want to go away from Oracle.
-
Hello!
Is your migration to postgres success?
Now we choose Postgres or Oracle for ARIS. Can you share experience?