O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required