I'm trying to upgrade a client's site on test machine to verify all is ok. The idea is the to restore the upgraded copy on top of the one existing on the server.

The DB collation on the server is CI_AI (case insensitive, accent insensitive) while the one on the test server is CI_AS.

I don't have any server aroun with the same collation as the client's db and I cannot create a test site on the production server.

If I script the DB and change the collation then I'll be in trouble when uploading the backup on the production server I think.

Any options to get around this?