is it possible to have two different clients? I want to write a data migration between two databases

Yes. Their generated output should be in different folders

hm okay, I should have two generated clients (hrt and platform-repo), when I use the hrt client it works fine but the repo client says the Tenant table doesn’t exist (it does in that database)

How have you defined it in your schema.prisma?

i have two different prisma dirs

But they would generate in the same

node_modules

right?

they are different packages/workspaces in my NPM v7 monorepo

Try specifying the

ouptut

as shown here.

it seems like the clients are correct though because I can import two different clients and the have the expected types for my tables. i’m wondering if they’re sharing a connection or something though because I don’t know why else

platformClient

would have

tenant

but not see the table when querying

Is this something that I could check out? A monorepo with two PrismaClient should work fine but I’d like to check.

sure, what’s your github username?

ryands17

@Mischa they are both sharing the same environment variable

DATABASE_URL

ah great catch! thank you so much!