Prisma•4d ago

db Pull not pulling schemas

When I am doing a prisma db pull in a file that I have about 10 schemas defined in the schema file

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
  schemas  = [... 10 schemas here]
}

datasource db {
  provider = "sqlserver"
  url      = env("DATABASE_URL")
  schemas  = [... 10 schemas here]
}

It seems that it just skips several of the schemas after the first about few, is there a limit of the number of schemas that can be pulled?

3 Replies

JonathanOP•4d ago

If I remove a few it will pull them but are there some limits or output that I can see why it is skipping some

RaphaelEtim•3d ago

Hi @Jonathan There is no known limit to the number of schemas that can be pulled. However, this is a known issue. You can take a look at the workaround suggested here for MSSQL

GitHub

Unable to introspect a certain database schema when combined with o...

Bug description When I use prisma db pull to introspect my sql server database using the multiSchema feature, I am unable to combine the Trips database schema with any of my other schemas. When I l...

JonathanOP•2d ago

Looks like I apparently commented on it back in 2023 also

Gaming

Programming

db Pull not pulling schemas