PDOException: SQLSTATE[42000] Implicit conversion from data type nvarchar to varbinary(max) is not allowed
I've figured out the main problem, when I was using the SQL migration tool to migrate, it was creating a database, so I devided to create mine to check. The one created by the tool was Latin1_general_CL_AS and mine was SQL_Latin1_General_CP1_CI_AS instead. That seems to have fixed the problem