I am new to this forum, So if any thing wrong in my approach kindly correct me. I try to do transactional replication from sql server 2005 to oracle side. Some of the table column name is more than 30 character.I am facing issue while replication is happen. The replication is not accepting and failing.
Please find the below error which i get while looking into monitor.
Invalid column name 'column name' error executing a batch of command.retrying individual command.
Not sure if this helps but try with columns name that has no space (e.g. column name should be [column_name]). Also, change the datatype to Varchar(max)
Transaction replication issue.
Posted - 11/21/2012 : 13:03:15
