I've been trying to move an existing Drupal 7 site from a MySQL database to an MS SQL database. The tables and their contents has been successfully moved. I've seen some errors in datatypes and default values, but these has been manually altered.
The site is now working, well, almost working as it should. At the bottom of each page, I'm getting an error message stating:
PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]The data types ntext and nvarchar are incompatible in the not equal to operator. in drupal_write_record()
I've been comparing some core tables from a fresh Drupal installation, and the datatypes ar the same.
Is this a database related error or a Drupal related error? Am I even posting this question at the right place? Any help appreciated.