Post reply

Snapshot replication to different schema name

  • April 25, 2015 at 10:02 am

    #297359

    I need to setup snapshot replication for 1 large table.

    Source table: SourceDatabaseName.dbo.MyTable1

    Target table: TargetDatabaseName.CustomSchema.MyTable1

    In the above example, how can I specify the target DB's CustomSchema name (it's currently creating dbo, not CustomSchema)

    BT

  • April 26, 2015 at 8:29 am

    #1793519

    When defining the publication I selected "Article Properties" then .. "SET PROPERTIES OF HIGHLIGTABLE ARTICLE"

    One of the options was: DESTINATION OBJECT OWNER

    I set this value to the target owner (schema name)

    BT

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

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