Trevor, Indeed your suggestion reflects the views of many who have replied to my post. It is the least painful and most-certain way for us to make the data available for a few more years when the app will eventually be retired.
Since we don't have any knowledge on UV, invariably we'd have to pay for outside help if we choose to extract the data instead of installing a new version of UV. Therefore I suspect the costs for both cases may come out to be pretty close. In any case, it will be the manager's call. Thanks for your thoughts. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -----Original Message----- From: Trevor Ockenden [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 5:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Dear Howard VMark was the company that developed the UniVerse Data Base product for which I have had much to do with for many years. VMark acquired Unidata and renamed itself to Ardent Software. Ardent was purchased by Informix and Informix was purchased by IBM. IBM now sell and support UniVerse. Now on another point. You say your boss may not want to spend good money keeping old data alive. Well it seems to me that if this old data is still useful and necessary then it must surely be considered current and active data. The fact that it resided in an old application is besides the point. I suggest purchasing the minimum UniVerse licences possible as this data probably only needs one or two uses accessing it at any point in time and this would keep the cost to a minimum. Hope this suggestion is useful. Cheers Trevor Ockenden Open Systems Professionals Sydney Australia m: 0414 731 634 e: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wong, Howard Sent: Wednesday, 16 March 2005 1: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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 __________________________________________________________________ << ella for Spam Control >> has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 ------- 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/