One thing I came across in my current Dynamics Ax 2012 upgrade project is that the database collation needs to be the same for both the databases, that is the source (4.0/2009) and the target database (2012). This might be obvious, but there is no information about this in the Dynamics AX 2012 Upgrade Guide so it took me some time to figure out why the “ Connect to source database ” in the “ Data upgrade checklist ” was giving me an error when I tried to connect to the source database. When I tried to connect to the source database I got an error shortly afterwards saying that the locale ‘1033’ is not the same as the target locale ‘1030’. After some investigation and thinking I started to look at the two databases and found out that they had a different collation. So my first task was to create a copy of the source database with the correct collation. Error message " The locale id '1033' of the source column 'NAME' and the locale id '1030' of ...