Printable View
The data transfer from SQL Server to Oracle is implemented through link server concept of SQL Sever.
But,How the data transfer from Oracle to SQL Server will be made possible ?. Is there any concept like Linked Server ? so that we can declare the SQL Server as the Linked Server to Oracle.
Hi,
In oracle database links are avilable but the use is to connect remote oracle database. but in oracle you can write the table contents to a file and in sqlserver using BULKINSERT(or import wizard) you can copy the data.
And also using import/export wizard in SQLSERVER you can copy or move data from/to any database using odbc drivers.
with regards,
v.sathishkumar