[Nottingham] Merging databases problem

David Aldred david at familyaldred.org.uk
Fri Nov 18 21:45:57 GMT 2005

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

More information about the Nottingham mailing list