News

Data General Releases SQL Server Migration Tool

Data General Corp. (www.dg.com) 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.

Featured

  • Phishing Tops Concerns in Microsoft Study of Remote Work

    Potential phishing attacks were a top concern of most IT security professionals when organizations switched to remote-work conditions early last year.

  • How To Configure Windows 10 for Intel Optane Memory

    Intel's Optane memory technology can significantly improve the performance of your Windows 10 system -- provided you enable it correctly. A single mistake can render the system unbootable. Here's how to do it the right way.

  • Microsoft and SAP Enhance Partnership with Teams Integration

    Microsoft and SAP this week described continuing partnership efforts on Microsoft Azure, while also planning a Microsoft Teams integration with SAP's enterprise resource planning product and other solutions.

  • Blue Squares Graphic

    Microsoft Previews Azure IoT Edge for Linux on Windows

    Microsoft announced a preview of Azure IoT Edge for Linux on Windows, which lets organizations tap Linux virtual machine processes that also work with Windows- and Azure-based processes and services.

comments powered by Disqus