SQL Server Performance Forum – Threads Archive
Data Migration from Oracle to SQL ServerHello Gurus, As i am new to SQL Server, my qustion might be silly.. but i what to know this.
The version of Oracle: 8i and 9i and SQL Server 2000. I have to migrate the data from Oracle database to SQL Server. Can i use SQL Server DTS to migrate data from oracle database to SQL Server? If yes, Can any one suggest me the way to achieve it and the docuemnts to achieve it. Please help me.. !! as it is very urgent to me.. !! Many Many thanks in advance for the help. AB14
yes you can use the DTS for data migration
in the DTS wizard, select Oracle as Source and target as SQL Server.
Wizard will help you to achieve this
You can use Import/Export wizard as well
Madhivanan Failing to plan is Planning to fail