[web2py] Merge multiple sqlite databases into one

[clarix]

Hello,

I am developing a web2py application that is going to run in 4
warehouses. They are not connected to the internet.

I need to then generate a second web2py application that gathers the
information of the 4 sites into a single database with exactly the
same table layout for data analysis.

What would be the best/easiest way to do it?

Thanks!