Data Migration from VAX to sql-server
-
Plz suggest
how can i migrate data from vax system to sql-server
thanks
-
That's kind of like saying "from Windows"... it covers a lot of ground.
If you are using Rdb, there are ODBC connections to it which (though I have never done so) I presume could then be used directly with DTS. Also, RDB permits formatted extracts (RMU/UNLOAD if I recall).
If you are not using Rdb but Oracle, the same should be true about ODBC connections.
If you are using RMS to store data it becomes a lot more problematic as it will depend on the format and type of data. RMS data is frequently not ormalized (for example). Generally this is going to take writing a program (usually in whatever language the data is being maintained) and extracting the data to an intermediate file. Tab separated values are easy to import and generally avoid the problems with commas and quotations in text data. Then just move the data over.
If the "move" is the issue, FTP is probably simplest, move the file over and then import. Most VMS systems have some kind of TCP stack where FTP is supported. If you have Pathworks or Samba you can just map a drive.
There are programs which provide ODBC type links to RMS data, but unless you already have one it is almost certainly more trouble to set up than just extracting the data (and more expensive).
-
VAX !!?!?!!! Nightmares are returning
The suggestions above are great. I'd use DTS to script out the moves using one of the techniques above.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply