• Article

How to: Specify Data Type Mappings for an Oracle Publisher (SQL Server Management Studio)

Specify data type mappings on the Data Mapping tab of the Article Properties - <Article> dialog box. This is available from the Articles page of the New Publication Wizard and the Publication Properties - <Publication> dialog box. For more information about using the wizard and accessing the dialog box, see How to: Create a Publication from an Oracle Database (SQL Server Management Studio) and How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

To specify a data type mapping

  1. On the Articles page of the New Publication Wizard or the Publication Properties - <Publication> dialog box, select a table, and then click Article Properties.

  2. Click Set Properties of Highlighted Table Article.

  3. On the Data Mapping tab of the Article Properties - <Article> dialog box, select mappings from the Subscriber Data Type column:

    • For some data types there is only one possible mapping, in which case the column in the property grid is read-only.

    • For some types, there is more than one type that you can select. Microsoft recommends that you use the default mapping unless your application requires a different mapping. For more information, see Data Type Mapping for Oracle Publishers.

  4. Click OK.