Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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. 

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.