Skip to main content
Inspiring
Oct 16, 2023 9:54 AM UTC
Question

Rename database schema

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

3 replies

tushark6475
Participating Frequently
Oct 16, 2023 10:05 AM UTC

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

Inspiring
Oct 16, 2023 10:53 AM UTC

On PhPMyAdmin I've seen this option, but I'm not sure how Appian env how it will behave, have you tried?

tushark6475
Participating Frequently
Oct 16, 2023 10:59 AM UTC

You will not be able to use that, due to insufficient permissions.