Replicate data from SQL Server to Oracle daily
868563Jun 13 2011 — edited Jun 15 2011Good afternoon,
I just changed jobs, and my previous employeer exclusively used SQL Server, but my new employeer only uses Oracle, and I'm just starting to learn the ropes on Oracle and could use some assistance -
The company I work for recently purchased a third party software that stores all of it's data in SQL Server. However, the data is only storedfor 45 days, and for reporting and recordkeeping purposes, they need to back it up for 3 years. Since they exclusively use Oracle, the reporting\backup servers have been built in Oracle, and it is up to me to come up with a method of copying data over from the production SQL Server databases to the Oracle databases on a nightly basis.
Thanks in advance
David