Using the import/export wizard I end up with an annoying problem:
Error 0xc02020f4: Data Flow Task 1: The column "pinNumber" cannot be processed because more than one code page (874 and 1252) are specified for it.
Looks like a different codepage (
Latin1_General_CI_AS), so I changed those to match:
Latin1_General_CI_AS for both.
However the wizard still throws an error and detects two codepages - I even checked the tables and both source and dest show the same