Data forms the bedrock of our daily lives, as a lot of day-to-day decision-making is hinged on its existence. Just like energy, data can be transformed from one medium to another. So far, web development has become much more advanced, and data migration a
Data forms the bedrock of our daily lives, as a lot of day-to-day decision-making is hinged on its existence. Just like energy, data can be transformed from one medium to another.
So far, web development has become much more advanced, and data migration and backup is an essential skill every web developer should have to help ensure continuity of data and preserve user information regardless of any circumstances.
For developers like me who prefer to test all their code features locally in a development environment before final deployment to the cloud, this tutorial would come in handy for you when faced with the challenge of migrating your locally stored MongoDB data to a cloud platform or any other platform.
The inspiration for this article is a result of the need for me to migrate the total JSON data on my local MongoDB Compass server to the cloud (MongoDB Atlas) for an ongoing project. I waded through the endless internet resources and documentation but couldn’t get a suitable, straightforward fix. With multiple trials and errors, I was able to succeed with the migration. This article should serve as the definitive guide you need to save you time and achieve fast results.
In this article, we'll delve into data management in MongoDB, data backup, and efficient data migration tools that ease up the entire process. This article is suited for people with intermediate to advanced knowledge of MongoDB and backend development.
If you have any difficulty with the terminologies used in this article, I would suggest studying the MongoDB documentation here .
Let’s begin.
MongoDB is a non-relational NoSQL-based database that stores data via the document model in a JSON format. It’s quite popular, and ranks top among the most used databases worldwide.
It's also more code-friendly as it's currently the default database used by many JavaScript-based full stack and backend developers.
It has various database options, comprising both local database servers and a cloud-based Database-As-A-Platform.
A good example of this is the MongoDB Atlas. MongoDB Atlas is a flexible and scalable MongoDB implementation with strong cloud security.
It provides indexing, load balancing, and sharding, among other features. More information regarding it can be found here .
You should have the MongoDB local server already installed. However, if you haven’t installed it, it can be downloaded here .
The MongoDB server can then be easily executable by adding its path to the environmental variables on Windows.
To initialize the MongoDB application, activate the command prompt and type in
Mongod
MongoDb server running
To explore the databases on the MongoDB server, open the MongoDB command shell and typeshow dbs
The databses on the MongoDB server
This displays all the databases on the MongoDB server.
With this, let's go on to migrate one of these databases to the cloud.
To efficiently upload the database collections to the cloud, they must first be backed up.
To back up your database, you'll have to install an additional tool. Navigate back to the MongoDB downloads site and download the MongoDB database administration tools .
This package contains a lot of database tools, such asMongoExport
,MongoImport
,MongoDump
, andMongoRestore
.
The above settings are applicable for users who have a version of MongoDB above version 4.4. MongoDB decided to release it as a stand-alone tool. For users whose version is less than version 4.4, these tools can be pre-installed in the MongoDB package.
Now, let's go on to the two major tools that would help facilitate the migration process:MongoDump
andMongoRestore
.
WhenMongoDump
is executed on a database, it helps to create a backup database file in a binary-encoded JSON format (BSON). While theMongoRestore
helps to return the backed-up database to MongoDB for usage.
Moving on, ensure that their package path is included in the environmental variables so as to guarantee efficient execution.
In order to back up a local database, open the MongoDB shell and then enter this command:
Mongodump --db= --collection= –out=
With this execution, you have successfully backed up your local MongoDB database.
MongoDB Atlas is MongoDB cloud Database-As-A-Service cloud option accessible to its users at all times with little to no disruption.
Also, for most production apps that utilize the power of MongoDB on the server as a database tool, the easiest and most convenient provider of this solution is the MongoDB Atlas.
Hence, it is our choice to back up our MongoDB data to the cloud. I would assume you already have a MongoDB Atlas account, but you can still create one and then create a database that would serve as the recipient of the local database.
To set the account up, kindly navigate to the Atlas home page here . Create an account and you'll be directed to a dashboard where you can create new databases.
MongoDb Atlas home page
You can, however, name it with any name you want. To complete the upload of the local MongoDB data to the cloud, navigate to the settings tab on the MongoDB Atlas database and click on the migrate data option. With this successfully done, let's now go on to complete the migration process.
To migrate your backed-up database to the cloud,MongoImport
andMongoExport
will be invoked.
In the command prompt, paste the migration code copied from the Atlas, and then execute it on the command prompt. With that, you should see a success text.
You can then check and refresh your cloud database to see the new files that have been uploaded there. Thereafter, you can connect the new cloud database to your backend application and run it successfully to get the same results on your local computer.