Configuring an Oracle Publication

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:

  1. 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: ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial