Skip navigation

This Question is Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
1,690 Views 4 Replies Last post: Apr 28, 2009 11:16 AM by Ben Mehling RSS
Durga Contributor 8 posts since
Apr 27, 2009
Currently Being Moderated

Apr 27, 2009 4:33 AM

converting mumps to sql server

Hi all,

 

How to convert mumps database to SQL Server(or Oracle or MySQL or Sybase) database in OpenVista?

(or)

How to understand the OpentVista - MUMPS database(Hierarchy Relationship)?

If anyone know this please help me...,

Thank You...,

Andy Pardue Medspherian 145 posts since
Sep 11, 2008
Currently Being Moderated
1. Apr 27, 2009 7:15 AM in response to: Durga
Re: converting mumps to sql server

Hello Durga,

 

Converting mumps to other languages/database platforms is something that has been discussed a bit recently.  If you are familiar with the hardhats group (google), you might have seen the post that started a lengthy discussion (http://tinyurl.com/c2tl65).   This discussion started because of a company who purports to be able to convert VistA to java/rdbms. (http://www.mumps-migration.com/).  My personal opinion on this is that such a large scale conversion is likely fraught with unintended, unmanageable side affects, but I wish them well all the same.  Mentioned on this thread (I think) are some other tools that can expose mumps constructs relationally (PIP from GT.M and KB_SQL).  PIP is free and open source while KB_SQL is a commercial offering.

 

My preference is to think of OpenVista as a datastore that already has some relational capabilities and find ways to make it more accessible to non-mumps realms.  We have recently released a tool that we use in this manner.  You can find more information about it at http://medsphere.org/community/project/ovid.  If you prefer .net/C# you might peruse the Bridge component of CIS as it might meet you needs.

 

As you probably already know, VistA contains a psuedo-relational data access layer, written in mumps, called FileMan whose arrangement and data structures are often quite similar to what you would find in a relational system.  FileMan is the core for data access for VistA applications, so the more you can learn about FileMan, the better off you will be.  You can find docs here.   It is worth the investment of time to learn a bit about FileMan, IMO -- but you'll probably be able to determine in a short amount of time if FileMan internals are something that you are interested in.

 

Good luck,

 

Andy

Ben Mehling Medspherian 114 posts since
Jul 24, 2008
Currently Being Moderated
4. Apr 28, 2009 11:16 AM in response to: Durga
Re: converting mumps to sql

any one done the converstion of mumps to sql server?

as per my knowledge it was not developed.

and i am working for Cyber Technology Solutions.

i want to know which companies are working on this?

and how much they have done?

actually  i have very much interested in conversion of mumps to sql server.

our company wants to develop the same.

 

As Andy suggests above, we are aware of a company that focuses on converting M to Java and SQL.  He's provided a link to that company above.

 

Recently on Hardhats, there was a long thread regarding a news article about some migration efforts going on within the Department of Defense.  You can view that conversation (w/ link to the article) here: http://tinyurl.com/dj3d92

 

We are not currently working on any such project to convert M to another language and it is unlikely that we will in the future.

 

Good luck!

More Like This

  • Retrieving data ...

Bookmarked By (0)