Hi, I would like to transform existing MSSQL/Postg...
# prisma-whats-new
m
Hi, I would like to transform existing MSSQL/Postgres into GraphQL server. I might need to map DB Schema into GraphQL Schema. Thus I can query the MSSQL/Postgres using GraphQL query instead of SQL query? Is graphcool the right tool to achieve this goal? Thanks.
a
In order to use Graphcool, you need to migrate your data to the Graphcool database. You cannot connect your own database directly (yet).
m
So sad. MSSQL is provided by data provider. We cannot migrate it to Graphcool database.
And we have our Business Schema mapping from Database Schema. I would like to use GraphQL Schema as our Business Schema.
a
There are a number of tools that make it possible to expose an existing MSSQL database, but they are unrelated to Graphcool. There is an open FR for supporting other databases though, maybe you can share your 👍 there? https://github.com/graphcool/framework/issues/1006
m
Good.
databaseflow can expose an existing MSSQL database. However, we can only query with sql strings.
a
No, you can also use databaseflow for GraphQL querying. If it's just about querying, and not about mutations, that might be an option
m
can i use https://databaseflow.com/ to querying SQLSever natively using graphql apis ?