Merlin Posts - Answer Overflow

Merlin

•Created by Merlin on 4/28/2025 in #help-and-questions

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 schema

8 replies

PPrisma

•Created by Merlin on 4/27/2025 in #help-and-questions

Drift detected after generation the schema and init migration script on mssql

hello community does someone have a idea? I setup a existing mssql database with prisma db pull the schema which was generated looks good. Also i created the init migration sql file in 0_init and applied that to the database after I run prisma migrate dev I got the following error Drift detected: Your database schema is not in sync with your migration history. The following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database. It should be understood as the set of changes to get from the expected schema to the actual schema. [*] Changed the MARKET_COMMENT table [+] Added primary key on columns (ID) )

14 replies

Gaming

Programming