Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sql Server Update from Oracle 9i preference ?

Status
Not open for further replies.

saustin

MIS
Feb 19, 2001
336
US
Hi,
Have set up a nice database link to a sql server box from an Oracle 9i server. My mission is to populate a sql server table with an record from an oracle table after an insert. Is the best way to do this just a insert trigger or is there a better way ? Only expect about 100 records a day but the "live" timing is critical.

Thanks, Steve.
 

Trigger on INSERT. [3eyes]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top