• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

Moving data between Oracle to SQL Server

Hi,

We are planning to move data from Oracle to SQLServer.
Please let me know what are best ways to move data.

Thanks in advance
0
GK GK
Asked:
GK GK
1 Solution
 
HuaMin ChenSystem AnalystCommented:
1. Create linked server on Sql server, to read Oracle data. REad:
http://msdn.microsoft.com/en-us/library/ff772782.aspx
2. Use Openquery to access/read Oracle records. Read
http://msdn.microsoft.com/zh-HK/library/ms188427.aspx
0
 
GK GKAuthor Commented:
Thanks HuaMinChen,

I want keep the data always in Sync.will wait for  few more ways to move data between the server,
0
 
HuaMin ChenSystem AnalystCommented:
You can create jobs on Sql server to periodically synchronize the data, as the job may call Stored proc, that is running Openquery, inside.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
slightwv (䄆 Netminder) Commented:
There are products out there that will replicate between heterogeneous systems.


Microsoft solution:
http://technet.microsoft.com/en-us/library/ms151835(v=sql.105).aspx

Oracle solution:
http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html

There are probably others.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
SQL Server solution is Replication. You don't need extra licensing or tool to use it.
Oracle solution is GoldenGate but I never used it so I can't help you with this option.
0
 
GK GKAuthor Commented:
Thanks Vitor for update.

Up to now below are the solutions.

1.Linked server with Open quires
2.ETLS
3.H.Replication.
4.Golden gate.

Regards,
0
 
MikeOM_DBACommented:
Or you could use an open source integrated ETL tool like Pentaho or CloverETL
Both are Great! ;)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now