Hedley,

<< Perhaps I may not have explained this correctly in the original post? I
*only* want to copy one table between databases. Both databases have
identical structures. >>

Ahh, sorry.  In that case you'll have to create the destination table in the
target database, and then copy the rows over with a INSERT INTO..SELECT
statement.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< There have been posts about this before and Tim has been asked about a
facility to bring tables and catalog into sync but I don't remember his
reply. It might be "it'll be in 2.x" but I really can't recall. >>

That was more along the lines of a diff facility for the
reverse-engineering, and deals with the structures of the databases, not the
data.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>That was more along the lines of a diff facility for the
>reverse-engineering, and deals with the structures of the databases, not the
>data.

Good job one of us remembers

Roy Lambert