SQL Collation and migration
Posted on 2008-06-23
I have a MS-SQL server that uses SQL_Latin1_General_CP1_Cl_AS as its default collation. Now, I want to export the whole database to another brand new SQL 2005 server, to which I can apply whatever collation I need.
So now I have two simple questions:
1. AFAIK, that collation uses Latin characters; character insensitive; accent sensitive. However, for my purpose an accent insensitive collation might be more appropriated. The Latin characters are also a must. What type of collation do you suggest that I assign to the new server?
2. How can I export that database (I was requested a dump file) so that ir "converts" the data to the new database collation method I decide to use (after your suggestion)?
Thanks in advance and best regards,