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

On the Articles page of the New Publication Wizard or the Publication Properties - <Publication> dialog box, select a table, and then click Article Properties.
Click Set Properties of Highlighted Table Article.
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.
Click OK.