Automate the process of transferring a Microsoft SQL Server .bak file to MongoDB
I'm looking to automate the process of transferring a Microsoft SQL Server backup file (e.g., bulk.bak) that's uploaded from the frontend to the backend. Once it's in the backend, I want to automate the backup of this file into MongoDB. Essentially, I want a seamless workflow for taking a SQL Server backup file and storing its data in MongoDB.
If anyone have solutions? . Like is it possible to convert .bak to .json .
3 Replies
why would you convert it to json?
and why do you want to store a sql server backup inside mongodb?
You want to turn a relational database's backup into a non-relational database?
Besides some arduous manual work I don't see it working
You'd have more luck migrating to Postgres, MariaDB, hell SQLite even
If you really really really really want to use it, use a SSIS package, or if you're prepared for the cloud something like a data factory ( azure ).