Add Non-SQL Server Subscriber

Replication supports creating push subscriptions to snapshot and transactional publications for Oracle and IBM DB2 Subscribers.

Options

  • Type of Subscriber to add
    Select an Oracle Subscriber or IBM DB2 Subscriber. For more information about support for these Subscribers, see Non-SQL Server Subscribers.
  • Data source name
    The name used to locate the database on a network. Replication produces a connection string for the database using the data source name, combined with the login, password, and any connection options you specify in the Distribution Agent Security page in this wizard.

    Note

    The data source name and connection string are not validated by Microsoft SQL Server until the Distribution Agent attempts to initialize the subscription.

See Also

Other Resources

How to: Create a Subscription for a Non-SQL Server Subscriber (SQL Server Management Studio)
Non-SQL Server Subscribers
Subscribing to Publications
Replication Properties
Replication Wizards

Help and Information

Getting SQL Server 2005 Assistance