Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

LAMP, PHP, MSSQL, ORM, JSON, SOAP, WCF, REST for CMS - Can it be done... easily.

Avatar of Adam Menkes
Adam MenkesFlag for United States of America asked on
PHPMicrosoft SQL Server 2008Web Services
3 Comments1 Solution1166 ViewsLast Modified:
There is a potential project which would require integrating a website being developed in LAP (LAMP without MySQL - Linux, Apache, PHP) in a CMS (Content Management System).

The database would be MS SQL Server 2008 R2. It will be accessed by both the website (being developed by another firm) and desktop windows applications (developed by me).

I have minimal knowledge of PHP, but I assume it has ways to connect to Microsoft SQL Server. Since the web host will be Linux, the SQL Server will be hosted elsewhere on a Windows box  I am assuming there won't be issues connecting to the database, via the IP, login and password. But, for my own curiosity, how is this done?

What would be the best way to go for large amounts of data retrieval? Would a web service be too slow? What would be the quickest way to get data, there are so many acronyms, I think I need to take a REST.

Are there ORM products for PHP to MS SQL? Would this help?
I saw http://www.doctrine-project.org/projects/orm, but I cannot tell if it supports MS SQL or you have to implement interfaces and classes (http://www.doctrine-project.org/projects/dbal/2.0/docs/reference/supporting-other-databases/en#supporting-other-databases), which is not what I would want. I want something that would work out of the box/download.

I cannot tell if Propel works with MS SQL (http://www.propelorm.org/). It appears that http://www.php.net/pdo-dblib has an experimental version.

An ORM may not be the way to go anyway.

Also, if the simple solution is to just have SQL Stored Procedures and have the PHP programmers execute them from their code, that would be fine too. In fact, that would probably work out better for me anyway.
ASKER CERTIFIED SOLUTION
Avatar of Bitsqueezer
BitsqueezerFlag of Germany image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answers