Data Transfer Best practice

Hello Team,

What is the best practice to move data between servers? For example: test and qa server.
In test you create roles, people and workflow items etc.
When you now point the studio to QA and run the scripts, it will create schema and not these objects. What is the recommended way to move these objects.
I know workflow can be exported/imported. But is there an alternate approach?

Regards,
Prashanth

Hi Prashanth,

Apart from exporting/importing data in JSON, you can roll out changes using SQL commands in 30.create-db.sql script or in manually added update scripts.

The next CUBA feature release (7.2) will allow you to define security and reports at design time, so no data transfer will be required. You can track the progress in the issues:

Thanks Konstantin.