Home Forums SQL Server 7,2000 Replication Changing of Data type int to Big int in production Database which is used for replication RE: Changing of Data type int to Big int in production Database which is used for replication

  • There is only one option to do it. That is drop the table from Replication and then add it after the alter commands are done.

    To add it there are two options.

    1. Add the Table and re snap shot it.

    2. If down time is possible, then Add the table and dont initialize the table in the subscriber. Since you have the data already in subscriber , there is no need to re initialize the data

    -Roy