>Hi All,
>
>I have used SQL Server a lot but never touched Oracle. Now I have an Oracle 7.3 database that I want to transfer to SQL Server. Since my development machine is Win XP, I am told that I cannot access Oracle from it and I cannot find old Win 98 machines to use. Are there anyway I can use MS SQL Server DTS to transfer the dada? Also, I don’t mind to pull the Oracle data into dbf first. What is the trick to set up the connection? After I get the data I will simply forget Oracle, so quick and dirty solutions are most welcome! TIA
>
>Chen
Chen
Firs of all MS SQL server has tool export/import ( and to Oracle too)
Oracle and MS SQL server can be at different computers with different windows version
And Oracle can be just on UNIX
All you need to have IP connection between these computers
Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.