New MDCMS 7.2 includes all the change management tools that IBM i shops need to modernize legacy applications and manage modern applications. 

Organizations undertaking SQL development or database modernization take note: MDCMS Version 7.2, the latest release of Midrange Dynamics’s powerful, yet affordable change management solution, delivers the change management tools you need to effectively tackle these challenging projects.

“Version 7.2 is perhaps the most ambitious update of the MD product line to date,” says Midrange Dynamics Managing Director Michael Morgan. “Although we have supported SQL development for years, SQL functionality goes even further in V7.2. This is very helpful for IT teams who are implementing SQL-based functions so they can keep their applications relevant and meet evolving business requirements with ease.” Version 7.2 includes complete cross-referencing and management of SQL databases, expanded IFS source handling, and much more.

Comprehensive Coverage for Modern SQL Applications

With MDCMS Version 7.2, developers can cross-reference every kind of SQL entity that exists across databases: constraints, functions, indexes, materialized query tables, procedures, sequences, tables, triggers, and views. It also features 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. Source statements used to create the entities, if they exist, can be pulled up from source members or the IFS.

“You are not required to use system naming; you can use SQL naming. MDCMS handles this internally. You can have your source reside in IFS or in source members, source can have Midrange Dynamics GmbH, Zugerbergstrasse 4, CH-6301 Zug This email address is being protected from spambots. You need JavaScript enabled to view it., www.midrangedynamics.com

a different name than the object, and you can share source across objects. The same source can be used to create multiple objects of different names,” says Mr. Morgan.

Database Modernization Leads the Way

Real modernization begins with the database so that development teams can reduce IT expenses, enhance their productivity, and improve application performance and scalability.

Expanded data mapping in Version 7.2 supports ongoing modernization efforts for DB2 for i databases. 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 Version 7.2, for a Physical File or SQL table developers can configure the contents to be copied into the modified format of a file.

“This happens automatically as part of the data migration in MDCMS—no special steps, post-compile commands, or custom coding (macros) required. You can control by individual file whether you apply triggers, constraints, etc.,” states Mr. Morgan.

Interface Smoothly with Subversion

Organizations using Subversion (SVN) to manage team source repositories can now request the MDCMS deployment of changes or deletions directly from the SVN perspective in Eclipse, for an easy-to-use and complete interface between SVN and MDCMS. This includes tags or a range of trunk revisions. Additionally, if an earlier revision of a file is currently requested in MDCMS, and then updated in SVN, the MDCMS request (or even entire folder structures) can easily be refreshed with the newest version.

Ease of Use, Visibility

A helpful, fully customizable escalation process for locked objects is among the many other new features in MDCMS Version 7.2. “Added visibility and automated management of object locks allows for escalated notification and/or rollbacks of unsupervised deployments. This ensures organizations can avoid unnecessary surprises the following morning—nobody else offers this degree of control,” says Mr. Morgan.

Contact an MDCMS representative in your region to learn more about these and other useful new capabilities and productivity enhancements in the latest version of MDCMS. Midrange Dynamics GmbH, Zugerbergstrasse 4, CH-6301 Zug This email address is being protected from spambots. You need JavaScript enabled to view it., www.midrangedynamics.com

About MDCMS

MDCMS IBM i change management and its MDOpen plug-in can be used with any Eclipse-based development platform, including Rational Developer for i. MDCMS is the leading change management tool for SQL development and handles deployment in mixed server environments with ease. Upgrading to a new release of MDCMS is accomplished with a single click.

Worry-free TurnOver Migration

For companies that wish to move from legacy TurnOver change management software, MDCMS’s automated TurnOver migration quickly maps all TurnOver projects, tasks, subtasks, promotion requests, historical object deployment information, archived source code, and active checkouts into MDCMS. It also automatically migrates TurnOver create command overrides for active and historical object requests. Test and rollback the migration until you are happy with how everything is presented in MDCMS, with no risk to existing applications.

Companies around the globe are successfully using MDCMS, MDOpen, and the MDWorkflow Web-based project management system to manage, audit, and distribute updates for third-party software packages and in-house applications. MDCMS is certified Sarbanes-Oxley (SOX) compliant.