The errors you have suggest that you have connected to both databases for the copy.
But you are getting multiple primary key errors.
That suggests that the tables you are copying into aren't empty and already have the rows you are trying to send.
Are you doing the copy twice or maybe your destination is set to be the same as the source.
Anyway it looks like you have multiple problems here.