Dbo schema getting ignored in sql server
Hey I try to pull the database via prisma db pull with the following conf
generator client {
provider = "prisma-client"
output = "../../../../libs/omi/api/prisma/src"
previewFeatures = ["multiSchema"]
moduleFormat = "cjs"
}
datasource db {
provider = "sqlserver"
schemas = ["BALTIC", "BUNKER", "CONF", "FFA", "LOG", "PERIOD", "SEC", "SPOT", "SUBSCRIPTION", "dbo"]
url = env("DATABASE_URL")
}
it does not pull the dbo schema7 Replies
You selected to wait for the human sages. They'll share their wisdom soon.
Grab some tea while you wait, or check out
#ask-ai if you'd like a quick chat with the bot anyway!#ask-ai
Hey!
Can you check if the database user that you passed in the connection string has access to "dbo" schema?
It has when i put only in dbo it pulls the schema but when i add another one dbo is getting ignored
Oh Okay, so you mean that when there is only "dbo" in schemas array, the database models from "dbo" schema are pulled in correctly, but when other schemas are also provided in addition to "dbo", then models from "dbo" are not pulled?
The other way, all schemas are getting pulled but not dbo
Can you create a GitHub Issue with a minimal reproduction so that we can investigate this issue?
https://github.com/prisma/prisma/issues
GitHub
Issues · prisma/prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB - Issues · prisma/prisma