Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-19 : 09:27:04
|
| Umer writes "Hi,What I want to do is to move away from my current Open VMS V6.2-1H3 to the Windows 2000 platform . First step I need to take is to run both platforms together. For this I need to replicate data from the Open VMS V6.2-1H3 server to Microsoft SQL Server 2000 real time. What is the best way to go about it? And for that matter, If i go for DTS or stored procedures, is there an OLEDB driver available for VMS?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-19 : 09:42:38
|
| This is the best ODBC driver site I've ever seen:http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htmThere's also a link for OLE DB drivers.I don't see anything there specifically for VMS systems, but there might be some way to bridge the two using an intermediate format.As for running both systems at the same time, that's gonna be REALLY tough without using replication, especially if there are no ODBC/OLE DB drivers for you to use. You may have to seriously consider outputting data to text files and importing them into SQL Server, or...just migrate straight to Windows and abandon VMS. |
 |
|
|
|
|
|
How do I migrate data from an Open VMS V6.2-1H3 to Microsoft SQL Server 2000?