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.