moving Great Plains to server with different collation?
Posted on 2006-05-22
We have a db/app server hosting Great Plains 8 that is having hardware problems - rather than repairing (it's an old machine) or replacing it, I'm considering moving GP over to a much newer server with plenty of overhead. The potential problem is the two SQL servers (both are MSSQL2k, one SP3, one SP4) use different collations - Great Plains is running on SQL_Latin1_General_CP1_CI_AS (case insensitive) while the server it needs to move to is using Latin1_General_BIN (case sensitive).
My questions are - can the db be converted to another collation, or......would GP function correctly in a case sensitive environment? Alternatively, I know the collation supported is fairly granular and can be set at different levels, but can a particular database use one collation with the rest of the server using a different one?