I want to convert that database to SQLSERVER database

[vijay_chukka]

I am using Oracle database to retrieve some data. Now i want to convert that database to SQLSERVER database. Is it possible to convert and retrieve data from Sql server. If possible. Give me the detailed solution.

Thanks & Regards
vijay

[debasisdas]

what do u mean by convert that database to SQLSERVER database.

Do u want to copy certain tables from ORACLE into SQL SERVER or what ?

[CSOOR]

Question is not clear, but what i understood you want to copy into sqlserver. So just extract the data from oracle with some delimitor and BCP in into the sqlserver having tables with same layout.

[phanikanthmn]

Hi

I din't understood the question. I came to know that you want to move the databse from oracleDB to SQL Server DB.
try following steps I hope it make works

1) first of all open MS-Access and import the data from oracle database later export the data to SQl Server DB

Regards,
Phanikanth