SQL Server Support

pwelter · 6 Oct 2020, 03:40

Hello,

Any chance of seeing SQL Server support for FusionAuth? The .net community is in need of more good auth servers. I’ve been impressed with FusionAuth. Very easy to get up and going with docker. Only think holding me back is not having SQL Server support. The drivers are fairly good and cross platform now. My tech stack is already using SQL Server and I don’t want to have to host PostgreSQL as well.

Thanks
~ Paul

dan · 6 Oct 2020, 17:35

Hi Paul,

Thanks for the feedback, I'm glad you're finding FusionAuth useful. Definitely understand your position. I'm a big fan of consolidated tech stacks wherever possible.

As of right now, we have no plans to support SQL Server. To remedy that, I can see three paths.

You could file a github issue detailing what you'd like to see (which version of SQL server, etc) in more detail. https://github.com/fusionauth/fusionauth-issues/issues This has the benefit of being free and relatively low investment. It has the downside of not actually guaranteeing that this feature/change becomes available. We rank feature requests based on community input as well as customer feedback.
You could take this on as a community project. We have other community projects (the helm charts, for example). From googling, it looks like there are several mysql->sqlserver or postgresql->sql server translation projects. You can find the schema for FusionAuth here. If I were doing this, I'd convert the schema, pop in the MS SQL Server JDBC driver to the tomcat webinfo directory and give it a go. This is obviously a heavy lift, but it's an option. If you documented that, I'd definitely read/share/promote that blog post.
You can engage us and see about a professional services agreement if you have budget. If you're interested in getting an estimate on this, please fill out a contact form: https://fusionauth.io/contact

Here's our general roadmap guidance, which is probably worth a read: https://fusionauth.io/community/forum/topic/172/the-fusionauth-roadmap

robotdan · 7 Oct 2020, 16:15

Another option is to use FusionAuth Cloud, then you do not need to be aware of the underlying data storage layer.

ksri8580 · 10 Feb 2021, 13:02

This post is deleted!