What is the best practice for deploying tables during an application package import to a new environment?

Hi All,

I wanted to get your views on the best way to import the tables associated with an application package in Appian when we move the application package from one source environment to a new target environment. As of the practice is that the administrators ask the developers to provide them with the application package and the associated SQL scripts for the application. Then the administrators first import the package on the target environment and then manually run the scripts in the cloud database’s SQL view.

Another school of thought is that the administrators should import the package and then go into Appian Designer navigate to the newly deployed package’s Data Source Entity and under Schema Management click on the “Verify” button to check if the tables exist if not create the tables to add the Data Entities on the cloud database?

Which of the above two approaches is the ideal?

Thanks & Regards,

Sam

 Discussion posts and replies are publicly visible