February 10, 2015 at 8:03 am
Hi Experts,
We have a requirement to replicate 40 tables (each abt 3-4gb) from Oracle 10g Database to SQL Server 2012.
I have done some read-up and would like to seek your advise.
1. Understand that Oracle Publisher is deprecated. As such, I doubt it is wise to use this feature. Right?
2. Came across Microsoft Connectors v2.0 for Oracle.
https://technet.microsoft.com/en-us/library/ee470675(v=sql.100).aspx
Some queries:
- Only full refresh supported for this option? Meaning to say, whenever we need to sync the data from oracle to sql server, it will do truncate and perform full loading? Is incremental refresh supported? (meaning to say after a full refresh, it will only replicate "changes").
- To use this option, I will need to manually create the destination table in sql server? (mapping the datatype with oracle columns)?
3. Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity
- this this different from item (2)? what are the difference?
- any step by step tutorial that shows how to use it?
Feel free to share any ideas that I can use to achieve the objective.
thanks!
February 10, 2015 at 8:32 am
SQL Server replication may work. It works fine for me. I have transactional as well as snapshot replication in place.
https://msdn.microsoft.com/en-us/library/ms151243.aspx
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 10, 2015 at 7:07 pm
thanks for the advise.
understand it can still be used in 2014... however it may be deprecated in later release.
https://msdn.microsoft.com/en-us/library/ms151229.aspx
thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply