Thanks - I had seen the insert statement syntax - but there was no specific example for selecting form another bucket.
Can you please re-paste the other reference… It’s a 404 - or I can’t figure out where the url ends.
If it is this page http://blog.couchbase.com/2016/january/how-to-create-a-copy-of-your-bucket--how-to-transform-bucket-data-with-bulk-mutations-insert-update-delete-merge-in-n1ql
Ten I don’t understand how to get everything from one bucket to the other - given that select * from bucket 2 will give me data. I don’t know how to make that fit with the syntax. help 
INSERT INTO bucket1 {select * from bucket2 }
Kind regards
Martin