I wanted to connect my magento store to MS SQL.I was searching online for this weather this is possible or not.

Here http://devdocs.magento.com/guides/m1x/system-requirements.html i saw that Magento Enterprise Edition will support Oracle or Percona as well but i am not sure whether Magento EE will support MS SQL.

If we can connect magento with MSSQL please let me know how can I achieve this

why I want this is I have one of my site in the .net and using mysql and I want to use that database.


Magento uses the Zend DB adapter to connect to a database. I guess since that accepts MSSQL it should theoretically be possible but it will probably require you to make quite a lot of custom queries in Magento compatible with MSSQL syntax.

I would suggest using MySQL to prevent issues.

  • ok can u suggest on i can use mysql and when thr are orders or any customer registration will trigger into the mssql database – Pradeep Sanku Dec 10 '15 at 10:10
  • I guess you would have to write a migration script that queries to MySQL database and writes that into the MsSQL database, perhaps run it every 5 minutes or so – Sander Mangel Dec 10 '15 at 10:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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