Support MS SQL Server.

[igalklebanov]

Hey 👋

Currently Studio doesn't support MS SQL Server. Let's change that!

[rdev32]

i can't believe this, prisma 7 studio dropped support for sqlserver.
in the documentation https://www.prisma.io/docs/orm/tools/prisma-studio#databases-not-yet-supported
they don't even mention it.

details:

• Microsoft Windows NT 10.0.26100.0
• OpenJS.NodeJS version 22.20.0
• "@prisma/client": "^7.1.0"
• "prisma": "^7.1.0"

the console will just tell you

npx prisma studio --url="sqlserver://localhost:1433;database=test;user=sa;password=Password123;encrypt=false;trustServerCertificate=true"
Loaded Prisma config from prisma.config.ts.

Error: The provided database URL is not valid.

if for some reason you put a last / right after the port, it will prompt you with the right answer

npx prisma studio --url="sqlserver://localhost:1433/;database=test;user=sa;password=Password123;encrypt=false;trustServerCertificate=true"
Loaded Prisma config from prisma.config.ts.

Error: Prisma Studio is not supported for the "sqlserver" protocol

just saying, in case somebody is asking what happened to your prisma after upgrading
do not upgrade, even the migrations run slower, it's not worth it

[ggYasin]

since it prisma studio with ms sql server used to working great with prisma versions prior to v7, it would be great to have it fixed.
this is currently my only roadblock for upgrading to v7

[olavidps]

+1 Is there any information regarding why was it supported but not in the latest version? maybe roadmap or tech limitation?

[chrisdel101]

I recently switched to msSql and now I cannot use it anymore....