As mentioned earlier in this chapter, it is possible to replicate an Oracle publication to Microsoft SQL Server 2005. This is a several step process. In order to create an Oracle publication, the following steps must be performed:
Create a replication administrative user. This is done with a SQL Script that Microsoft provides. This script is <drive>:\\Program Files\Microsoft SQL Server\<InstanceName>\MSSQL\Install\oracleadmin.sql. Run this script from the Oracle sqlplus tool:
cd <Install Directory>\<Instance>\MSSQL\Install sqlplus system/password@inst @oracleadmin.sql
This is shown in the following example:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install>sqlplus system/ptc12 3@orcl @oracleadmin SQL*Plus: ...