I have a SQL Server 2005 database as a publisher. I am replicating a few tables to a SQL Server 2008 instance, using a 2012 instance as the distributor. The developer involved wants to know if he can add columns to the table on the subscriber. The purpose of that is to store the existing timestamp and have an additional column where that timestamp is converted and stored as an integer for comparison to an integer value in a table in another database as part of a synching operation. Alternatively, he has asked about adding a uniqueidentifier column to this table for the same purpose.
Is it possible to do this without breaking the replication?