Migrate Heroku Shared Database to Heroku Postgres Dev Database

shared_to_dev.rb

#
# If you've got a bunch of heroku apps running with 
# shared databases and you want to migrate them to
# heroku postgres dev databases you can use this
# ruby script.
#
# USAGE:
# ruby shared_to_dev.rb app_name
#

app_name = ARGV[0]
database_name = ARGV[1] # optional param
if !database_name
	puts "adding a new postgresql database..."
	response = `heroku addons:add heroku-postgresql:dev -a #{app_name}`
	database_name = response.match(/Attached as (.+)/)[1]
	puts "new database created: #{database_name}"
end

puts "adding pgbackups add on..."
puts `heroku addons:add pgbackups -a #{app_name}`
puts "putting #{app_name} into maintenance mode"

puts `heroku maintenance:on -a #{app_name}`
puts "backing up database..."
puts `heroku pgbackups:capture --expire -a #{app_name}`

puts "restoring backup to #{database_name}..."
puts `heroku pgbackups:restore #{database_name} -a #{app_name} --confirm #{app_name}`

puts "promoting #{database_name}..."
puts `heroku pg:promote #{database_name} -a #{app_name}`

puts "taking #{app_name} out of maintenance mode..."
puts `heroku maintenance:off  -a #{app_name}`

puts "\n\nOK OK OK! Check everything out. then run:"
puts "heroku addons:remove shared-database -a #{app_name}\n"

Wish I had seen your tweet about this. Would have save me a bit of time.