Abstract
MongoDB is the leading NoSQL database. MongoDB stores documents using the BSON (binary JSON) data format, which is the most flexible of data models with provisions to create hierarchies of data structures. Oracle Database stores data in a fixed schema table format. The database models of the two databases are vastly different: MongoDB being based on Document store while Oracle Database is based on the fixed table format with two-dimensional matrices made of columns and rows. In this chapter we shall migrate an Oracle Database table to MongoDB Server. While a direct migration tool is not available for migrating from Oracle to MongoDB, the latter provides an import tool called the mongoimport tool for importing data from a CSV, TSV, or JSON file into a MongoDB database. We shall first export Oracle Database table to a CSV file. Subsequently we shall import the CSV file data into MongoDB Server using the mongoimport 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
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Deepak Vohra
About this chapter
Cite this chapter
Vohra, D. (2015). Migrating Oracle Database. In: Pro MongoDB™ Development. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1598-2_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1598-2_8
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1599-9
Online ISBN: 978-1-4842-1598-2
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)