My higher level objective is to develop a way to move particular
database entries from my development platform to my staging platform and
then to my production platform.  Unfortunately, there may be reasons to
go the other way as well.  And, these entries have "owners" and also are
interconnected.  So, not only does Foo have a belongs_to :user in it, it
also has has_many :dogs, etc.  Thus most fields will just move over but
the id fields and the foreign keys will change.

One approach is some outside SQL process.

A second approach is to have sever 1 contact server 2 via ActiveResource
to move the records over.  I've not used ActiveResource before.  It
would seem to be easier to do that if server 1 could contact server 2 on
behalf of the current user instead of a specific "admin" user.  That is
mostly what I'm asking with this email: is that possible and if so, can
you point me to the documentation on how to do it?

A third approach would be to tell ActiveRecord to open a new database
connection to the other server and move the records that way.

If anyone has any other suggested approaches, that would be great as
well.

Thank you,
pedz

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to