I am new to replication.
The first thing I have been asked to do is to add encryption to the usual fields in a published database.
The environment is sql server 2000
The publisher there are multiple subscribers and the publisher subscribes to itself.
What I do know:
I know encryption will change datatype and length on the table.
I know this will break replication.
Current status:
I scripted the current replication
Current approach:
Collect ftp account and pasword (some snapshots is deployed via FTP)
Collect article information
exec sp_helparticle
Drop article from every publication
exec sp_droparticle
Encrypt table field
Run script to create articles