August 5, 2015 at 3:08 am
Hi,
I want to extract data from Oracle 11g Standard Edition (AIX UNIX) to SQL Server 2014 for reporting purpose.
(1)Should I use SQL Server Replication?
(2)Is Replication deprecated?
(3)Should I use CDC and SSIS instead?
Thanks a lot.
August 5, 2015 at 3:37 am
I don't have any exprience but this is take from BOL (https://msdn.microsoft.com/en-us/library/ms151149.aspx) "Heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using change data capture and SSIS."
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 5, 2015 at 3:51 am
I already read the web site then I asked the question.
I am very confused.
Does it mean:
(1)"Depreciated" only means: use Oracle (or non SQL Server) as the Publisher?
(2)Or all kinds of SQL Server Replications, either use SQL Server or non-SQL Server will be depreciated ?
August 5, 2015 at 4:02 am
It means that replication between Oracle and SQL Server will be deprecated. Replication between instances of SQL Server will not be deprecated.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 5, 2015 at 10:24 am
Deprecated means it's going to be removed from a future version of the product. It's still there. But, if you build anything based on it, don't be surprised when you attempt to update at some point in the future and what you did is no longer working.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply