[U2] Re: migration of old UV application on old Unix Server being replaced

2005-03-15 Thread Scott Richardson
Hello Howard,

Welcome! You are on the right track and in the right place.
In your original post, your assumptions #1  #2 are correct.

There are many methods available.

It would be most helpful if we know the platform manufacturer and model, the
exact OS version, and the exact version of UniVerse.


- Original Message - 
From: Wong, Howard [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, March 15, 2005 9:45 AM


 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/


RE: [U2] Re: migration of old UV application on old Unix Server being replaced

2005-03-15 Thread Piers Angliss
snip
but I doubt the manager would have the appetite to spend good money just to
be able to read the very old data. /snip

snip from your website
CIBC History

The largest merger of two chartered banks in Canadian history happened on
June 1, 1961 - The Canadian Bank of Commerce (established 1867) and the
Imperial Bank of Canada (established 1875) merged to form the Canadian
Imperial Bank of Commerce (CIBC). Its history spans nearly two centuries and
is full of adventure and enterprise. /snip

So, you're not exactly short of a cent or two then 

If the manager wants to access the data he's probably going to have to spend
some money, good or bad

1. If nobody knows the structure of the data then unless it's very simple
migrating to another dbms it will take a bit of time and money - the
mechanics aren't difficult but restructuring could be. You then have to let
your users access it without the old application s/w

2. Keeping it in Universe is simple, you just have to get onto an up-to-date
platform. It is possible (but unlikely) that the old version of Universe
will run on an updated version of the same OS but that may cost you for
proprietary h/w  OS, alternatively get a new version of universe to run on
Windoze or Linux and minimise the h/w  OS costs (sorry, just joking about
Windoze).

How many concurrent users do you need, what make / model of hardware is it
on now, what OS and what version
Do you know what version of Universe it is running now (or how to find out
?)

Piers
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/