merging/updating databases

[compudude86]

ok, i took everyones advice and created individual apps for each table. now, i need a way to combine all the tables on DIST into BOOK:products, using the dataface interface. how would i go about setting this up?

[shannah]

Hi Joe,

Can you elaborate on this? So you have a number of tables in the DIST database that are all identical and you want to copy them into the products table of the BOOK database? Is this correct?

-Steve

[compudude86]

that is correct, yes. i need a sort of "one-click" way to do this. there are about 10 tables in the dist db that need to go into the one products table...

[shannah]

There may be tools available to do something like this, but the safest easiest way that I can think of is to do a dump of each table using PHPMyAdmin, put them together in a single text file, then import them into the other table also using PHPMyAdmin.

Hope this is a one-time thing as if it is a recurring process it sounds complicated - which would mean that there's a better way..

-Steve

[compudude86]

ok, thank you. thats what i originally planned on doing, but i was trying to see if there was an easier way.