On Nov 3, 7:42 am, femto <[email protected]> wrote: > Hello all, I need to sync some tables between server and local, > Can heroku db:pull & db:push specify tables?
Not that I'm aware of with heroku db:push. However, using Rails, you could use seed data as a (much more involved) way of accomplishing the same thing. Here's Ryan Bates video segment on the topic: http://railscasts.com/episodes/179-seed-data If the table itself has been changed (change of attributes for instance) then naturally you'll need to do a heroku rake to do a migration drop and then migration up of the table itself. If you go this route - a suggestion which I'm sure you would do - but just in case - be sure to do a full trial run of the whole sequence on your dev machine - table down using current migration file, table up using a new modified migration file (for the case where you are modifying the table structure) and finally creating a csv seed file (sqlite web site has tool for this) http://www.sqlite.org/download.html and then the creation of the seed.rb file (again see Ryan Bates segment). Only reason I mention this is it took me a good number of tries on my dev machine to get everything to work and get the result I wanted - there were some subtle issues with the way sqlite was creating the csv data - at least to me they were. It'd be great to have heroku do one table pushes - maybe an enhancement if it's not yet possible - please ... -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
