Magento – Connect Magento with MSSQL

databasemagento-1.9mssql

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.

Best Answer

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.

Related Solutions

Magento – Magento using Postgres

Support for anything other than MySQL is not planned as of now and based on my understanding it is not easy to support anything else right now. You would have to change at least all installation schema, some data types and more.

Database – Setting Collection Sort Order to a Specific Value

Try

$consultantCollection->getSelect()->order(new Zend_Db_Expr("`firstname`='Peter' DESC"));

Should result in

Select ....  ORDER BY `firstname`='Peter' DESC

Test Code

$customerCollection = Mage::getModel('customer/customer')->getCollection();
$customerCollection->addNameToSelect();
$customerCollection->addAttributeToSelect(array('firstname', 'lastname', 'email'));
$customerCollection->getSelect()->order(new Zend_Db_Expr("`firstname`='Peter' DESC"));

foreach ($customerCollection as $customer) {
/* @var $customer Mage_Customer_Model_Customer */
echo $customer->getFirstname() . ' ' . $customer->getLastname() . PHP_EOL;
}
       // 

echo $customerCollection->getSelect();

Best Answer

Related Solutions

Magento – Magento using Postgres

Database – Setting Collection Sort Order to a Specific Value

Related Topic