data connection from destination to source RRS feed

  • Question

  • "destination sql server 2008 collation sql latin 1"


    "source sql server 2008 collation chinese latin"

    how to link this both server to get the data from destination to source?

    Friday, September 14, 2012 1:56 AM


  • Hello,

    If you use in both databases NVarChar (Unicode) data types, you can copy the data from source to destination without any changes. The collation regards only Non-Unicode text.

    Olaf Helper
    Blog Xing

    • Proposed as answer by Papy Normand Saturday, September 15, 2012 8:09 PM
    • Marked as answer by Papy Normand Wednesday, September 19, 2012 9:11 PM
    Friday, September 14, 2012 4:11 AM