February 27, 2014 at 11:35 am
I heard that SQL Replication will no longer work with Oracle is this true? If so then is it starting with SQL 2012?
March 3, 2014 at 1:02 pm
Does nobody know or is this a stupid question? Please do share if it is a stupid question I can take it. =)
March 3, 2014 at 1:14 pm
JP10 (2/27/2014)
I heard that SQL Replication will no longer work with Oracle is this true? If so then is it starting with SQL 2012?
Yeah this is tru in case of Oracle Publishers. No it works with SQL 2012. NOT in SQL 2014.
http://technet.microsoft.com/en-us/library/ms151229.aspx
--
SQLBuddy
March 3, 2014 at 1:47 pm
Awesome thank you SQLBuddy!
March 3, 2014 at 1:57 pm
You are welcome JP 🙂
--
SQLBuddy
April 6, 2014 at 8:25 am
was googling questions about Oracle to SQL Server Enterprise (which we use extensively) and found this.
Yes it works. I built a test system and verified it. One thing i could not get to work and is of less importance is, i could not get a pluggable db in Oracle 12c to replicate to SQL Server. It 'sees' the table but gets errors complaining that the table has no primary key constraint.
it is 'deprecated' in 2014, as it was in 2012 so supposedly it will disappear eventually, just not yet.
my familiarity with this capability in SQL Server extends to being able to execute schema changes to published Oracle tables and have those changes also happen in SQL server. Something that supposedly is 'not possible'.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply