Skip to main content
S
sandeepa0002
New Participant
June 1, 2021
Question

Comparing Appian DB Table Schemas from different Environments

  • June 1, 2021
  • 3 replies
  • 1 view

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. 

    3 replies

    mathieud0001
    mathieud0001
    Brainy
    June 1, 2021

    Depends if you're in the cloud or not.

    If you are on-premise, you can do it via MySQLWorkbench.

    1. Click File and New model
    2. On the new model window which has been opened, click Database and Compare schemas.

    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.

    S
    sandeepa0002Author
    New Participant
    June 1, 2021

    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.

    mathieud0001
    mathieud0001
    Brainy
    June 1, 2021

    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

    Terms & ConditionsAccessibility statement