Home > IT Answers > Development > Sending Table Data From Oracle 9i To Sql Serv...
Help

Question

  Asked: Nov 14 2006   5:01 AM GMT
  Asked by: dhirendra10

Sending Table Data From Oracle 9i To Sql Server 2005 using oracle 9i Trigger


HTML, JavaScript, JSP, SQL, T-SQL, Visual Basic

My aim is to send the data from oracle to sql server 2005 whenever there is data insertion, deletion or updation in the oracle table the same change needs to happen in the sql server having the same table structure as oracle.But I am not finding any way to accomplish this task.please help me. Have thanks in advance.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Nov 14 2006  1:23 PM GMT  by randym




You could try heterogeneous services and ODBC. If have used this connecting to MS Access tables. You set up a database link to the ODBC DSN. Then your syntax would be something like "insert into table@sqldb ...."
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and SQL Server.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register