Sunday, March 11, 2012

Change Collation- Migration of Data Required

Hi,

If I have a database with collation Sequence X and I change the
collation sequence of database to Collation Sequence Y , do I have to
migrate the data of tables with collation Sequence X to collation
Sequence Y or SQl server takes care of migrating the data internally.

Thanks in advance.

-Kalyankalyan (m_kalyanc@.email.com) writes:
> If I have a database with collation Sequence X and I change the
> collation sequence of database to Collation Sequence Y , do I have to
> migrate the data of tables with collation Sequence X to collation
> Sequence Y or SQl server takes care of migrating the data internally.

You will have to migrate the data.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

No comments:

Post a Comment