I would like to migrate a web application that uses PHP PDO and MySQL as a data backend. I have no prior SQL Anywhere or Sybase experience.
Possible Design 1
SQL Anywhere -> ODBC -> PHP PDO -> Web Application
Possible Design 2
SQL Anywhere -> SQL Anywhere PHP Module -> Web Application
What are the merits and limitations of each design and how well are they supported? Is there a better approach? Which downloads and documentation links do I need to get started with each approach?
It was hard from an online search to tell which links and documentation are most up-to-date and relevant. Are my assumptions below correct?
Just a few comments - I've only used PHP/SQL Anywhere for some testing...:
Have you read the following whitepaper? (It deals with v11 but should work with v12, too)
And there's the particular SQL Anywhere PHP Developer Center
Whether you prefer to use the native SQL Anywhere driver or PDO might also depend on the question how much code must be adapted - AFAIK, the native driver uses SA-specific functions like sasql_connect() and therefore you will need to adapt your MySQL function calls, methinks. On the other hand, native MySQL function calls are different from usual PDO calls, too, so in case you have not yet used PDO at all, you will inevitably have to change function calls (and possibly queries, too)...
answered 02 Nov '12, 12:08