Copying data between two schemas

[slimdave]

Have you considered setting up replication between the databases? It would get around the issue of the script entirely.