Re: Can heroku db:pull & db:push specify tables?
On Nov 3, 7:42 am, femto 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 her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Re: Can heroku db:pull & db:push specify tables?
Yes it can. heroku db:pull --tables users,messages should do it. On Nov 3, 11:42 am, femto wrote: > Hello all, I need to sync some tables between server and local, > Can heroku db:pull & db:push specify tables? > I look thru taps documentation, found it can specify tables and > filters,like > --table blahblah or --filter blahblah, > but in heroku's documentation, I cannot find related description. > can heroku support this? -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
Can heroku db:pull & db:push specify tables?
Hello all, I need to sync some tables between server and local, Can heroku db:pull & db:push specify tables? I look thru taps documentation, found it can specify tables and filters,like --table blahblah or --filter blahblah, but in heroku's documentation, I cannot find related description. can heroku support this? -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.