Post reply

Can a table's schema be changed in replication

  • July 9, 2010 at 10:47 am

    #221073

    Hi, I have replication set up between two servers and would like to know if I can change a table's schema. For example, in the source database (CRM) the table is dbo.Customers but in the destination I want to name the table CRM.Customers. Is this possible. I don't see the option when configuring the article on the publisher.

    Thanks,

    Arturo

  • July 9, 2010 at 10:57 am

    #1190939

    What type of replication?

    Some info: http://msdn.microsoft.com/en-us/library/ms151870%28v=SQL.90%29.aspx

  • July 9, 2010 at 11:17 am

    #1190951

    Transactional Replication. Thanks for the link, it looks very useful.

    The link talks about changes to the object DDL on the publisher and seeing that go through to the subscription via replication. What I want to do is change the owning schema of the table as it is replicated from publisher to subscriber. By default all our tables are owned by the dbo schema on the source databases. I want to specify a different schema as the owner on the target database.

    Thanks,

    Arturo

  • July 9, 2010 at 11:24 am

    #1190959

    I can't find anything that mentions it. I think it's 50-50 it works.

    Do you have a dev environment that dups your setup? I'd get one setup, even in VMs, and see what happens and let us know. I don't have two 2005 instance here, or I'd give it a try.

Viewing 4 posts - 1 through 3 (of 3 total)

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