Hi, I would like to transform existing MSSQL/Postg...
# prisma-whats-newm
Mingzhou ZHUANG
11/08/2017, 1:44 AMHi, 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
agartha
11/08/2017, 2:01 AMIn order to use Graphcool, you need to migrate your data to the Graphcool database. You cannot connect your own database directly (yet).
m
Mingzhou ZHUANG
11/08/2017, 2:21 AMSo sad. MSSQL is provided by data provider. We cannot migrate it to Graphcool database.
Mingzhou ZHUANG
11/08/2017, 2:23 AMAnd we have our Business Schema mapping from Database Schema. I would like to use GraphQL Schema as our Business Schema.
a
agartha
11/08/2017, 2:41 AMThere 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
Mingzhou ZHUANG
11/08/2017, 2:50 AMGood.
Mingzhou ZHUANG
11/08/2017, 2:58 AMMingzhou ZHUANG
11/08/2017, 2:59 AMdatabaseflow can expose an existing MSSQL database. However, we can only query with sql strings.
a
agartha
11/08/2017, 3:05 AMNo, you can also use databaseflow for GraphQL querying. If it's just about querying, and not about mutations, that might be an option
m
Madhu Jahagirdar
02/28/2018, 12:44 AMcan i use https://databaseflow.com/ to querying SQLSever natively using graphql apis ?
3 Views