Kynn Jones wrote:
Is there a simple way to copy a table from one database to another without generating an intermediate dump file?TIA! Kynn
You're looking for ETL. http://en.wikipedia.org/wiki/Extract%2C_transform%2C_load -- Tom Hart IT Specialist Cooperative Federal 723 Westcott St. Syracuse, NY 13210 (315) 471-1116 ext. 202 (315) 476-0567 (fax) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend