I have an Oracle 9i in my server and MS SQL Server 2017. I wanted to link the Oracle database to my MS SQL. I am trying to add the Oracle Database to MS SQL as a Linked Server.

  • Please explain further what link means to you? move data from a DB to other DB? how to migrate data? – GiannakopoulosJ Sep 12 at 7:45
  • @GiannakopoulosJ I am trying inserting data to Oracle database through MS SQL – Lawrence Agulto Sep 12 at 7:46
  • @GiannakopoulosJ or inserting data in my MS SQL Database and moving the data inserted to the Oracle database – Lawrence Agulto Sep 12 at 7:47
  • There is a tool SQL Server Migration Assistant that allows you to migrate data from Oracle->MSSQL but you want vice versa. It seems that you have to create a mechanism of extract/load customized for your need. – GiannakopoulosJ Sep 12 at 11:07
  • @GiannakopoulosJ I am trying to query insert data from MS SQL database to Oracle is that possible? – Lawrence Agulto Sep 13 at 0:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.