Post reply

SQL Server Collation

  • July 11, 2002 at 4:58 am

    #58284

    How can you synchronize data in 2 SQL Servers with different collation settings.

    Thanks

  • July 11, 2002 at 6:07 am

    #432436

    When you say synchronize are you talking data only or replication situation. Have you tried copying the data over or using a linked server to compare the data and mae changes, if so what happens?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • July 11, 2002 at 9:07 am

    #432481

    I am talking of data for now. I have inherited 3 SQL servers with different collation settings. The 3 servers need to have their data synchronized on a daily basis. I hope to later do this through replication. For now, i have got to find a way of making the data the same. MS says I have to reinstall the SQL Server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply