ARIS Community - We Love BPM

Migration of ARIS 7.2 DB from Oracle 11g to Postgresql

Jaya's picture
by Jayshree Asutkar in Administration & User Management posted on 2016-12-16

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. 

1211 Views
0 Likes
1 Comments
There are no attachments
M. Zschuckelt posted on 2016-12-19

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.