You have several options: 1) In SSIS, in the SSIS ToolBox there is a component called Transfer Database task. 2) use the method provided [here][1] 3) use the method provided [here][2] I would probable go with 3), but that is a matter of taste. [1]: http://sqlmag.com/database-performance-tuning/seven-step-process-changing-database-collation [2]: http://www.codeproject.com/Articles/302405/The-Easy-way-of-changing-Collation-of-all-Database