CODEWITHSUNDEEP
sqlruby-on-rails-3heroku
user1051849
user1051849

Reputation: 2337

Rails 3 & heroku - cloning table between databases

I have local machine that does a load of data processing before pushing the resulting data up to heroku using db:push and taps - this is clunky, but pretty fast. The problem is that taps is pretty flaky and is nolonger supported with toolbelt.

One option is to run the results up to production as they are generated - on the fly - by using a connection string and something like:

ActiveRecord::Base.establish_connection(:production)

Is there a way I could use something like raw sql:

CREATE TABLE new_tbl LIKE orig_tbl;

but where the new table is on different db connection? ....

Or is there a better method for cloning a local table and pushing up to heroku?

Thanks!

Upvotes: 0

Views: 52

Answers (1)

catsby
catsby

Reputation: 11342

You could dump the table from your local and pipe the file into your remote, similar to what I outline here: https://stackoverflow.com/a/16151503/95741

Upvotes: 1

Related Questions