I want to use MSSQL as a database

[sumanth]

I want to use MSSQL as a database. Is it possible to change MariaDB to MSSQL?

[kisg]

Hi,

Currently it is not possible to use any database other than MariaDB. Frappe does have some level of PostgreSQL support, but it is only for the Frappe framework itself, and the 1000s of custom queries in ERPNext were not converted to PostgreSQL yet.

In this post I outlined a strategy to refactor the database layer and add PostgreSQL support to ERPNext:

ERPNext PostgreSQL Support

Hi, the last thing I saw here on the forum was that Postgres support would need funding or a significant contribution due to the 1000s of custom queries that need to be checked and potentially modified for Postgres. I am not aware of anyone working on it. I am very interested in getting ERPNext to work on Postgres, since this is the DB that I know (and like) the best. I have been using it since 1999 (version 6.5)… Also, there are at least 2 distributed SQL DB implementations ba…

The same strategy would allow us to support MS SQL more easily.

Best Regards,
Gergely

[trentmu]

I am curious as to why? What benefits does MSSQL offer that MySQL does not?

[vrms]

my guess… MSSQL just exists in a particular scenario.

I wouldn’t regard that a good enough reason to add the trouble of running a not supported db to anybody’s plate

[dealproc]

One positive of supporting a database such as MSSQL is for hosting scenarios like Azure where you’re paying $5/mo to get started… then $10-15/mo as you continue to grow and need to keep perf. reasonable for users. I’m trying to determine if MariaDB can be used the same in Azure, where it’s per-unit pricing or not.

[sumanth]

First sorry for late reply
my client want to MSSQL because he have support from Microsoft.

[yasar_shaikh]

Maybe you can use api