SQL Server Performance

Disabling Snapshot Replication

Discussion in 'Getting Started' started by lcerni, Jul 13, 2010.

  1. lcerni New Member

    Today I set up Snapshot Replication to replicate some tables from production to development. Then another individual went to rename one of the tables and recreate the replicated table. Is there a way to disable Snapshot Replication (and not delete the whole process) so that the individual can rename the table to x_20100713 and then recreate the table x? Then I would enable Snapshot Replication.
  2. satya Moderator

    What version of SQL Server you are using?
  3. lcerni New Member

    SQL Server 2005
  4. satya Moderator

    As the BOL there are certain conditions that you can perform SCHEMA changes within the replication, such as:
    Replication supports a wide range of schema changes to published objects. When you make any of the following schema changes on the appropriate published object at a Microsoft SQL Server Publisher, that change is propagated by default to all SQL Server Subscribers:
    • ALTER TABLE
      • ALTER VIEW
        • ALTER PROCEDURE
          • ALTER FUNCTION
            • ALTER TRIGGER
          • Schema changes are subject to any restrictions imposed by Transact-SQL. For example, ALTER TABLE does not allow you to ALTER primary key columns. In your case it is a total change of table name itself, so snapshot will fail to generate and you must need to recreate the Replication to take the new changes into affect.

Share This Page