AdministratorJune 22, 2021 at 11:28 pm8836 Coins484 GemsLevel: Veteran
First thing to keep in mind is that any NoSQL database is a document database which makes it really difficult to automatically convert a typical relational database like MySQL to a document base db like MongoDB.
In NoSQL you have a single collection of documents, and each document will probably contain data that would be in related rows in multiple tables. The advantage of a NoSQL redesign is that most data access is simpler and faster without requiring you to write complex join statements.
If you automatically convert each MySQL table to a corresponding NoSQL collection, you really won’t be taking advantage of a NoSQL DB. This is because you’ll end up loading many more documents, and thus make many more calls to the database than needed and thus loosing simplicity and speediness of NoSQL DB.
Perhaps a better approach is to look at how your applications use the MySQL database and go from there. You might then consider writing a simple utility script knowing fully well your MySQL database design.