giorgio wrote in post #967970:
> I want to merge several identical databases together.
> There is obviously a problem in that the primary keys (id) will change
> when imported and thus any foreign keys that refer to that id will
> have to be changed as well.
> This is all doable but I wonder if there are any plugins that would
> make this sort of task easier?
Have you got foreign key constraints set up in your DBs? If not, do so
now (and use Foreigner for your migrations), and make sure cascading
updates are on. That will change the foreign keys when the primary keys
change. Then renumber your primary keys somehow and merge the DBs.
Or at least that's one idea. If it were just one table, I'd advise
doing an SQL dump and insert, but I'm not sure how that would work with
Marnen Laibow-Koser http://www.marnen.org
Posted via http://www.ruby-forum.com/.