ReplTalk – Oracle Publishing Error ORA-01455

by Chris Skorlinski, Microsoft SQL Server Escalation Services Oracle Publishing, now deprecated in SQL Server 2014, provides ability to use Oracle server as a Transactional Replication Publisher to a Microsoft SQL Server subscriber. Oracle Publishing Overview http://technet.microsoft.com/en-us/library/ms151229.aspx This feature was as designed as an Oracle to Microsoft SQL Server migration tool.  Other customers used Oracle…


Oracle to SQL Server Replication

Oracle to SQL Server Replication Posted by Chris Skorlinski Microsoft SQL Server Escalation Services Content provided with help of Jonathan Clark, Microsoft SQL Server Escalation Services Oracle to SQL Server replication is used to support customers migrating Oracle legacy application to Microsoft SQL Server.  The data changes in Oracle can be replicated near real-time to…

0

ORA-01830: date format picture ends before converting entire input string

ORA-01830: date format picture ends before converting entire input string Chris Skorlinski Microsoft SQL Server Escalation Services Microsoft SQL Server has the ability to REPLICATE data changes to Oracle.  We see more and more customers migrating to SQL Server, then setting up SQL data Replication to move change SQL data back to a legacy Oracle…

0