Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 08, 2021 11:56 PM
Is there a way to copy a base schema between accounts?
So I don’t need the data - but I’d like to copy the schema (all the tables in a base) to another account. Is there an easy way to do this?
Dec 09, 2021 04:17 AM
Hi,
Ask other account to grant creator access in his workspace, restore your last base snapshot into it, go to base and delete all records (if needed). I didn’t try but I think, it’s possible.
other way - is to use scripting to get base schema (list of tables/fields) and then create them by script in other place. but there will be a mess with options, and some field types cannot be created by script
Nov 17, 2023 03:07 AM
Two years later and still no better solution? 😞
Thank you Alexey for this workaround. Still I would love to see such a feature. It's annoying to do all of this by hand. There should be a template function for new tables.
Nov 17, 2023 04:39 PM
I think you should better duplicate it with 'Copy records' off.
Nov 19, 2023 09:18 AM
Unfortunately this does not work cross base / workspace. Or does it?
Nov 20, 2023 11:08 AM
Nov 20, 2023 10:34 PM - edited Nov 20, 2023 10:35 PM
Thank you. The new base already exists. Any way with existing bases?
EDIT: The best way I came up with, is to sync the table and then stop the sync, but keep the records. Not the best solution since the schema is not 100% correct, but it did the trick for me.
Nov 21, 2023 08:58 AM - edited Nov 21, 2023 09:03 AM
If the base with such name already exists, change Name.
The solution you described works for copy table. You starting the sync then choose "Copy this data into a new table that you can edit" - option designed for copying a table.