• As it is a side-by-side migration, what you need to do is start testing your data to make sure the collation is compatable and translatable before the migration starts.

    You could restore the databases to the new server, but that won't change the database collation. You'd need to actually go through each database and run the collation change through the ALTER DATABASE command.

    And you have to watch out for that individual table (and possibly column) collations that might get changed but should remain the with the old collation.

    Look up collations, [SQL Server] about collations in Books Online. There's a lot of information there that you should know before you do this.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.