CODEWITHSUNDEEP
sql-serveroracle-databasedump
sangi
sangi

Reputation: 531

Periodical dump of SQL Server table to Oracle table

I have a request to dump periodically, every 15 minutes, data from a SQL Server database and move it to an Oracle database.

This activity will go under a scheduler like Tivoli.

Have Oracle or SQL Server some way to do this? Or, is there some product or workaround to satisfy this request?

Thanks a lot in advance

Upvotes: 1

Views: 109

Answers (2)

Remus Rusanu
Remus Rusanu

Reputation: 294407

You can set up replication from SQL Server with an Oracle subscriber. This will keep the Oracle table up to date in real-time, changes applied to the SQL Server table are immediately applied to the Oracle table as well.

Upvotes: 1

billinkc
billinkc

Reputation: 61249

SQL Server Integration Services sounds like a good starting point

Upvotes: 1

Related Questions