Getting issue while migrating from supabase to appwrite

TypeScript

{
  "$id": "67c6XXXXXXXXXXXXXXX",
  "$createdAt": "2025-03-04T00:09:07.676+00:00",
  "$updatedAt": "2025-03-04T00:09:17.931+00:00",
  "status": "failed",
  "stage": "finished",
  "source": "Supabase",
  "destination": "Appwrite",
  "resources": [
    "user",
    "database",
    "collection",
    "attribute",
    "index",
    "document",
    "bucket",
    "file"
  ],
  "statusCounters": {
    "user": {
      "pending": 0,
      "success": 0,
      "error": 0,
      "skip": 4,
      "processing": 0,
      "warning": 0
    },
    "database": {
      "pending": 0,
      "success": 1,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "collection": {
      "pending": 0,
      "success": 1,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "attribute": {
      "pending": 0,
      "success": 4,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "index": {
      "pending": 0,
      "success": 1,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "document": {
      "pending": 1,
      "success": 0,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "bucket": {
      "pending": 0,
      "success": 2,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    },
    "file": {
      "pending": 1,
      "success": 0,
      "error": 0,
      "skip": 0,
      "processing": 0,
      "warning": 0
    }
  },
  "resourceData": [],
  "errors": [
    "Error occurred while fetching 'bucket:' from source with message: '{\"statusCode\":\"404\",\"error\":\"not_found\",\"message\":\"Object not found\"}' Message: {\"statusCode\":\"404\",\"error\":\"not_found\",\"message\":\"Object not found\"} File: /usr/src/code/vendor/utopia-php/migration/src/Migration/Target.php Line: 154"
  ]
}

TL;DR

Issue: Having trouble migrating from Supabase to Appwrite, specifically with accessing tables from the "demo-chat" database and importing files. Solution: As of now, the migration seems to only support the public database. Access restrictions might be causing the inability to import files from the "demo-chat" database, along with the error message mentioning objects not being found. The user is also unable to see tables in different databases that are not part of the public database.

Maybe access issue to the file?

And one more thing, I am unable to see other tables in different database which is not part of "public" database from supabase.

Any idea?

I have two database in one project (org). "public" & "demo-chat"

I can only able to import "public" database table not the "demo-chat" database

There is no any restrictions for file.

and both databases have data for your app?

Yes

seems like we only support migrating the public database right now 😕

And any idea about file?

what's your project id?

is the file publicly available?

TypeScript

https://fktrlnohgbmayszikpid.supabase.co/storage/v1/object/sign/chats_assets/2/67ddb7d0-f884-11ef-9898-59a30e1b354b-scaled_1000038497.jpg?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1cmwiOiJjaGF0c19hc3NldHMvMi82N2RkYjdkMC1mODg0LTExZWYtOTg5OC01OWEzMGUxYjM1NGItc2NhbGVkXzEwMDAwMzg0OTcuanBnIiwiaWF0IjoxNzQxMDQ5ODE0LCJleHAiOjE3NzI1ODU4MTR9.L90Qp0Rkfml5S-RmnZOdB1sYbd1zUhlrb6IjQ_YC-Lk

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more

Recommended threads

Need support?

Join our Discord

Get premium support