DZone
Database Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Database Zone > Copying Documents Between Buckets in Couchbase

Copying Documents Between Buckets in Couchbase

Want to copy your data from one Couchbase bucket to another? It just takes a bit of N1QL.

Matthew Groves user avatar by
Matthew Groves
·
Aug. 24, 16 · Database Zone · Interview
Like (3)
Save
Tweet
4.39K Views

Join the DZone community and get the full member experience.

Join For Free

when i’m at a user group or conference, people often come up to me afterwards with good questions. this is a great way for me to get blog post ideas: if they have a question, chances are lots of other people have the same one. it’s also a great way for me to get to know couchbase better.

this post is for one of those questions: can i copy documents from one bucket to another ?

yes! in fact, if you’ve done this sort of thing in sql, then you are not too far from already knowing the answer.

fire buckets image licensed through creative commons via paul harrop - http://www.geograph.org.uk/photo/2666296

there are command line tools to backup / restore a bucket, but for this post, i’m going to assume that what you want is to make a copy of some documents from bucket a into bucket b.

it’s as easy as using a n1ql insert .

start by creating a n1ql select to get the documents you want out of the first bucket. i’m going to show a very simplified select that gets all the documents from my default bucket. if you only want a subset, you can use a where clause.

select meta().id _k, _v
from `default` _v


since we’re copying to another bucket, we need both the key and the document itself. this query selects the document key using the meta() function and selects the document using a _v alias.

next, i’ll create an insert to put these selected documents into another bucket, which i called target .

insert into `target` (key _k, value _v)
select meta().id _k, _v
from `default` _v


an insert needs a key and a value. i have those from the select . all done.

Document

Published at DZone with permission of Matthew Groves, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Roles in Data Science Teams
  • Difference Between Data Mining and Data Warehousing
  • What Happened to HornetQ, the JMS That Shattered Records?
  • Distributed Tracing for Microservices on Elastic (ELK Stack)

Comments

Database Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo