Hi - Is there any easy way to compare Appian DB Table schemas from different environments just like other Appian Objects we do Compare and Deploy? Some of the tables have custom properties which we updated from Backed through SQL scripts and was not possible from CDT. Before deploying I want to find out difference between two environments so that i can prepare script to deploy the changes.
Thanks.
Discussion posts and replies are publicly visible
Depends if you're in the cloud or not.
If you are on-premise, you can do it via MySQLWorkbench.
On cloud, only way I that I am aware is either to generate a MySQL dump in PHPMyAdmin and compare the dumps from both environments. You could also use the https://community.appian.com/b/appmarket/posts/mysqldump plugin to generate the dumps to compare as well.
Thanks Mathieu. We have Cloud instance. Right now I am generating schema from two environments and comparing manually. But thought if there is any better way which will generate differential script automatically instead of manual comparison and generating script manually.
You could also import both dumps on a local MySQL instance and then run the diff from MySQLWorkbench which would perhaps yield slightly better results.
Otherwise, you could also use the enhanced data pipeline to access Appian Cloud databases with MySQLWorkbench. docs.appian.com/.../Enhanced_Data_Pipeline_for_Appian_Cloud.html