CODEWITHSUNDEEP
sql-serversql-server-2008replication
DCNYAM
DCNYAM

Reputation: 12126

SQL Server Replication: Transform replicated data

I have an employee database that is replicated to several other servers. Currently, only the employee ID and name are being replicated. However, the need has arisen to have the last four digits of the SSN replicated as well. The source database contains the entire employee SSN, and I don't want to replicated the entire number.

How can I modify the publication to only replicate the last four digits of the SSN?

Example: Source: 123-45-6789 (int) -> Destination: 6789 (char(4))

EDIT: It should be noted that I cannot modify the schema of the source database. Therefore, I cannot add columns to the source table.

Upvotes: 2

Views: 633

Answers (1)

Joe Stefanelli
Joe Stefanelli

Reputation: 135938

EDIT: Based on additional information provided, I think your option will be to replicate the full column and modify the insert/update stored procedures (dbo.sp_MSins_YourTableName, dbo.sp_MSupd_YourTableName) on the subscriber(s) to take the substring.

Upvotes: 3

Related Questions