I've started using prisma with SQL Server. Very ha...
# randomj
Jon Crowell
05/20/2021, 4:21 AMI've started using prisma with SQL Server. Very happy that it is now supported. Unfortunately when I run
npx prisma introspectdboj
janpio
05/20/2021, 7:14 AM
Not yet, but it is high on our todo list to support multiple schemas.
janpio
05/20/2021, 7:15 AM
The same limitation applies to PostgreSQL btw.
janpio
05/20/2021, 7:15 AM
Here is the issue about it, maybe follow that and/or leave some information about your use case: https://github.com/prisma/prisma/issues/1122
j
Jon Crowell
05/20/2021, 1:30 PMAwesome. Thank you. I'm working around this at the moment by prefixing my object names with what will be the schema. So
rawEmployees and stageEmployeesraw.Employees and stage.EmployeesJon Crowell
05/20/2021, 1:30 PMIs this the right channel for this kind of question?
j
janpio
05/20/2021, 1:40 PM
You can use #prisma2
👍 1
janpio
05/20/2021, 1:40 PM
I think SQL Server has some feature where you can pull in multiple schemas into one...
janpio
05/20/2021, 1:41 PM
So you can keep the stuff in the schema you have it, but have an additional one where it all gets mirrored into.
janpio
05/20/2021, 1:41 PM
Something with
i...j
Jon Crowell
05/20/2021, 2:10 PMThat would be helpful. I'll see if I can find it.
j
janpio
05/20/2021, 5:53 PM
The word that start with
isynonyms😀 1
janpio
05/20/2021, 5:53 PM
That might help.
janpio
05/20/2021, 5:54 PM
Here is a description and a link: https://github.com/prisma/prisma/issues/1122#issuecomment-825774657
j
Jon Crowell
05/24/2021, 12:34 PMThank you. I'll check it out.
👍 1
2 Views