Abstract
Couchbase Server is one of the leading NoSQL databases in the document store type databases category. Couchbase stores documents using the JSON data format, which is the most flexible of data models with provision to create hierarchies of data structures. In contrast, Oracle database stores data in a fixed schema table format. The database model of Couchbase is based on Document store while in Oracle Database data is organized as tables with two-dimensional matrices made of columns and rows. In this chapter we shall migrate an Oracle Database table to Couchbase Server. A direct migration tool is not available for migrating from Oracle to Couchbase. We shall first export Oracle Database table to a CSV file. Subsequently we shall import the CSV file data into Couchbase Server using the cbtransfer tool. This chapter covers the following topics.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Deepak Vohra
About this chapter
Cite this chapter
Vohra, D. (2015). Migrating Oracle Database. In: Pro Couchbase Development. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1434-3_11
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1434-3_11
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1435-0
Online ISBN: 978-1-4842-1434-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)