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
Printable View
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
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 ?
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.
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