Converting a Bubble Database to Xano
I know CSV imports are coming next week, so in the meantime, to test things out at least for the database structure I exported my dev DB to airtable and imported it to xano from there.Â
The main problem I am facing is that the data the relational part of the DB doesn't transfer over so if I have a User & Posts table, and the User table has a list/array of Posts, when I import, the User table just has a Text column/object with Post IDs.Â
This presents two issues at least:
1. Â If I convert the column from text to integer to make it a linked table (so I can link it to the posts table) it erases all the IDs.
2. The import of the Posts didn't bring over their underlying IDs in the Posts table, so I don't really have a way to know which record matches which ID.
Lastly but less critical for now, is that it didn't import any table objects that were empty, so if I had a table with a column that did not have any values for any record, it did not get imported.Â
So my main question is, how would I migrate over the database and it's structure and relationships without breaking it?
Thanks
Other
1 reply