M2SQL is a handy tool that permits to map your existing Mumps Globals in a relational Vision. The mapping process is simple and intuitive and is done only once. The Mapping process will describe the Mumps Globals data as a complex of Applications, Hierarchies, Relations and fields.
Once mapping is completed you will able to replicate all the Mumps data into Target Relation database such as SQLITE or MYSQL.
Normally you will do the replication process once a day while system is silent. This will give you a Relational Replication for Reporting or Business Analysis using industry standard tools.
If you have a huge amount of data on your Mumps Globals you can choose an alternative mechanism in which only changes
will be replicated to the target relational database and reflected almost immediately .
The tool is a set of Mumps Routines and globals written on top of Intersystem IRIS , but using only pure Ansi standard Mumps .
Features
- Map your Existing Mumps Globals in a Relational Vision
- Validate your Globals Data vs Mapping Validation Rules
- Generate documentation of your Mapped Globals
- Generate DDL Schemas for Target Relational database
- Replicate entire data base to Target Relational Data Base
- In case of Huge Mumps DB , Replicate only Your on going changes via Journaling Mechnism