I'm new to Oracle. I'm experienced with SQL Server. I have the Oracle
client software and SQL Server client software installed on my
workstation and I have tested connectivity between the 2 servers and
they see each other. Here's what I would like to do:
Send specific oracle 8i table data to specific sql server 2000 tables
at specific times throughout the day.
I'm open to using XML tools in Oracle and SQL Server. So far the only
solution I've seen is using SQLPlus and/or a 3rd party tool called
You may notice that I'm wanting Oracle to "be the boss" of when to
send the data. The reason for this is we're in a migration over the
next 1-2 years where SQL Server will no longer be used. When that time
comes I don't want to have to rewrite DTS packages from SQL over to
Oracle (I'm planning for the future).
How can I accmomplish my goal? Any help/hyperlinks, etc are welcome.