Data General Releases SQL Server Migration Tool

Data General Corp. ( today announced the MUMPS Data Extractor (MDE), a data migration product that helps users of the proprietary MUMPS language to convert important data to SQL Server 7. The MDE dynamically moves data from the MUMPS based FileMan system to any SQL Server 7.0 based data mart, data warehouse, or replication database.

In an early implementation of the MDE, Data General and Strategic Reporting Systems are helping the Veterans Administration Central Iowa Health Care System migrate MUMPS data from its VISTA application to SQL Server 7.0, so that users can search for and report important patient information in a more convenient manner. The MDE also allows users to create and distribute information in a far more timely manner throughout the enterprise, using commonly available reporting tools that work with the Microsoft SQL Server 7.0 database. For example, the Veterans Administration Hospital will now be able to access "live" data and produce reports within ten minutes, a process that previously took up to three weeks to complete.

"In our first experience with the MDE it took us only minutes to move an entire prescription file to a SQL Server database, and access lab data to see what costs existed in certain areas," says Jim E. Presley, Chief Information Officer at the Veterans Administration Central Iowa Health Care System. "We also quickly moved our entire patient database, sorted by county, and received information on where our patients come from, their age, and primary diagnosis. The MDE is usable right out of the box and provides the pathway from MUMPS to Microsoft, so we can do our jobs better, faster, smarter, and more efficiently."

The user can use the MDE directly on the client for interactive "quick" data retrieval. For larger jobs, the MDE has the capability to move large amounts of data from the server into a Microsoft SQL Server 7.0 database, for quality control, performance-based management, or even data backup. The MDE is slated for general availability in November.

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.


  • Feds Takes Action Against Russian Firms for Spying

    The U.S. Department of the Treasury has issued sanctions against Russia and a handful of Russian organizations for spying and other cyberactivities.

  • Microsoft Previews 64-Bit OneDrive Client for Windows 10

    A preview of a 64-bit OneDrive client for x64 Windows 10 systems is now available for work, school or home users.

  • The 2021 Microsoft Product Roadmap

    From Windows 10X to the next generation of Microsoft's application server products, here are the product milestones coming down the pipeline in 2021.

  • Microsoft Adds Data Loss Prevention Alerts to Compliance Toolbox

    The latest part of Microsoft's overall compliance tooling is its Data Loss Prevention Alerts Dashboard, now generally available.