Hi, I am unsure this is the correct category for my message. Please feel free to point out a different destination, and I will move forward with it accordingly.
I am working with a customer with an in-house software product, a vertical domain-specific tool to build data entry tools. The entire platform is based on an SQL server. They use tSQL to handle frontend UI generation and logic side effects (basically they handle data triggers through database INSERT/DELETE/UPSERT), thus offering a set of available stored procedures. Once data is saved into the database, it triggers an update of the underlying entities and thus the UX/UI.
I want to introduce MongoDB to perform better data handling (since many entities are documents) and move them from tSQL to TypeScript to handle logic.
Are you aware of best practices/tools available to be leveraged to start this process (which will be a many-months project)?