Post reply

Replication: change schema in subscriber DB?

  • January 13, 2011 at 6:42 pm

    #230242

    Is there a way to have a table end up with a different schema in the subscribing database?

    i.e., PublisherDB.dbo.Holiday table and SubscriberDB.OtherSchema.Holiday table

    It's a transactional publication, if that makes any difference. I've been unable to find this information elsewhere.

  • January 13, 2011 at 7:37 pm

    #1273389

    Easy - just specify the owner for the article (in Article Properties if you are using the create publication wizard). This becomes the schema name when the table is created on the subscriber

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply