Hello,
Having two environments (PAM and PRO, both on cloud), I want to copy the database schema from PRO to PAM under the name "Appian_pro". After that, on PAM environment, I want to delete the "Appian" schema and rename the copied schema as "Appian", all of this to operate with Pro data on PAM.Would be possible to perform these steps?
Thank you in advance.
Regards
Discussion posts and replies are publicly visible
I believe you can't rename the data schema. So here, you need to delete the schema "Appian" from PAM. Then, you need to create a new data Schema in the PAM environment as "Appian" and then create the tables with the data that were present in the PRO. For more info - docs.appian.com/.../appian-cloud-database-administration.html
On PhPMyAdmin I've seen this option, but I'm not sure how Appian env how it will behave, have you tried?
You will not be able to use that, due to insufficient permissions.