Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
Drift detected after generation the schema and init migration script on mssql - Prisma
P
Prisma
•
11mo ago
•
13 replies
Merlin
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
MARKET_COMMENT
table
[
+
] Added primary key on columns
(ID
)
)
Prisma
Join
The official Discord server of Prisma! Find us online at prisma.io
9,819
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Recent Announcements
Similar Threads
Was this page helpful?
Yes
No
Similar Threads
Drift detected after migration reset
P
Prisma / help-and-questions
2y ago
Prisma migration drift detected after Git rollback – cannot reset production DB
P
Prisma / help-and-questions
3mo ago
Drift detected but no changes in schema
P
Prisma / help-and-questions
2y ago
Drift detected after making fields required
P
Prisma / help-and-questions
8mo ago