• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • 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
 
HuaMinChenBusiness 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
 
HuaMinChenBusiness 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

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