We have several SQL servers that interface with NAV. All the servers are running on the same collation (SQL_Latin1_General_CP1_CI_AS) with the exception of our NAV database, which is using Latin1_General_CS_AS. I would like to change the NAV database to SQL_Latin1_General_CP1_CI_AS so that it matches our other servers but I don’t see it as an option in the Alter Database dialog in the NAV client. Does anyone know if this is a license issue or some other limitation with NAV? Maybe only certain collations are available with a particular localization (we are using the US localization). Also, any other potential pitfalls that may arise when changing collation that I should be aware of? I know we will have some primary key issues because we are going from a case sensitive to a case insensitive collation.
FYI: Running NAV SP3 – migrating from SQL2000 to SQL2005 at the same time we are changing the collation