INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

Thanks so much for having a place for us propeller heads to hang out and chat.

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > MIS/IT > Operating Systems - Hardware Independent > DEC (HP/Compaq): OpenVMS Forum

Data Migration from VMS to..

Read More Threads Like This One

EMax1 (MIS)

9 Nov 05 22:48

I copied onto a CD a few files from a VMS database (DEC Alpha VMS). I am looking for a way to read and copy the data to another database but so far I didn't find a good solution, and therefore i need to know if it is possible to find an utility or other that will allow to read these files and convert the data to something I can use on my PC.
I found a very expensive ODBC driver that could help me, but the cost (appr. $7,000) is way over the price we wnat to spend for one time use.
Even if I copied the files, with a .dat extension to a CD, I do have full access and authorization to access them from the Alpha server.
Another solution I tried was to create some query and export the data, but this would be my last solution.
Any clue or info on this would be greatly appreciated.

teknb (IS/IT--Management)

10 Nov 05 18:29

Some questions:

What is the "database" you mention
Oracle, Sybase, etc. etc.

Might it be you mean RMS (file system handler of VMS)
Index sequential Files?

kind regards,

Nico Baggus

PaulTEG (TechnicalUser)

11 Nov 05 4:12

A web interface might be the shizznit here.
Run a few queries to describe the tables, and a few more to output the data as CSV, and you can access it as text files through a PC browser.

This is most likely a problem with High endian vs Low endian numbers?

There used to be a package called Pathworks, which allowed you to mount VMS disks as visible to PC's. There might well be a GPL version in this day and age

HTH
--Paul

Spend an hour a week on CPAN, helps cure all known programming ailments

kenrbnsn (TechnicalUser)

12 Nov 05 1:12

Pathworks is still out there and is still Propietory, but samba does run on VMS and can do the same thing. Are you machines on a network? If so try FTP or even Kermit.

Ken

EMax1 (MIS)

15 Nov 05 19:54

After a few days of searching, and trying different solutions, I found an affordable software that could do exactly what I am looking for. This is a module name Model that is part of the report writer (Xentis) on his machine.
In any case, the messages posted by the users were very useful, and pushed me to investigate a little more this machine.
Thanks.
Louis

zarkon4 (MIS)

5 Dec 05 10:45

We use CONNX, it allows us to access data through ODBC or OLEDB. Just go to http://www.connx.com/index.asp

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To DEC (HP/Compaq): OpenVMS