Merge Replication: Adding tables, procedures or functions

  • Wow. I got this silly thing working. Not much help from the error messages. I had an abandoned stored procedure that was no longer correct because of a deleted column. When the snapshot was being applied, it would stop here.

    Now, I frequently update the schema programmatically by issuing create table, function or procedure commands. Supposing I create a new table, what would I have to do to get this table replicating (non interactively)?

    [font="Arial"]Halfbubble ------------
    You just can't do this stuff unless you're at least half a bubble off center.[/font]

  • Hi,

    You would just add to publication and create a new snapshot. In terms of on-going changes, you should use ALTER ????? command, as explained in following article:

    http://www.replicationanswers.com/AlterSchema2005.asp

    Hope this helps,

    Phillip Cox

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

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