Imported exported DB from Baserow into self-hosted solution, match IDs

Technical Help
1

I’ve been able to import all of the data from the baserow.io hosted instance onto my self-hosted solution, but noticed the DB ID and table ID’s have all changed. Is there something I can do to ‘match’ them with the IDs that were set on baserow.io?

2

Hey @dog87

Unfortunately there is no automated way to match new IDs

When you import data into your self-hosted Baserow instance, the database IDs and table IDs are intentionally reassigned. This is done for two key reasons:

  1. Consistency: If a user imports the same workspace multiple times (e.g., by mistake or intentionally to create a duplicate), reusing existing IDs from the exported data would create conflicts. Assigning new IDs ensures each import remains independent and consistent without affecting existing or future imports.
  2. Safety: Using existing IDs from the exported data risks overwriting or corrupting the current data in your self-hosted instance. By generating new IDs, we protect the integrity of your database and prevent accidental data loss or corruption.
3

Thank you for that response.
Is there a non-automated way to overwrite these IDs?

4

If you know how those IDs are changed and you have access to database/postgres instance you could try with db_dump to create sql file. Then update schema in that file and load it.