We are migrating 3 databases tables from Sql Server 2000 to a new sqlserver 2014.
I know that for new databases the recommended Collation for spanish is Modern_Spanish. But what is the recommendation for migrating database to a new server? Create the new server with the same collation of the 3 Databases (Latin1_General)? Or migrate the current dabases to Modern_Spanish.
The current sql server 2000 where the 3 databases are running the default collati is Latin1_General as the 3 database.
Is it worth to create the new server with Modern Spanish collation, and migrate databases collation to Modern Spanish? Or it's better to continue with Latin1_General ?