Deploy/migrate changes from QA to Production

Queries and Resources
3

Hi @Kabirdas thank you for response.

It is PostgreSQL and I think that we can build a flow to deploy it either via API or with JS code in retool.

I will also want to present differences between the two database of the two environments before deploying.

This I think can be done by either of those following options:

  1. JS data comparison Compare Column Data in Tables - #10 by dcsearle
  2. Or maybe by SQL on top of JS objects arrays like shown here https://docs.retool.com/docs/querying-via-sql#joining-two-json-arrays , which is a similar solution.

I think this cover the capabilities of Retool on this aspect. I just wanted to make a discussion on it, since it seems to me like a common requirement.