locked
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

Answers

  • 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