Run this on a WordPress SQL dump before importing it into your dev env

wp_prepare.rb

#!/usr/bin/env ruby
unless filename = ARGV.first
  abort "usage: #{__FILE__} file [http://host] [theme]"
end

host  = ARGV[1] || "http://wp33.dev"
theme = ARGV[2] || "twentyten"

text = File.read(filename)
text.gsub! /'siteurl','.*',/, "'siteurl','#{host}',"
text.gsub! /'home','.*',/, "'home','#{host}',"
text.gsub! /'template','.*',/, "'template','#{theme}',"
File.open(filename, "w") { |file| file.write(text) }