Replicating from sql server 2008 to Oracle

[udayk94404]

I am tryign to establish a replication from sql server 2008 to Oracle.

I was able to successfully establish it and i was able to update and delete.

I am having issue with inserts.
I know why it fails.
I have same number of columns and the names are differenet in oracle DB.
But this worked fine in sql server 2000. So i tracked the command int he repl_commands table. The command in sql server 2000 didn't have the column names specified, But 2008 command have column names.

I tried to select the option that said, insert with no column name and saved the article. The option is not gettign saved. I wonder they don't allow that in sql server 2008.

Any idea how do i fix this besides changing the column names in oracle?

Thanks
uday


t

[rmiao]

Better to open case with Microsoft.