Usually collation should be same on Prod and dev. Backup of the database also contain the details of collation and while restore it will keep the same collation. The only option is ALTER DATABASE command to change the collation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."