Data Porting Question

[Mathew Tasalloti]

Hi Gang,

I'm looking at Fusio as a replacement to WSO2 - one of the big problems we have is trying to replicate environments across Dev, QA, Prod and so forth.

Is there a way to dump the data from one environment to another and easily recreate the API's, Routes, Users, rights and all other settings?   Ideally we could even do this when going from say, version 2 of Fusio to version 3 (build the new environment and port the data into it).

I'm wondering if it is as easy as dumping the database and restoring it in the new environment.  That said, I see a lot of hashed keys in various tables that may break using that approach.

Any thoughts or suggestions in case you've done this with Fusio?

Many Thanks,
Mathew

[Christoph Kappestein]

Hi Mathew,

great that you try to use Fusio. Regarding your problem, so at Fusio we provide a deploy mechanism, through this you basically write all your Fusio config for the backend in .yaml files and the you can run "bin/fusio deploy" to apply all those config files to the backend, internally the deploy mechanism then also uses the backend API to create all those entries. Through this you can easily replicate environments without the need to dump the database.

You may also take a look at our sample repo s.
https://github.com/apioo/fusio-sample-cms

where you can see some of the configuration files at the resources/ folder.

Besides this you could also take a look at the "deploy:export" and "deploy:import" command which return a JSON structure of your complete installation.

best regards
Christoph

[Mathew Tasalloti]

Hi Christoph,

Thank you for your coaching and this is fantastic.  I can't wait to try it out as it will solve such a big problem for us.

Very impressed with Fusio so far using Docker.

Best Regards,

Mathew