Hi,
I have a 3 years of an experience to do work with SQL Servers.
You are having a problem with the SQL Server Collation, so it means you might have trouble with to transfer data to the different server having different collation or from application side.
Anyways, you can contact me for this, i also have configured many SQL Servers.
Thanks,
Krunal Patel,
Production DBA