[Nottingham] Merging databases problem

[David Aldred]

On Friday 18 Nov 2005 17:43, Martin wrote:
> "The two databases are physically identical, just contain different
> data. The issue is that several fields are of user-defined type, which
> apparently don't just get copied with a SQL "insert into db1:table
> (x,y,z) select (x,y,z) from db2:table". Some really annoyingly long SQL
> may do the trick, except that these types contains lists of indefinite
> length, and from what we've experienced, if you screw up the transfer,
> you hose the *enter* table."

Immediate thought: what's the field type going to be in the merged table?   If 
you know what field type you're aiming at, can't you programatically cast the 
existing data into the new format? 

-- 
David Aldred