One of my personal projects involves a 785 GB Microsoft SQL Server database which has been used to accumulated data for more than 7 years now.
My idea is to use it as exercise for some Data Engineer tests i wanted to do during next weeks. In that process i wanted to test different extraction techniques as their performance. One of those was to use MongoDB as target database to store these rows as documents.
When looking at the options i found that they had a tool called “MongoDB Relational Migrator”
I was really impressed by its ease-of-use and features. In a couple of clicks i had a migrator up and running. I did not changed the defaults since i just wanted to try it out initially but if offers very nice UI for doing mappings from the relational word to document based.
The migration started very fast ( the last % was actually very slow , need to check why ).