You could write a SQL Script to find and replace all the instances where it exists in the tables. The tables you need to look at are sf_CmsControlProperty
And I think that is it.
Alternatively, and this is they way I did it, to deploy my Databases to the production server I use the SQL Server Database Publishing Wizard
. Which basically creates a script to recreate all your tables and their data. Once it is has created that script I open it in SQL management Studio and do a Find and Replace in there, and then run the script on the production server. Of course this way you have to do it before
Hope that helps