Skip to Main Content
  • Questions

  • Schedule a job to migrate the data from SQL Server to Oracle

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Ankit.

Asked: June 06, 2017 - 9:16 am UTC

Last updated: June 06, 2017 - 1:40 pm UTC

Version: 11.2

Viewed 1000+ times

You Asked

Hello Experts,

Is there any way with which I can schedule a job to migrate a data from MS SQL server to Oracle database on daily basis?

Please suggest.

Thanks,
Ankit

and Chris said...

There's a couple of options you can look into:

Heterogeneous Services

This enables you to query the data in SQL Server over a database link. So you need to write queries to extract the data you want.

https://docs.oracle.com/cd/B28359_01/server.111/b28277/toc.htm
https://docs.oracle.com/cd/E82638_01/GMSWN/database-gateway-for-sqlserver-introduction.htm#GMSWN100

GoldenGate

GoldenGate enables real time replication between databases. So you can continually apply the changes, rather than wait for a daily refresh.

http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html
https://docs.oracle.com/goldengate/c1221/gg-winux/GIMSS/toc.htm
https://docs.oracle.com/goldengate/c1221/gg-winux/index.html

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Need more information

Ankit Bhatt, June 06, 2017 - 10:48 am UTC

Thanks for the answers Chris but as prerequisites to install Oracle database gateway, it can install only on below OS,


•Windows 2000 with service pack 1 or higher. All editions, including Terminal Services and Windows 2000 MultiLanguage Edition (MLE), are supported.


•Windows Server 2003


•Windows Server 2003 R2


•Windows XP Professional

I am using Windows 7.

Is there anyway, I can install Oracle DB gateway for sql server in Windows 7 and try Heterogeneous service to transfer data from SQL server to Oracle DB?

Waiting for your reply.

Thanks,
Ankit.
Chris Saxon
June 06, 2017 - 1:40 pm UTC

This document:

http://www.oracle.com/technetwork/database/gateways/certmatrix-168347.pdf

Shows the following supported Windows platforms:

Windows x64: 7, 8, 8.1, 10, 2008, 2008 R2, 2012, 2012 R2
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.