Is there a way to push changes from a test system into production?

🚧 Installation
#1

We have two corteza (2023.9, docker) instances. One is a test system for testing and developing and the other should be a production system. The production system is a new and empty corteza instance. They both work without issues.

My problem is, that I have no idea how to transfer changes from testing into production. I read in the forum, that using of the “Export” function on the namespace, I want to copy, is not recommended and that other people use sql dumps. So I dumped the entire corteza DB from testing, stopped the production corteza-server container and applied the dump onto the running production database. This caused some problems: duplicate applications, no namespaces, etc.

How did you manage to push into production from a test server? I will appriciate any tips.

In the best case, I would like to transfer all changes to the namespace and applications without transfering or deleting any records.

#2

I am trying to setup a test environment for myself also.
My thought was to push changes, depends on the change itself like a workflow, I can just export one workflow and import in prod. Or like if you created a new module, we can export a module as well.

To do a complete transfer I am not sure and would be curious to know myself. Like a complete refresh of the sandbox. I’m not a AWS expert but I was thinking we can clone prod db and connect to sandbox instance, delete old sb sb