How to increase size of a column in a table a subscriber in transactional replication
0 Hi friends, I am working on Transactional Replication. I have requirement to increase the size of a column for few tables at subscriber then I will encrypt it with guid At publisher create table test (col1 varchar(20), col2 varchar(20)) At subscriber Create table test (col1 varchar(100),col2 varchar(100)) I want to increase the size of datatype at subscriber and then add some custom logic to the column for which am increasing the size in the sproc CALL [sp_MSins_dbotest] I want to apply snapshot with this change. How can i do this. Any help would be much appreciated
I do not believe that you can do this at the subscriber. You can change the size of a field at the publisher, and have that replicated. You could then apply your logic on the subscriber. BUT - (yes, there is always a but) if you ever reinitialize the subscription all of your logic will go away.