SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Getting RMS VAX Data into SQL Server


Getting RMS VAX Data into SQL Server

Author
Message
mrfleck
mrfleck
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 11

I have a series of flat files sent over from a VAX that I need to import into sqlserver. These are raw VAX RMS files (.dbs) There are control char, some binary stuff etc.. in these files. The VAX cannot turn them into a nice format for import because the processing of the conversion on the VAX takes longer than the refresh window we need for import. Does anyone know of a way to import these files? Has anyone used any conversion tools that have worked?

SqlServer 2000

Thanks in advance





Jeff Burton
Jeff Burton
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1239 Visits: 164

Options:

(1) Invest in an ODBC driver for RMS.

(2) If you have Oracle installed try using the Gateways product so that your RMS files are viewable within your Oracle db, then you can pull the data out through the Oracle db.

(3) If you have Datatrieve, convert those files to all ASCII and have SQL Server read the ASCII files in place using pathworks/Advanced-Server or FTP the files to an area where SQL Server can see them.

An old VMS-er,

Jeff





mrfleck
mrfleck
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 11

Jeff,

Thanks for the information. I quess I should have included some additional information, sorry. We will have no direct access to the VAX and they are strictly ftping the raw .dbs files to us. We will have nothing but the files to work with. Does anyone know how one might convert the files to ASCII?

Thanks,

Mike





Chris Gaskell
Chris Gaskell
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 1
I know this is a really old thread but I have a similar challenge.

Using 'The DEC DBMS Unload Utility' we can dump a number of .dat files from our old (very old!) VAX. I'm looking for a way to get at the data in those .dat files - could be into Oracle, SqlServer, CSV or whatever.

The DEC DBMS Unloadutility provides a quick, efficient method to extract the contents of databaserecords into RMS files.

RMS is a database-like binaryformat.


We're a stage further than Mikes problem of needing to deal with the .dbs files but I'm not getting far with the RMS files.

Any help is appreciated.

Thanks,

Chris
patrickmcginnis59 10839
patrickmcginnis59 10839
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18779 Visits: 7760
chris.gaskell - Tuesday, November 21, 2017 8:09 AM
I know this is a really old thread but I have a similar challenge.

Using 'The DEC DBMS Unload Utility' we can dump a number of .dat files from our old (very old!) VAX. I'm looking for a way to get at the data in those .dat files - could be into Oracle, SqlServer, CSV or whatever.

The DEC DBMS Unloadutility provides a quick, efficient method to extract the contents of databaserecords into RMS files.

RMS is a database-like binaryformat.


We're a stage further than Mikes problem of needing to deal with the .dbs files but I'm not getting far with the RMS files.

Any help is appreciated.

Thanks,

Chris


I had much better success with dbms files with datatrieve. dbms is more of a "networking" database, and using datatrieve helped propogate key candidates to be used as foreign keys in the destination. The vms dump utility might not be as well suited here. We routinely dumped dbms data into oracle, but we used datatrieve so that we could make sure that member records had the key of the owner record because while dbms links its records using a sort of linked list, when using this linked list, you had an implicit relationship which must be made explicit in the destination relational database, that's why we would propogate the key from the set "owner" to each extracted set "members" (if I remember the terminology correctly LOL)

edit: the unload routine will indeed move data so you can use the key in the "owner" record in the "member" records for each set so you can use that in your relational database.

another concern to keep in mind is that numerical data might remain in DEC's data type format in the rms files, we used datatrieve to get around that by simply formatting numbers into text.

to properly post on a forum:http://www.sqlservercentral.com/articles/61537/
lightfoot.anthony
lightfoot.anthony
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 7
CONNX for RMS www.connx-net.com/rms.htm will enable you to do this.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search