Jan 30, 2008

SQL Server replication to Oracle DB

1. SQL EM -> tools -> Replication -> Configure publishing ,Subscribers,Distribution























2. Subscribers tab , click new , choose OLE DB data source



















3. Now , pick your linked server which is oracle DB source


















4. transactional replicaion


















5.

















6. Now , Oracle subscriber appeared in SQL EM subscribers list.

0 意見: