I have a PHP application using PDO for database access.
This application has to be extended to create tables in and write data to a Microsoft SQL-Server (MSSQL) database. For the MSSQL part we don't need transactions.
What are the key points to dive in for migrating existing MySQL queries to MSSQL? Will it be done by switching the PDO database driver or are there differences in SQL dialects when INSERTing data or in login procedures?