Rename database schema

Question

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

tushark6475 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO