Migration issues | Prisma | Page 1

austere spindle Feb 21, 2024, 6:42 AM

#

Hi
I switched my db from a self hosted mysql to postgresql on fly.io.

Changing the prisma client worked and I can use my application with the new database.

Now there are some issues:

I wanted to migrate my old data to the new db using pgloader, seamed to work but my api doesn't return the data. When I look into the db I see the migrated data.
I do see the the newly created data in prisma studio and get it returned from my client.
Prisma studio shows different data regarding I use the proxied database or connect directly

Anybody has an idea what is happening here?

austere spindle Feb 22, 2024, 11:43 AM

#

Anybody?

unborn knoll Feb 23, 2024, 6:43 AM

#

Hey 👋

but my api doesn't return the data
Does your API return no data? It is difficult to predict what might have gone wrong without looking at the code.

If you connect to your new postgresql database via a database GUI tool, do you see the expected data?

austere spindle Feb 23, 2024, 10:07 AM

#

Thanks for the hint, I looked into the tables with pgadmin and noticed my issue. The migration created the tables lowercase e.g. volunteers and the new created Pascalcase e.g. Volunteers. When querying in the console I typed e.g. "from public.Volunteers" which used public.volunteers. With public."Volunteers" I get the correct data.

#Migration issues