How upsert many records from one bucket to another

Couchbase Server
,
1

I try to upsert data like this:

UPSERT INTO `deploy` (KEY meta(d).id, VALUE d) SELECT d
from cdata d where _type="best" and _scope="shop" AND  update_status= "UPDATED"

8269 mutations
The request takes about two minutes. Is there any other methods for transferring data from one bucket to another?

Thank You!

2

Other options are XDCR or eventing Examples: Using the Eventing Service | Couchbase Docs

Also use this meta(d).id not available outside select

UPSERT INTO `deploy` (KEY k, VALUE d) 
SELECT d,  META(d).id AS k 
from cdata d 
where _type="best" and _scope="shop" AND  update_status= "UPDATED"
3

But how can I know about update will by finish?