How can we replicate selected tables from Oracle 11g to SQL Server 2008/2012?
Is goldengate the only option?
Anyone have done it before or have the steps to do it?
If you have no budget, you can open a connection directly from SQL Server to Oracle, or vice versa. In Oracle they're called DB links; in SQL Server they're called "linked servers".
Datanamic also have tools that claim to do cross-DB replication. I have no experience with them and this isn't an endorsement - I just know that they exist.