Our application uses SQL 2005 database with Latin1_General_CI_AS as collation. There are nearly a million records in this database.
I need to move my data to another SQL 2005 server which has 'SQL_Latin1_General_CP1_CI_AS ' as collation.
I know there would be lots of issues. Do you know what are the likely issues that we would face.
Since there are lots of modules dependent on this database, it would be difficult to test each and every component if all works ok or not.
Is this advisable to move to another database with this non standard SQL_Latin1_General_CP1_CI_AS collation?
View Complete Post