Skip to main content

I created a database but not the way it is suppose to be, so now I created one with the same fields but it is relational now as i did not know how to build one. So, now I need to move all the data into the new one. Can someone tell me how, i saw something about syncing but I cant find a way to do it.

 

thanks

Rose

You’ll need to:

  1. Create a shared view in your original base by clicking ‘Share and sync’, then ‘Sync data to another base’
  2. In your new base, create a new synced table by creating a new table and selecting Airtable base as the source

This’ll let you create a new table in your base with all the data, then you can copy paste it over

And here’s the docs: https://support.airtable.com/v1/docs/getting-started-with-airtable-sync
---

If you want to import it directly into your table, then you can try exporting the data as CSV by clicking on the view name and then ‘Download CSV’, then using the CSV Import extension in your main base to import it

 

Hi Rose,

Since you’ve already created a new relational database with the same fields, the best way to move your data depends on the database system you’re using (MySQL, PostgreSQL, SQL Server, etc.), but here’s a general approach you can follow:

  1. Export the Data from the Old Database

    • Use your DB’s export tool (mysqldump for MySQL, pg_dump for PostgreSQL, etc.) or generate CSV files for each table.

  2. Prepare the Data for Import

    • Check that the field names and data types in your export match the structure of the new relational tables.

    • If your new database uses foreign keys (relationships), you may need to import data in a specific order (e.g., parent tables first, then child tables).

  3. Import into the New Database

    • Use an import tool or LOAD DATA INFILE / COPY commands to bring CSV data into the new relational tables.

    • For smaller datasets, you can also write SQL INSERT INTO … SELECT … FROM old_table queries if both databases are accessible in the same environment.

  4. Verify Relationships

    • After import, run queries to check that foreign keys and relationships are correctly set.

    • Clean up any mismatched or orphaned records.

If you share which database engine you’re working with (MySQL, SQL Server, PostgreSQL, SQLite, etc.), I can suggest the exact commands and steps.

Hello!

To move your data, you don't need to sync, you need to migrate it. The best way is to first export the data from your old database into a common file format like a CSV (Comma-Separated Values). Next, ensure the new relational database has the same field names and data types, then use its import function to load the CSV file, which will populate your new tables with all the old data. 

Reply


Terms & Conditions