Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Data migration with new collation

Author  Topic  ikura Starting Member 5 Posts Posted - 2009-01-14 : 22:55:09 Is it possible to migrate date from DB1 to DB2 with new collation? My problem is that some of the table’s collations are different from the DB setting. I would like to create a empty DB and copy (restore? Export/import?) all the record to the new one. What are the correct steps? Please advise. Thank you very much. KK