Data transfer between diff collations | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data transfer between diff collations

Hello, I need to transfer data between 2 SQL Servers.
The source server’s collation is SQL_Latin1_General_CP850_CI_AI NOT NULL. The destination server’s collation is SQL_Latin1_General_CP1_CI_AS. Ive read that data transfer between servers of different collations may result to data loss. Is there a way of knowing or testing if such data loss issue can really occur (in this case)? What is the difference between the 2 anyway? if i do the data transfer, is it necessary for me to issue a COLLATE statement or is this done by SQL internally? Thanks a lot! rache c", )
All the nessesary details are here —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

Have you tried with DTS? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.