Easily Manage SQL Development

If you’re doing SQL development or database modernization projects, MDCMS gives you all the change management tools you need to address new issues and new technologies. Enhanced capability for modern SQL applications includes:

  • Cross-referencing for SQL entities (constraints, functions, indexes, materialized query tables, procedures, sequences, tables, triggers, and views)
  • The ability to use SQL schema naming, filter and display objects by SQL name or SQL type, filter and display fields by SQL column name, etc.

Expanded data mapping  supports ongoing modernization efforts.  For example during a database modernization project, the IT team will need to map the data from the old DDS Physical File to the new SQL table. With MDCMS, for a Physical File or SQL table they can configure the contents to be copied into the modified format of a file.

  • You can identify unique “from” and “to” file names to support data conversion from DB2 files to SQL tables.  This built-in feature makes these transitions easy to test and implement.
  • Since you can identify the sequence in which objects are created this also allows for appropriate ordering of logical files, views and indexes.

Managing Conversion of Multi-Member Files

Expanded capabilities in MDCMS assist IT shops with multi-member DB2 files that are being converted to uniquely named tables. You simply identify the member name and link it to the new SQL table.  MDCMS handles multiple files based on the same source member cleanly and transparently so there is minimal maintenance. Strong relationship information is built into MDXREF, the application cross-referencing that comes free with MDCMS.

Turning Hours into Minutes during Production Data Migrations

Also available is a new, separately licensed module, MDRapid, which was developed in partnership with Vision Solutions.  Using advanced high availability and change management techniques, MDRapid processes DB2 data file changes, maintaining the information in SQL tables until it’s time to move to production.  This allows migration of data file changes to production in minutes instead of hours.