Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sirpskct
Starting Member
3 Posts |
 Posted - 2012-11-21 : 13:03:15
|
| Hi,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. Kindly help on this...Thanks in advance....Thanks,P.Shanthoshkumar. |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2012-11-22 : 03:50:57
|
| 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) |
 |
|
|
sirpskct
Starting Member
3 Posts |
Posted - 2012-11-23 : 02:11:28
|
| Hi Srimami,Thanks for your reply..But the table column name is this(CMS_LEVEL_OF_CARE_WAIVER_AGENT_PHONE)... Thanks,P.Shanthoshkumar. |
|
|
|
namman
Constraint Violating Yak Guru
285 Posts |
Posted - 2012-11-25 : 23:59:27
|
| The column name is too long to Oracle (max 30) |
|
|
|
sirpskct
Starting Member
3 Posts |
Posted - 2012-11-26 : 04:47:34
|
| Hi Namman,Thanks for your reply...can you please guide me how to reduce in replication.Because i am not able to reduce the size in sql side.Thanks,P.Shanthoshkumar. |
|
|
|
|
|
|
Transaction replication issue.