Migrating from Adalo to Retool Database and Collections

Hello everyone

Completely new to retool, and thinking of migrating my saas from Adalo to Retool, I was wondering how would one migrate the database, given that Adalo database has different multiple collections, and these collections have connections between them that must be kept intact to retrieve all the info as it is right now, what is the best way to do so? and if anyone did it successfully without issues,

Thank you

Hi @Younes, welcome to Retool! :wave:

It depends on how you would like to store your data. If you are interested on using Retool Database, it may be as easy as downloading your collections as csv on Adalo, and importing this csv to Retool Database.

If you would like to use a different database, like your own PostgreSQL db hosted elsewhere, you may need to use Adalo's API to query your db from Retool using a REST API Resource and sending this data to the new database the same way (GET data from Adalo and POST to your database).

Retool has a 100MB query size limit on Cloud. If your collections are heavier than this, you may need to use pagination to migrate your data by chunks. You could also create a Workflow to automate this process.