prisma1 MS SQL Connector

This feature requests serves as a central place to discuss development and progress for the MS SQL connector.

Jan 16 '18 13:01 marktani

When you can expect a working connector to Ms SQL ??

Jan 30 '18 18:01 SebaBoler

I need this too

Jan 31 '18 03:01 iamgmd

Hey @SebaBoler and @iamgmd, thanks a lot for your interest in the MS SQL connector 🙂 I would love to hear your thoughts on specific use cases you'd like to be covered, and an initial suggestion for the SDL syntax and exposed capabilities.

You can read more contributing to a DB connector here.

Jan 31 '18 20:01 marktani

Super excited about this, though I will probably fall back on the hosted platform as I'm getting tired of managing everything - the NET community is ~desperate for a GraphQL API interface to SQL Server.

Feb 17 '18 15:02 jakenuts

I noticed MS SQL was missing on the main README: https://github.com/graphcool/prisma.

Feb 21 '18 22:02 Sawtaytoes

+1

Mar 18 '18 08:03 nadilas

+1

Mar 18 '18 23:03 jurby

I waiting for this

Mar 19 '18 08:03 boverdrive

I need this badly

Apr 11 '18 15:04 eabassey

Thanks a lot for your feedback everyone 🙂

If you have any thoughts in the spirit of what I mentioned above, I'd be happy to hear it! If you want to express your desire in this feature, please use Github reactions on the original post. Thanks! 🙌

Apr 11 '18 16:04 marktani

I really need this! Please make this happen!

Apr 16 '18 01:04 edenprairie

+1

Apr 23 '18 18:04 felixti

+1

Apr 24 '18 07:04 albangiroux

+1

May 15 '18 20:05 killjoy2013

There is a huge .NET community - by supporting MSSQL and writing some how-to's on deploying onto Azure I think you will capture some massive traction in the enterprise space - especially financial services.

May 17 '18 09:05 develomark

Big +1 on this. Regarding features even just reproducing the pgsql functionality would solve 90% of users needs.

May 17 '18 15:05 BrianLondon

This is important because there are lots of enterprise organizations as @develomark mentioned, which use MS SQL and they will be able to start using Prisma (I'll be one who will suggest them to try), hope it will happen soon :) Also I'll take a look current connectors and I'll try to share something valuable about that.

One note here, if you will support azure sql, ms sql will be supported also, because azure sql is limited version of ms sql, but those limits will not have any effects for Prisma.

May 29 '18 07:05 playerx

I also would like to take a vote for a MSSQL connector to

push Prisma/GraphQL to enterprise environments
broaden the availabitly and compatibility of Prisma

Since I have become a user of MSSQL I must say it's a great DBMS and I would like to start a GraphQL project with some of our customers. Therefore I would like to have a solid development library that fits with SQL Server and is capable of using some more of the TSQL features and is not limited to a a really small subset of the SQL standard.

One could say to go with .NET/.NET Core but making Prisma available as a JavaScript solution to the market would propably also accell the need and use of full stack JS developers that could create products for big enterprise customers.

Jun 18 '18 08:06 vuchl

hope this .

Aug 06 '18 10:08 sytpb

When I execute 'prisma deploy' to a local MySQL instance, I get this error. What am I missing?

TypeError: Cannot read property 'name' of undefined at Socket. (C:\Users\Owner\AppData\Roaming\npm\node_modules\prisma\node_modules\pg\lib\connection.js:123:21)

Aug 29 '18 11:08 Gary-Shurgin

@Gary-Shurgin Not sure if your post is relevant in this thread as this one is related to wanting MS SQL in Prisma, nothing to do with MySQL.

Aug 29 '18 11:08 iamgmd

This connector should be shipped by default as soon as possible. Supported should be

Tables (of course)
Views
Stored Procedures (including result selection)
Table- and Scalarfunctions
Table Types

Sep 06 '18 09:09 Popeye4242

I think you can add support to this through the Microsoft SQLServer JDBC library ?

Code should be similar to what you have done with MySQL and PostgreSQL.

You might also need to consider supporting different versions : https://docs.microsoft.com/fr-fr/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix

Microsoft team has also been open-sourcing lot of stuff related to SQL Server lately, may be we can ask their help. Check out the Linux tools they have released:

https://github.com/Microsoft/mssql-scripter
https://github.com/Microsoft/sqlopsstudio

I am using these tool at work in a Linux / Scala environment with connection to Windows / SQL Server backends. But not using GraphQL for the moment.

Sep 07 '18 16:09 mycaule

Would like to know whether the work on this has started or not? Dont see a branch for it either.

Sep 10 '18 06:09 mii9000

I need this so badly, at this moment I use TypeORM because of this, if we have MS SQL Server Connector, for sure I change for Prisma. Other project I develop I used PostgreSQL and MariaDB (MySQL),

Nov 28 '18 22:11 PJCAfonso

I notice there's some development on the JDBC connector. Having not worked on MSSQL for a long time, I have to ask if the JDBC connector allows use of MSSQL? Azure SQL?