Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replicate data from SQL Server to Oracle daily

868563Jun 13 2011 — edited Jun 15 2011
Good 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2011
Added on Jun 13 2011
4 comments
271 views