Hi,
is possible to run DNN with other DBMS?
The answer is: yes, theoretically.
The data access in DNN is realized as a provider, and the provider delivered is the SQL Server Provider. If you write another provider for the data access, you can use whatever database you want.
This is quite complicated. You have to convert all the SQL scripts from T-SQL to the SQL you intend to support (PL/SQL for Oracle, mySQL etc.). And not only the scripts for the core system but for all extensions you use. That means you have to do that for every new version of DNN, any module etc.
There have been projects for an Oracle provider (e.g. AcuitiDP - Oracle Data Provider for DotNetNuke (acuitisolutions.com)) and also mySQL afair, but none of them survived. The one I linked to ended with DNN 6.1.1 - and that is a long time ago.
My recommendation is: stay away from this idea.
Happy DNNing! Michael
Michael TobischDNN★MVP
Thanks Michael, your explain clarify all my doubt
Hello Everyone:
I want to first echo Michael's response. I also want to be sure that I highlight one more point. Michael is speaking about the underlying features/functionality that run DNN itself.
If you have a use case where you want to communicate with another database (of any kind), you can do that from your custom modules. People have connected to all kinds of databases over the years, including various No-SQL DBs, MySQL, etc. You just need to be sure the server where the application is being hosted has the appropriate drivers (if necessary), and you have a valid connection string with any firewall openings you may need.
Hello Will, hello Michael
my question is about DNN itself, not an extension module
Thanks again
Posted By progmr on 10/23/2023 7:08 AM Hello Will, hello Michael my question is about DNN itself, not an extension module Thanks again
Thanks for the confirmation. Then, Michael's advice is spot on. You can indeed do this and there is built-in infrastructure to support it, but it's generally not worth the effort for many. I even looked at it as a fun side project once to do a MySQL version for a derivative database, but dropped it myself once I saw the amount of effort required for all of the SProcs.
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.