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 schema4 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