Jack, Thanks for the advice. One other reply suggested the same thing, while others think it shouldn't take much to extract the data. We'll see if any consensus come out of this.
Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -----Original Message----- From: Jay Falck [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: I have experienced this same need in the past and found it to be much cheaper to upgrade Universe to a newer version with as few licenses as possible. In my case, I know the data structure and just maintain a copy of the data without the application. If you have the source code for the application you should be able to just re-compile the application and be good to go for several more years. All in all, a great deal less expensive than trying to migrate the data to another home. My $0.02. Jay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 8:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Original Post: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/