SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Transaction replication issue.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sirpskct
Starting Member

India
3 Posts

Posted - 11/21/2012 :  13:03:15  Show Profile  Reply with Quote
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 - 11/22/2012 :  03:50:57  Show Profile  Reply with Quote
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)
Go to Top of Page

sirpskct
Starting Member

India
3 Posts

Posted - 11/23/2012 :  02:11:28  Show Profile  Reply with Quote
Hi Srimami,

Thanks for your reply..

But the table column name is this(CMS_LEVEL_OF_CARE_WAIVER_AGENT_PHONE)...


Thanks,
P.Shanthoshkumar.
Go to Top of Page

namman
Constraint Violating Yak Guru

USA
263 Posts

Posted - 11/25/2012 :  23:59:27  Show Profile  Reply with Quote
The column name is too long to Oracle (max 30)
Go to Top of Page

sirpskct
Starting Member

India
3 Posts

Posted - 11/26/2012 :  04:47:34  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000