Transactional Replication

• Admingod

  SSCertifiable

  Points: 5997

  More actions

  October 5, 2018 at 4:01 pm

  #379781

  Can you force the column values to replicate which are in lower case to upper case in transactional replication.

  Thanks

• frederico_fonseca

  SSCoach

  Points: 16155

  More actions

  October 6, 2018 at 5:35 pm

  #2008432

  you can if you use a custom script.
  Not advisable and on my opinion it should not be done, and it is no longer replication.
  https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addarticle-transact-sql?view=sql-server-2017
  https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-articles-specify-how-changes-are-propagated?view=sql-server-2017