I am fairly new to using SQL Replication. I am wanting to put replication on a database that is in use constantly. Occasionally I have to do an upgrade to the application that uses this database which may also involve making table changes to this database. What is the preferred method to disabling replication when doing an upgrade? Do you have to totally dismantle replication? Once the upgrade is done do you have to "Reinitialize the replication"? Any help would greatly be appreciated.