Hi Manuel

Admittedly I myself have not been following the reasons for this change however, you will get a more detailed idea for the reasoning for this change in the following PR, This appears to be the PR that caused this change.. https://github.com/joomla/joomla-cms/pull/12494

Ciaran

Hello

What has gotten removed is Microsoft SQL server support. Joomla 4 will still support MySQLi. This is unlikely to cause you any issues for the vast majority server setups.

Ciaran

Thank you Ciaran, by "SQL Server" I mean "Microsoft SQL server". Why is going to be removed? last year Microsoft launched SQL Server for Linux.

I am working in a project with Joomla for a company that by its policy, they need IIS and SQL Server as DB. Many companies in my country (and in the world) have similar requirements.

Hello

What has gotten removed is Microsoft SQL server support. Joomla 4 will still support MySQLi. This is unlikely to cause you any issues for the vast majority server setups.

Ciaran

Hi,

Anybody know why SQL Server support is going to be removed?


Tahank you

Yes this helps immensely.
So much to learn, so little time...who say's you can't teach an old dog new tricks?
Have a wonderful weekend!
Peggy

Hi Peggy

What got removed is MS SQL server support from Microsoft in J4. Not MySQL. For MySQL is only an old driver removed because it is deprecated. You can already change to mysqli in your Joomla configuration and all should work as before.

I hope that helps!

Ciarán

Hi Ciarán,

https://docs.joomla.org/Potential_backward_compatibility_issues_in_Joomla_4

"This document tracks potential backward compatibility issues for Joomla! 4. Listed are issues which potentially break extensions.
The base of this comparison is Joomla! 3.7. Updated System Requirements

The system requirements have been updated as follows:
PHP 7
MySQL 5.5.3
PostgreSQL 9.2
SQL Server support has been dropped.

PHP MySQL Extension - Joomla no longer supports using PHP's ext/mysql driver (which was removed in PHP 7.0). Joomla will automatically try and use the mysqli extension (available since PHP 5.3) or the mysql PDO Driver (available since PHP 5.3) else it will fail to create a database connection."

My databases are "mysql". If SQL server support has been dropped, is that not the same as "mysql"? Which interpret as being that my database will not connect if I do all of the upgrades required for Joomla 4.0?

This is where my confusion comes from. I would really appreciate some help understanding all this. Your help has always been phenomenal in this forum.

Thank you - -from Canada!
Peggy

Hello

You have nothing to worry about. Joomla 4 will continue to use SQL. I suspect what you have read was regarding the sample data when you set up a new Joomla installation. There is currently talk of removing this feature which is SQL based and replacing it with the PHP alternative which already exists in Joomla 3.8.

Ciarán