For all non-Appian SQL specialists: Appian is a low-code platform which needs two central datastores. The database appian_internal contains details about Appian's internal objects such as general interface definitions, rules etc. and their configurations. This database is initially created by the platform and usually nobody expect the platform itself touches this database. No business data is stored there.
I read that Appian stores data there in an encrypted manner. All these points support my hypothesis that a simple migration from PostgreSQL to SQL will not work.
The question
Currently, we have our appian_internal database running as a (cloud-based) PostgreSQL, but we are aiming for a (Azure) SQL managed instance - what is the way forward?
Does somebody have experience with that issue? Is it possible to take the appian_internal database of a different environment assuming that it is only updated during a platform upgrade?
PS: I hope this is the right forum for a question which is somewhere between infrastructure and SQL and the proprietary low-code platform Appian - I posted it here for the sake of a wider audience. The search of Appian's community was not successful since this is a rather technical question for folks who runs the Appian platform on premise.