I've a Joomla 3.6 project which is built on mysql db. I want to know how can I migrate to mssql db? Maybe someone could do step by step guide and suggest some tool for migration?

1 Answer 1


You gonna have many problems with that. First of all almost all extensions run on MySQL and they are not prepared for MSSQL. Other thing is that Joomla! MySQL database is a bit complicated and can break after converting.

You can try it like this:

  • Create a copy of your website files on other account, on that one we'll do the test
  • Export website database from phpMyAdmin using a capability mode to MSSQL
  • Import the database into your MSSQL server and create proper credentials
  • Change db driver to mssql and credentials in configuration.php to your new credentials
  • Enable system debug and pray

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.