On another note, I am using SP Upgrade plugin to do the migrating and there is an issue with the jos_comprofiler table.
I can see all the users (around 680) of them in the table via phpmyadmin but when I look at the user management tab I can't see half of the users. And i have already synced.